Siideynta ugu horreysa ee xasilloon ee laanta cusub ee DBMS MariaDB 10.10 (10.10.2) ayaa la daabacay, taas oo laan ka mid ah MySQL lagu horumarinayo taas oo ilaalinaysa iswaafajinta gadaalka waxaana lagu kala saaraa isku-dhafka matoorada kaydinta dheeraadka ah iyo awoodaha horumarsan. Horumarinta MariaDB waxaa kormeera MariaDB Foundation oo madax-banaan, ka dib hannaan horumarineed oo furan oo hufan oo ka madax bannaan iibiyeyaasha gaarka ah. MariaDB waxaa loo bixiyaa beddelka MySQL qaybiyo badan oo Linux ah (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) waxaana lagu hirgeliyay mashaariicda waaweyn sida Wikipedia, Google Cloud SQL iyo Nimbuzz.
Horumarinta muhiimka ah ee MariaDB 10.10:
- Lagu daray shaqada RANDOM_BYTES si loo helo isku xigxiga baytyada cabbirka la bixiyay.
- Nooca xogta INET4 oo lagu daray si loogu kaydiyo ciwaannada IPv4 ee matalaad 4-byte ah.
- Halbeegyada caadiga ah ee tibaaxaha "BEDDELKA MASTERKA TO" waa la beddelay, kaas oo hadda adeegsada qaab ku celcelin ku salaysan GTID (Global Transaction ID), haddii sayidku uu taageero nooca aqoonsiga. Goobta "MASTER_USE_GTID=Current_Pos" waa la joojiyay oo waa in lagu badalaa "MASTER_DEMOTE_TO_SLAVE" ikhtiyaarka.
- Hagaajinta hagaajinta isku-dhafka hawlgallada oo leh tiro badan oo jaantusyo ah, oo ay ku jiraan awoodda loo isticmaalo "eq_ref" si loo mideeyo miisaska hab kasta.
- Algorithms-yada UCA (Unicode Collation Algoritm) ee la fuliyay, oo lagu qeexay Unicode 14 gaar ah oo loo isticmaalo in lagu go'aamiyo kala-soocidda iyo xeerarka isku midka ah iyadoo la tixgalinayo macnaha jilayaasha (tusaale, marka la kala saarayo qiyamka dhijitaalka ah, joogitaanka laga jaray iyo dhibic horteeda tiro iyo noocyo kala duwan oo higgaad ah ayaa lagu xisaabtamayaa, marka la is barbar dhigona aan la aqbalin ku xisaabtan kiiska jilayaasha iyo joogitaanka calaamadda lahjadda). Waxqabadka la hagaajiyay ee UCA ee hawlaha utf8mb3 iyo utf8mb4.
- Awoodda lagu daro cinwaanka IP-ga liiska Galera Cluster nodes ee loo oggol yahay inay fuliyaan codsiyada SST/IST waa la fuliyay.
- Sida caadiga ah, qaabka "explicit_defaults_for_timestamp" waa la hawlgeliyay si loo soo dhaweeyo habdhaqanka MySQL (marka la fulinayo "SHOW CREATE TABLE" waxa ku jira blocks DEFAULT ee nooca timestamp lama muujin).
- Dhexdhexaadinta khadka taliska, "--ssl" ikhtiyaarka ayaa loo suurtageliyaa si caadi ah (samaynta isku xirka TLS-encrypted waa karti).
- Habaynta CUSBOONAYSIINTA iyo tibaaxaha tirtiridda heerka sare ayaa dib loo habeeyey.
- Hawlaha DES_ENCRYPT iyo DES_DECRYPT iyo doorsoomiyaha innodb_prefix_index_cluster_optimization waa la joojiyay.
Source: opennet.ru