Emva kweenyanga ezintandathu zophuhliso, ukukhutshwa kokuqala okuzinzileyo kwesebe ledatha elitsha leMariaDB 10.7 (10.7.2) kupapashwe. Eli sebe liqonga leMySQL eligcina ukuhambelana okungasemva kwaye libonisa ukuhlanganiswa kweenjini zokugcina ezongezelelweyo kunye neempawu eziphambili. Uphuhliso lweMariaDB lujongwa yiMariaDB Foundation ezimeleyo, elandela inkqubo yophuhliso evulekileyo necacileyo ngaphandle komthengisi ngamnye. IMariaDB ithunyelwa njengendawo yeMySQL kwiindawo ezininzi zokusasaza. Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) kwaye iphunyezwe kwiiprojekthi ezinkulu ezifana neWikipedia, iGoogle Cloud SQL kunye neNimbuzz.
Ngexesha elifanayo, ukukhutshwa kovavanyo lokuqala lwesebe elikhulu elilandelayo likaMariaDB 10.8.1 kunye nokuhlaziywa kokulungiswa kwe-10.6.6, 10.5.14, 10.4.23, 10.3.33 kunye ne-10.2.42 yakhululwa. Ukukhutshwa kwe-10.7.2 yayiyeyokuqala emva kokuba iprojekthi itshintshelwe kwimodeli entsha yokukhululwa, eyayithetha ukunciphisa ixesha lokuxhasa ukusuka kwi-5 iminyaka ukuya kwi-1 ngonyaka kunye nokuguqulwa kokwakhiwa kokukhutshwa okubalulekileyo kungekhona kanye ngonyaka, kodwa kanye ngekota. .
Uphuculo oluphambili kwi-MariaDB 10.7:
- Kongezwe uhlobo olutsha lwedatha ye-UUID eyilelwe ukugcina i-128-bit ye-Unique Identifiers.
- Imisebenzi emitsha iye yacetywa ukusetyenzwa kwedatha kwifomathi ye-JSON: JSON_EQUALS () yokuthelekisa isazisi samaxwebhu amabini e-JSON kunye ne-JSON_NORMALIZE () yokuzisa izinto ze-JSON kuhlobo olulungele ukwenza imisebenzi yothelekiso (izitshixo zokuhlela nokususa izithuba).
- Yongeza i NATURAL_SORT_KEY () umsebenzi wokuhlela imitya ethathela ingqalelo amaxabiso edijithali (umzekelo, umtya "v10" emva kokhetho luyakwenzeka emva komtya "v9").
- Yongezwe i SFORMAT () umsebenzi wofomato olungenasizathu lwemitya - igalelo luludwe olunemiyalelo yokufomatha kunye noluhlu lwamaxabiso okubuyisela endaweni (umzekelo, 'SFORMAT("Impendulo ithi {}.", 42)').
- Imposiso ephuculweyo yokunika ingxelo kwi-INSERT imibuzo eyongeza idatha kwimiqolo emininzi (umyalelo we-GET DIAGNOSTICS ubonisa impahla ROW_NUMBER ebonisa inombolo yomqolo enempazamo).
- I-plugin entsha yokujonga i-password, i-password_reuse_check, ibandakanyiwe, ekuvumela ukuba unciphise ukusetyenziswa kwakhona kwamagama ayimfihlo ngomsebenzisi omnye (ukukhangela ukuba igama eligqithisiweyo elitsha alihambelani namagama asetyenziswayo ngexesha elichazwe yi-password_reuse_check_interval parameter).
- Inkxaso eyongeziweyo yala mazwi “IITHAYIBHILE GUQULA ISAHLUKO .. UKUFANELEKILE” kunye “ITHAYIBHILE YITSHINTSHA ... IYAHLUKANA” ukuze kuguqulwe isahlulelo sibe yitheyibhile ngokuphambanayo.
- I-"--as-of" ukhetho longezwe kwinto eluncedo yokulahla i-mariadb ukulahla inkunkuma ehambelana nemeko ethile yetafile eguqulelweyo.
- Kwi-MariaDB Galera Cluster, amazwe amatsha "alinde ukuphumeza yedwa", "ukulindela i-TOI DDL", "ukulindela ulawulo lokuhamba" kunye "nokulindela ukuqinisekiswa" kuphunyezwe kwi-PROCESSLIST.
- Iparamitha entsha "yokucwangcisa ngokutsha" yongezwe kwisilungisi. Kwiintambo ze-byte ezininzi, ukusebenza komlinganiso wentsingiselo-ukuqonda okuhambelanayo kwimisebenzi yoluhlu lwe-ASCII kuphuculwe.
- Ukugcinwa kwe-InnoDB kuphuculwe ukusebenza kwe-batch yokufaka imisebenzi, i-presorting, kunye nokwakhiwa kwesalathisi.
- Ubuthathaka be-5 bulungisiwe, iinkcukacha zazo azikachazwa: CVE-2022-24052, CVE-2022-24051, CVE-2022-24050, CVE-2022-24048, CVE-2021-46659.
- Phakathi kweenguqu ekukhutshweni kovavanyo lwe-MariaDB 10.8.1, sinokuqaphela ukuphunyezwa kwezalathisi ezihlelwe ngendlela ehlayo, enokuphucula kakhulu ukusebenza kwe-ORDER BY imisebenzi xa kulandwa ngokulandelelana. Ezongeziweyo IN, OUT, INOUT kunye IN OUT abaxeli bemisebenzi egciniweyo. Kwi-InnoDB, inani lemisebenzi yokubhala xa ukugawulwa kwemisebenzi ye-rollback (redo) kuncitshisiwe.
umthombo: opennet.ru
