Ukukhutshwa kokuqala okuzinzile kwesebe elitsha le-DBMS MariaDB 10.10 (10.10.2) lishicilelwe, apho isebe le-MySQL liphuhliswa eligcina ukuhambelana ngasemva kwaye lihluke ngokudityaniswa kweenjini zokugcina ezongezelelweyo kunye nobuchule obuphambili. Uphuhliso lwe-MariaDB lujongwa yi-MariaDB Foundation ezimeleyo, ilandela inkqubo yophuhliso evulekileyo necacileyo ezimeleyo kubathengisi ngabanye. I-MariaDB inikezelwa njengokutshintshwa kwe-MySQL kwiindawo ezininzi ze-Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) kwaye iphunyezwe kwiiprojekthi ezinkulu ezifana ne-Wikipedia, i-Google Cloud SQL kunye ne-Nimbuzz.
Uphuculo oluphambili kwi-MariaDB 10.10:
- Yongeza umsebenzi we-RANDOM_BYTES ukufumana ulandelelwano olungenamkhethe lweebhayithi zobungakanani obunikiweyo.
- Kongezwe uhlobo lwedatha ye-INET4 ukugcina iidilesi ze-IPv4 kumboniso we-4-byte.
- Iiparamitha ezingagqibekanga zentetho ethi "CHANGE MASTER TO" itshintshiwe, esebenzisa indlela yophindaphindo esekwe kwiGTID (Global Transaction ID), ukuba umncedisi oyintloko uyaluxhasa olu hlobo lwesichongi. Iseto ethi "MASTER_USE_GTID=Current_Pos" iyekisiwe kwaye kufuneka endaweni yayo kufakwe u-"MASTER_DEMOTE_TO_SLAVE".
- Uphuculo oluphuculweyo lokudibanisa imisebenzi enamanani amakhulu eetafile, kubandakanya ukukwazi ukusebenzisa "eq_ref" ukudibanisa iitafile nangaluphi na ulandelelwano.
- I-UCA ephunyeziweyo (i-Unicode Collation Algoritm) i-algorithms, echazwe kwi-Unicode 14 inkcazo kwaye isetyenziselwa ukumisela imithetho yokuhlelwa kunye nokutshatisa kuthathelwa ingqalelo intsingiselo yabalinganiswa (umzekelo, xa uhlela amaxabiso edijithali, ubukho bothabatha kunye nechaphaza phambi inani kunye neentlobo ezahlukeneyo zopelo zithathelwa ingqalelo, kwaye xa kuthelekiswa akuvunyelwanga kuthathelwe ingqalelo imeko yabalinganiswa kunye nobukho bophawu lwe-accent). Ukusebenza okuphuculweyo kwemisebenzi ye-UCA kwimisebenzi ye-utf8mb3 kunye ne-utf8mb4.
- Ukukwazi ukongeza iidilesi ze-IP kuluhlu lwe-Galera Cluster nodes ezivumelekileyo ukwenza izicelo ze-SST/IST ziphunyeziwe.
- Ngokungagqibekanga, imowudi "explicit_defaults_for_timestamp" yenziwe yasebenza ukusondeza ukuziphatha kufutshane neMySQL (xa uphumeza "BONISA CREATE TABLE" imixholo yeebhloko ze-DEFAULT zodidi lwesitampu aziboniswanga).
- Kujongano lwelayini yomyalelo, "--ssl" ukhetho lwenziwe ngokungagqibekanga (ukuseka imidibaniso efihliweyo ye-TLS yenziwe).
- Uqhubekekiso lwenqanaba eliphezulu UPDATE kunye ne DELETE amabinzana sele esetyenzisiwe.
- Imisebenzi ye-DES_ENCRYPT kunye ne-DECRYPT kunye ne-innodb_prefix_index_cluster_optimization variable ziye zarhoxiswa.
umthombo: opennet.ru