Ukuphehlelelwa inguqulelo yokuqala ezinzileyo yesebe elitsha le-DBMS UMariaDB 10.9 (10.9.2), ngaphakathi apho isebe le-MySQL liphuhliswa eligcina ukuhambelana ngasemva kwaye lihluke ngokudityaniswa kweenjini zokugcina ezongezelelweyo kunye neempawu eziphambili.
Uphuhliso lwe-MariaDB lujongwa yi-MariaDB Foundation ezimeleyo, ilandela inkqubo yophuhliso evulelekileyo necacileyo, ezimeleyo kubathengisi ngabanye.
Iinqanawa ze-MariaDB endaweni ye-MySQL kwiindawo ezininzi ze-Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) kwaye yamkelwe ngamaprojekthi amakhulu.
Iimpawu ezintsha eziphambili zikaMariaDB 10.9
Kule nguqulo intsha ye-MariaDB, igxininisiwe ukuba yongeze umsebenzi we-JSON_OVERLAPS ukubona ukudityaniswa kwedatha yamaxwebhu amabini e-JSON (umzekelo, ibuyisela eyinyani ukuba omabini amaxwebhu aqulathe izinto ezineqhosha eliqhelekileyo/ixabiso lesibini okanye uluhlu oluqhelekileyo lweziqalelo).
Kwakhona, kugxininiswa ukuba izilungiso ezifanelekileyo zenzelwe obu buthathaka bulandelayo bokhuseleko: ICVE-2022-32082, ICVE-2022-32089, ICVE-2022-32081, ICVE-2018-25032, I-CVE-2022-32091 y I-CVE-2022-32084
Olunye utshintsho olubalaseleyo kukuba amabinzana I-JSONPath ibonelela ngokukwazi ukukhankanya uluhlu (umz. "$[1 ukuya 4]" ukusebenzisa uluhlu lweziqalelo 1 ukuya 4) kunye nezalathisi ezilandulayo ukubonisa into yokuqala emgceni).
Ukongeza koku, sinokufumanisa ukuba i-plugin ye-Hashicorp Key Management yongezwa kwi-encrypt data kwiitafile usebenzisa izitshixo ezigcinwe kwi-Hashicorp Vault KMS.
Ngexesha loncedo mysqlbinlog, ngoku unokhetho olutsha “-do-domain-ids”, “-ignore-domain-ids” kunye “-ignore-server-ids” ukucoca nge-gtid_domain_id.
Ukongezwa ukukwazi ukubonakalisa i-wsrep variables kwifayile eyahlukileyo ye-JSON enokusetyenziswa yinkqubo yokubeka iliso yangaphandle.
I-Optimizer isebenzisa zonke izahlulo emva kokuphucula ukuya kwi-10.3, kwimibuzo ye-multi-table UKUHLAZIYA okanye UKUCIMA, isilungisi asikwazanga ukusebenzisa i-partition pruning optimization yetafile ehlaziywayo okanye icinywe.
Ngaphandle koko, yenze uluhlu lwe-optimizer ubuyiselo lweqhosha elingu-IN (const, ....), bekukho umcimbi kwi-MariaDB 10.5.9 kwaye kamva inokulungiswa kwe-MDEV-9750. Eso sisombululo sazisa i-Optimizer_max_sel_arg_weight. Ukuba umntu useta i-Optimizer_max_sel_arg_weight kwixabiso eliphezulu kakhulu okanye u-zero (okuthetha ukuthi "unlimited") kwaye uqhuba imibuzo evelisa iigrafu ezinzima, banokuqaphela ukusebenza okucothayo.
Ezinye izilungiso ezenziwe kule nguqulo entsha ye-MariaDB, ikwi-InnoDB urhwaphilizo ngenxa yokunqongophala kokuvalwa kwefayile, ngokunjalo ukulungiswa kwi-ALTER TABILE IMPORT TABLESPACE yonakalise itafile entsonkothileyo, nayo elungisiweyo ALTER TABLE imveliso engachanekanga, ulungiso lokufumana kwakhona impazamo, ulungiso lwempazamo yeDD, izitshixo ezithintelweyo kwidatha eyonakeleyo, ukulungiswa kwebug yomthwalo omninzi, kunye nokulungiswa kwebug nokusebenza.
Olunye utshintsho evelele kule nguqulo intsha:
- Inkxaso eyongeziweyo ye-"BONISA IPARCEL [FORMAT=JSON]" kwimveliso ye-JSON.
- Ingxelo ethi "BONISA INKCAZO" ngoku ixhasa "CHAZA NGOQHAGAMSHELO" isintaksi.
- Izinto eziguquguqukayo ze-innodb_change_buffering nezindala ziye zarhoxiswa (kufakwe endaweni yazo yi-old_mode).
- ISICATSHULWA ESIPHELELEYO phendla nge-aphostrophe kunye namagama anyanzelekileyo
- I-Optimizer isebenzisa zonke izahlulo emva kokuphucula ukuya kwi-10.3
- Kwimibuzo yeetheyibhile ezininzi UKUHLAZIYA okanye UKUCIMA, isilungisi asikwazanga ukusebenzisa isahlulelo sokuthena ukuba itheyibhile ihlaziywa okanye icinywe.
- Ukhetho olutsha lomxhasi we-mariadb, -vumela-cleartext-plugin. Inketho ayenzi nto kwaye yenzelwe iinjongo zokuhambelana neMySQL kuphela.
- Tshixa kwi-JSON_EXTRACT
I-ALTER TABLE ALGORITHM=NOCOPY ayisebenzi emva kophuculo - Umncedisi uyasilela UKWENZA VIEW kunye nomhlathi ongaziwayo kwimeko ON
- Igama lokungena_reuse_check lidibanisa igama lomsebenzisi kunye negama lokugqitha
- Ngokomgaqo-nkqubo wokuDeprecation we-MariaDB, le iya kuba yinguqulelo yokugqibela ye-MariaDB 10.9 ye-Debian 10 "Buster" ye-ppc64el
Okokugqibela, ukuba unomdla wokwazi ngakumbi ngale nguqulelo intsha, ungajonga iinkcukacha apha eli khonkco lilandelayo.