Mushure memwedzi mitanhatu yekuvandudzwa, kusunungurwa kwekutanga kwakagadzikana kwebazi idzva reDBMS MariaDB 6 (10.7) rakadhindwa, mukati umo bazi reMySQL riri kugadzirwa rinochengetedza kuwirirana kumashure uye rinosiyaniswa nekubatanidzwa kwekuwedzera kuchengetedza. injini uye unyanzvi hwepamusoro. Kubudirira kweMariaDB kunotariswa neiyo yakazvimirira MariaDB Foundation, ichitevera yakavhurika uye yakajeka yekuvandudza maitiro ayo akazvimirira kune ega vatengesi. MariaDB inopihwa sechinzvimbo cheMySQL mune dzakawanda Linux kugoverwa (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) uye yakaitwa mumapurojekiti makuru seWikipedia, Google Cloud SQL uye Nimbuzz.
Panguva imwecheteyo, muedzo wekutanga wekubudiswa kwebazi guru rinotevera reMariaDB 10.8.1 uye kugadzirisa kugadzirisa 10.6.6, 10.5.14, 10.4.23, 10.3.33 uye 10.2.42 zvakasunungurwa. Kuburitswa 10.7.2 yaive yekutanga mushure mekunge purojekiti ichichinjira kune nyowani yekuburitsa chizvarwa modhi, iyo yaireva kuderedzwa kwenguva yerutsigiro kubva pamakore mashanu kuenda ku5 gore uye shanduko yekuumbwa kweakakosha kuburitswa kwete kamwe pagore, asi kamwe chete pakota. .
Kuvandudza kwakakosha muMariaDB 10.7:
- Yakawedzera rudzi rutsva rweUUID data rakagadzirirwa kuchengetedza 128-bit Unique Identifiers.
- Mashandiro matsva akakurudzirwa kuti agadzirise data mumhando yeJSON: JSON_EQUALS() yekuenzanisa kuzivikanwa kwemagwaro maviri eJSON uye JSON_NORMALIZE() yekuunza zvinhu zveJSON mufomu yakakodzera kuita ma operations ekuenzanisa (kuronga makiyi nekubvisa nzvimbo).
- Yakawedzera iyo NATURAL_SORT_KEY () basa rekugadzirisa tambo uchifunga nezvedhijitari kukosha (semuenzaniso, tambo "v10" mushure mekurongedza ichaitika mushure metambo "v9").
- Yakawedzera iyo SFORMAT () basa rekugadzirisa zvisina tsarukano tambo - iyo inopinza itambo ine fomati yemirairo uye runyorwa rwezvakakosha zvekutsiva (semuenzaniso, 'SFORMAT("Mhinduro ndeye {}.", 42)').
- Yakanatsiridza kukanganisa kushuma muINSERT mibvunzo inowedzera data kumitsara yakawanda (iyo GET DIAGNOSTICS command wave kuratidza ROW_NUMBER pfuma inoratidza nhamba yemutsara ine kukanganisa).
- A new password checking plugin, password_reuse_check, inosanganisirwa, iyo inokubvumira kudzikamisa kushandiswazve kwepassword nemushandisi mumwe (kutarisa kuti password nyowani haienderane nemapassword anoshandiswa panguva yakatsanangurwa password_reuse_check_interval parameter).
- Yakawedzerwa tsigiro yemazwi okuti “ALTER TABLE ... SHANDURA CHIKAMU .. KUTAFURA” uye “ALTER TABLE ... SHANDURA TABHERA ... KUCHIKAMURA” pakushandura chiganhuro kuita tafura zvichipesana.
- Iyo "--as-of" sarudzo yakawedzerwa kune mariadb-dump utility yekurasa marara inoenderana neimwe mamiriro etafura yakashandurwa.
- Kune MariaDB Galera Cluster, nyika itsva "inomirira kuuraya iri yega", "kumirira TOI DDL", "kumirira kudzora kuyerera" uye "kumirira certification" inoiswa muPROCESSLIST.
- Iyo itsva parameter "reorder" yakawedzerwa kune optimizer. Kune akawanda-byte tambo, kuita kwehunhu hunoreva-kuziva kuenzanirana muASCII renji mashandiro akagadziridzwa.
- InnoDB chengetedzo yakavandudza kuita kwebatch yekuisa mashandiro, presorting, uye index kuvaka.
- 5 kusasimba kwakagadziriswa, izvo zvisati zvaburitswa pachena: CVE-2022-24052, CVE-2022-24051, CVE-2022-24050, CVE-2022-24048, CVE-2021-46659.
- Pakati peshanduko mukuburitswa kwebvunzo yeMariaDB 10.8.1, tinogona kucherechedza kushandiswa kwemaindex akarongwa mukudzika kurongeka, izvo zvinogona kuvandudza zvakanyanya mashandiro eORDER BY mashandiro kana uchitora mune reverse order. Yakawedzerwa IN, OUT, INOUT uye IN OUT zvirevo zvemabasa akachengetwa. MuInnoDB, iyo nhamba yekunyora mashandiro kana matanda mabasa rollback (redo) akaderedzwa.
Source: opennet.ru