Ukwethulwa kwe- inguqulo yokuqala ezinzile yegatsha le-DBMS elisha UMariaDB 10.9 (10.9.2), lapho kuthuthukiswa khona igatsha le-MySQL eligcina ukuhambisana emuva futhi lihlukaniswa ngokuhlanganiswa kwezinjini zokulondoloza ezengeziwe nezici ezithuthukisiwe.
Ukuthuthukiswa kwe-MariaDB kwenganyelwe i-MariaDB Foundation ezimele, kulandela inqubo yentuthuko evuleleke ngokuphelele futhi esobala, engazimele kubathengisi ngabanye.
Imikhumbi kaMariaDB esikhundleni se-MySQL ekusatshalalisweni kweLinux okuningi (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) futhi yamukelwe amaphrojekthi amakhulu.
Izici ezintsha eziyinhloko zeMariaDB 10.9
Kule nguqulo entsha ye-MariaDB, kugqanyiswe lokho wengeze umsebenzi we-JSON_OVERLAPS ukuze kutholwe ukuphambana kwedatha yamadokhumenti amabili e-JSON (ngokwesibonelo, ibuyisela iqiniso uma womabili amadokhumenti equkethe izinto ezinokhiye ovamile/inani eliphekwe noma izici ezifanayo zamalungu afanayo).
Futhi, kuyagqanyiswa ukuthi ukulungiswa okufanelekile kwenziwe ngenxa yobungozi obulandelayo bokuvikeleka: I-CVE-2022-32082, I-CVE-2022-32089, I-CVE-2022-32081, I-CVE-2018-25032, I-CVE-2022-32091 y I-CVE-2022-32084
Olunye ushintsho olugqamayo ukuthi izinkulumo I-JSONPath inikeza ikhono lokucacisa ububanzi (isb. "$[1 kuya ku-4]" ukusebenzisa izakhi zamalungu afanayo 1 kuye ku-4) nezinkomba ezinegethivu ukuze kuboniswe isici sokuqala kulayini).
Ngaphezu kwalokhu, singathola ukuthi i-plugin ye-Hashicorp Key Management yengezwe ukuze kubethele idatha kumathebula kusetshenziswa okhiye abagcinwe ku-Hashicorp Vault KMS.
Ngenkathi okokusebenza mysqlbinlog, manje unezinketho ezintsha “-do-domain-ids”, “-ignore-domain-ids” kanye “-ignore-server-ids” ukuze zihlungwe nge-gtid_domain_id.
Kwengezwe amandla okubonisa okuguquguqukayo kwesimo se-wsrep kufayela elihlukile le-JSON elingasetshenziswa amasistimu okuqapha angaphandle.
I-Optimizer isebenzisa zonke izingxenye ngemuva kokuthuthukela ku-10.3, ngemibuzo enamathebula amaningi UKUBUYISA noma SUSA, isilungiseleli asikwazanga ukusebenzisa ukunqunywa kwengxenye ukuze ithebula libuyekezwe noma lisuswe.
Ngaphandle kwalokho, yenze ukuhlehla kwesilungiseleli sobubanzi kukhiye ongu-IN (const, ....), besekuvele kunenkinga ku-MariaDB 10.5.9 futhi kamuva esinokulungiswa kwe-MDEV-9750. Leso sixazululo sethule i-Optimizer_max_sel_arg_weight. Uma umuntu esetha i-Optimizer_max_sel_arg_weight kunani eliphezulu kakhulu noma uziro (okusho ukuthi "okungenamkhawulo") futhi esebenzisa imibuzo ekhiqiza amagrafu asindayo, angase aqaphele ukusebenza kancane.
Okunye ukulungisa ezenziwe kule nguqulo entsha ye-MariaDB, usenkohlakalweni ye-InnoDB ngenxa yokuntuleka kokukhiya ifayela, kanye ukulungiswa kokuthi ALTER TABLE IMPORT TABLESPACE onakalise ithebula elibethelwe, futhi yalungisa ALTER TABLE okukhiphayo okungalungile, ukulungiswa kokutholwa kokuphahlazeka, ukulungiswa kokutholwa kwephutha le-DD, izikhiya ezivinjiwe kudatha eyonakele, ukulungiswa kweziphazamisi zokulayisha ngobuningi obulungisiwe, nokusebenza kokulungiswa kweziphazamisi.
Kwezinye izinguquko okuvelele kule nguqulo entsha:
- Kwengezwe usekelo lwemodi ethi "SHOW PARCEL [FORMAT=JSON]" yokuphuma kwe-JSON.
- Isitatimende esithi "BONISA INCAZELO" manje sisekela i-syntax "CHAZA NGOKUXHUMANA".
- Okuguquguqukayo kwe-innodb_change_buffering nokudala kwehlisiwe (kuthathelwe indawo yi-old_mode eguquguqukayo).
- Ukusesha UMBHALO OGCWELE nge-aphostrophe namagama ayimpoqo
- I-Optimizer isebenzisa zonke izingxenye ngemuva kokuthuthukela ku-10.3
- Ngemibuzo enamathebula amaningi okuthi UPDATE noma SUSA, isilungiseleli asikwazanga ukusebenzisa ukunqunywa kwe-partitioning ukuze ithebula libuyekezwe noma lisuswe.
- Inketho entsha yeklayenti le-mariadb, -enable-cleartext-plugin. Inketho ayenzi lutho futhi ingeyezinjongo zokuhambisana ne-MySQL kuphela.
- Khiya ku-JSON_EXTRACT
ALTER TABLE ALGORITHM=NOCOPY ayisebenzi ngemva kokuthuthukiswa - Iseva yehlulekile UKUDALA UKUBUKA ngekholomu engaziwa kusimo esithi ON
- I-plugin ye-password_reuse_check ihlanganisa igama lomsebenzisi nephasiwedi
- Ngokwenqubomgomo Yokuhoxiswa kwe-MariaDB, lena kuzoba inguqulo yokugcina ye-MariaDB 10.9 ye-Debian 10 "Buster" ye-ppc64el
Okokugcina, uma ungathanda ukwazi okwengeziwe ngale nguqulo entsha, ungabheka imininingwane kokuthi isixhumanisi esilandelayo.