Ngemuva kwezinyanga eziyisi-6 zokuthuthuka, ukukhishwa kokuqala okuzinzile kwegatsha elisha le-DBMS MariaDB 10.7 (10.7.2) kushicilelwe, lapho kuthuthukiswa igatsha le-MySQL eligcina ukuhambisana okubuyela emuva futhi lihlukaniswa nokuhlanganiswa kwesitoreji esengeziwe. izinjini kanye namakhono athuthukile. Ukuthuthukiswa kwe-MariaDB kwenganyelwe i-MariaDB Foundation ezimele, kulandela inqubo yentuthuko evuleleke ngokuphelele futhi esobala ezimele kubathengisi ngabanye. I-MariaDB ihlinzekwa 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.
Ngesikhathi esifanayo, ukukhishwa kokuhlolwa kokuqala kwegatsha elikhulu elilandelayo le-MariaDB 10.8.1 kanye nezibuyekezo zokulungisa 10.6.6, 10.5.14, 10.4.23, 10.3.33 kanye ne-10.2.42 zikhishwe. Ukukhishwa okungu-10.7.2 bekungokokuqala ngemva kokuba iphrojekthi ishintshele kumodeli entsha yokukhiqiza ukukhishwa, okwakusho ukuncipha kwesikhathi sokusekelwa kusukela eminyakeni emi-5 ukuya onyakeni ongu-1 kanye nokushintshela ekwakhiweni kokukhishwa okubalulekile hhayi kanye ngonyaka, kodwa kanye ngekota. .
Ukuthuthukiswa Okubalulekile ku-MariaDB 10.7:
- Kwengezwe uhlobo olusha lwedatha ye-UUID eklanyelwe ukugcina Izihlonzi Eziyingqayizivele ezingu-128-bit.
- Kuphakanyiswe imisebenzi emisha yokucubungula idatha ngefomethi ye-JSON: JSON_EQUALS() ukuze kuqhathaniswe ubunikazi bamadokhumenti e-JSON amabili kanye ne-JSON_NORMALIZE() yokuletha izinto ze-JSON efomini elifanele ukwenza imisebenzi yokuqhathanisa (okhiye bokuhlunga nokukhipha izikhala).
- Kwengezwe umsebenzi we-NATURAL_SORT_KEY() wokuhlunga uchungechunge ngokucabangela amanani edijithali (isibonelo, uchungechunge “v10” ngemva kokuhlunga luzokwenzeka ngemva kweyunithi yezinhlamvu ethi “v9”).
- Kwengezwe umsebenzi we-SFORMAT() wokufometha okungenasisekelo kweyunithi yezinhlamvu - okokufaka kuyiyunithi yezinhlamvu enemiyalo yokufometha kanye nohlu lwamanani okushintshana ngalo (isibonelo, 'SFORMAT("Impendulo ithi {}.", 42)').
- Ukubika iphutha elithuthukisiwe ku-INSERT imibuzo engeza idatha emigqeni eminingi (umyalo othi GET DIAGNOSTICS manje ubonisa impahla engu-ROW_NUMBER ebonisa inombolo yomugqa enephutha).
- I-plugin entsha yokuhlola iphasiwedi, i-password_reuse_check, ifakiwe, ekuvumela ukuthi ukhawulele ukusetshenziswa kabusha kwamaphasiwedi ngomsebenzisi oyedwa (uhlola ukuthi iphasiwedi entsha ayifani yini namagama ayimfihlo asetshenziswe ngesikhathi esishiwo ipharamitha ye-password_reuse_check_interval).
- Kwengezwe ukusekelwa kwamagama athi “ITHEBULA LOKUSHINTSHA ... GUQULA ISIQEPHU .. ESITHABENI” kanye nokuthi “ITHEBULA LOKUSHINTSHA ... GUQULA ITHEBULA ... LIBE LIHLUKANISE” ukuze kuguqulwe isahlukaniso sibe ithebula futhi okuphambene nalokho.
- Inketho ethi “--as-of” yengezwe kusisetshenziswa sokulahla i-mariadb ukuze kulahlwe ukulahlwa okuhambisana nesimo esithile sethebula lenguqulo.
- Ku-MariaDB Galera Cluster, izifunda ezintsha "ezilindele ukukhishwa zizodwa", "ilinde i-TOI DDL", "ilinde ukulawulwa kokugeleza" kanye "nokulinda ukuqinisekiswa" zisetshenziswa kokuthi PROCESSLIST.
- Ipharamitha entsha “yokuhlela kabusha” yengezwe kusilungiseleli. Ochungechungeni lwamabhayithi amaningi, ukusebenza kolwazi lokufaniswa kwencazelo yezinhlamvu emisebenzini yebanga le-ASCII kuthuthukisiwe.
- Isitoreji se-InnoDB sithuthukise ukusebenza kokusebenza kokufakwa kwenqwaba, i-presorting, nokwakhiwa kwenkomba.
- 5 ubungozi bulungisiwe, imininingwane yakho engadalulwanga: CVE-2022-24052, CVE-2022-24051, CVE-2022-24050, CVE-2022-24048, CVE-2021-46659.
- Phakathi kwezinguquko ekukhishweni kokuhlola kwe-MariaDB 10.8.1, singaqaphela ukuqaliswa kwezinkomba ezihlungwe ngohlelo olwehlayo, olungathuthukisa kakhulu ukusebenza kwe-ORDER BY imisebenzi lapho kulandwa ngokulandelana okuhlanekezelwe. Kwengezwe izichazi ze-IN, OUT, INOUT kanye ne-IN OUT zemisebenzi egciniwe. Ku-InnoDB, inani lemisebenzi yokubhala lapho imisebenzi yokugawula ibuyisela emuva (yenza kabusha) incishisiwe.
Source: opennet.ru