Ukukhishwa okuzinzile kwe-MariaDB 10.10

Ukukhishwa kokuqala okuzinzile kwegatsha elisha le-DBMS MariaDB 10.10 (10.10.2) kushicilelwe, lapho kuthuthukiswa igatsha le-MySQL eligcina ukuhambisana okubuyela emuva futhi lihlukaniswa ngokuhlanganiswa kwezinjini zokulondoloza ezengeziwe namandla athuthukile. Ukuthuthukiswa kwe-MariaDB kwenganyelwe i-MariaDB Foundation ezimele, kulandela inqubo yentuthuko evulekile nesobala ezimele kubathengisi ngabanye. I-MariaDB ihlinzekwa njengokungena esikhundleni se-MySQL ezindaweni eziningi ezisatshalaliswa ze-Linux (i-RHEL, i-SUSE, i-Fedora, i-openSUSE, i-Slackware, i-OpenMandriva, i-ROSA, i-Arch Linux, i-Debian) futhi isetshenziswe kumaphrojekthi amakhulu njenge-Wikipedia, i-Google Cloud SQL ne-Nimbuzz.

Ukuthuthukiswa Okubalulekile ku-MariaDB 10.10:

• Kwengezwe umsebenzi we-RANDOM_BYTES ukuze uthole ukulandelana okungahleliwe kwamabhayithi kasayizi othile.
• Kwengezwe uhlobo lwedatha ye-INET4 ukuze kugcinwe amakheli e-IPv4 ekumeleleni okungu-4-byte.
• Amapharamitha azenzakalelayo wenkulumo ethi "CHANGE MASTER TO" ashintshiwe, manje esebenzisa imodi yokuphindaphinda esekelwe ku-GTID (I-ID Yokwenziwa Komhlaba Wonke), uma iseva eyinhloko isekela lolu hlobo lwesihlonzi. Isilungiselelo esithi "MASTER_USE_GTID=Current_Pos" sihoxisiwe futhi kufanele sithathelwe indawo inketho ethi "MASTER_DEMOTE_TO_SLAVE".
• Ukulungiselela okuthuthukisiwe kokuhlanganisa imisebenzi enezinombolo ezinkulu zamathebula, okuhlanganisa amandla okusebenzisa i-"eq_ref" ukuhlanganisa amathebula nganoma iyiphi indlela.
• Ama-algorithms e-UCA (Unicode Collation Algoritm) asetshenzisiwe, achazwe esicacisweni se-Unicode 14 futhi asetshenziselwa ukunquma imithetho yokuhlunga nokuqhathanisa kucatshangelwa incazelo yezinhlamvu (isibonelo, lapho uhlela amanani edijithali, ukuba khona kokususa nechashazi phambi inombolo kanye nezinhlobo ezahlukene zesipelingi ziyacatshangelwa, futhi uma ukuqhathanisa akwamukelekile kucatshangelwa indaba yezinhlamvu kanye nokuba khona kophawu lokugcizelela). Ukusebenza okuthuthukisiwe kokusebenza kwe-UCA emisebenzini ye-utf8mb3 kanye ne-utf8mb4.
• Ikhono lokwengeza amakheli e-IP ohlwini lwamanodi e-Galera Cluster avunyelwe ukwenza izicelo ze-SST/IST selisetshenzisiwe.
• Ngokuzenzakalelayo, imodi ye-"explicit_defaults_for_timestamp" iyavulwa ukusondeza ukuziphatha ku-MySQL (uma usebenzisa okuthi "SHOW CREATE TABLE" okuqukethwe kwamabhulokhi DEFAULT ohlobo lwesitembu sesikhathi akuboniswa).
• Kusixhumi esibonakalayo somugqa womyalo, inketho ethi “--ssl” inikwa amandla ngokuzenzakalelayo (ukusungula ukuxhumana okubethelwe kwe-TLS kunikwe amandla).
• Ukucutshungulwa kwezisho eziphezulu ze-UPDATE kanye ne-DELETE sekusetshenzwe kabusha.
• Imisebenzi ye-DES_ENCRYPT kanye ne-DES_DECRYPT kanye nokuhluka kwe-innodb_prefix_index_cluster_optimization kuhoxisiwe.

Source: opennet.ru