Kutanga kwe yekutanga yakagadzikana vhezheni yebazi idzva reDBMS MariaDB 10.9 (10.9.2), mukati umo bazi reMySQL riri kugadzirwa rinochengetedza kumashure kuenderana uye rinosiyaniswa nekubatanidzwa kwemamwe mainjini ekuchengetedza uye maficha epamberi.
Kuvandudzwa kweMariaDB kunotariswa neiyo yakazvimirira MariaDB Foundation, ichitevera yakavhurika uye yakajeka yekuvandudza maitiro, yakazvimirira kune ega vatengesi.
MariaDB ngarava panzvimbo yeMySQL pane dzakawanda Linux kugoverwa (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) uye yakagamuchirwa nemapurojekiti makuru.
Main nyowani maficha eMariaDB 10.9
Muiyi vhezheni itsva yeMariaDB, inosimbiswa kuti yakawedzera JSON_OVERLAPS basa rekuona mharadzano mudata yemagwaro maviri eJSON (semuenzaniso, inodzosera chokwadi kana zvese zvinyorwa zvine zvinhu zvine kiyi yakajairwa/value peya kana zvakajairika array elements).
Zvakare, zvinoratidzwa kuti zvigadziriso zvine chekuita nazvo zvakaitwa nekuda kwekusagadzikana kunotevera: CVE-2022-32082, CVE-2022-32089, CVE-2022-32081, CVE-2018-25032, CVE-2022-32091 y CVE-2022-32084
Imwe shanduko inomira pachena ndeyekuti matauriro JSONPath inopa kugona kutsanangura mitsara (semuenzaniso "$[1 kusvika 4]" kushandisa akatevedzana zvinhu 1 kusvika 4) uye indices dzisina kunaka kuratidza chinhu chekutanga mumutsara).
Pamusoro peizvi, tinogona kuona kuti Hashicorp Key Management plugin yakawedzerwa encrypt data mumatafura uchishandisa makiyi akachengetwa muHashicorp Vault KMS.
Nekuda kwekushandisa mysqlbinlog, ikozvino une sarudzo itsva “-do-domain-ids”, “-ignore-domain-ids” uye “-ignore-server-ids” kusefa ne gtid_domain_id.
Yakawedzera kugona kuratidza wrep mamiriro akasiyana mune yakaparadzana JSON faira iyo inogona kushandiswa nekunze kwekutarisa masisitimu.
Optimizer inoshandisa zvikamu zvese mushure mekusimudzira kusvika 10.3, kune akawanda-tafura UPDATE kana DELETE mibvunzo, iyo optimizer haina kukwanisa kuisa partition pruning optimization yetafura iri kuvandudzwa kana kubviswa.
Kunze kwaizvozvo, yakaita renji yeoptimizer regression yeIN kiyi (const, ....), pakanga patova nenyaya muMariaDB 10.5.9 uye gare gare iyo ine gadziriso yeMDEV-9750. Mhinduro iyoyo yakaunza Optimizer_max_sel_arg_weight. Kana munhu akaseta Optimizer_max_sel_arg_weight kune yakakosha zvakanyanya kana zero (zvinoreva "unlimited") uye achimhanyisa mibvunzo inoburitsa magirafu anorema, vanogona kuona kunonoka kuita.
Zvimwe zvinogadzirisa izvo zvakaitwa mune iyi vhezheni itsva yeMariaDB, iri muInnoDB huori nekuda kwekushayikwa kwefaira kukiya, pamwe chete kugadzirisa muALTER TABLE IMPORT TABLESPACE iyo yakashatisa tafura yakavharidzirwa, yakagadzirisawo ALTER TABLE yakabuda isiriyo, zvigadziriso zvekuputsika, DD kukanganisa kudzoreredza kugadzirisa, kudzivirira kukiya pane yakaora data, yakagadziriswa bulk load bug fixes, uye bug fixes performance.
Yeimwe shanduko izvo zvinoratidzika kubva pane iyi nyowani vhezheni:
- Yakawedzerwa rutsigiro rwe "SHOW PARCEL [FORMAT=JSON]" maitiro ekubuda kweJSON.
- Chirevo che "SHOW TSANANGURA" ikozvino chinotsigira chirevo che" TSANANGURA YEKUBANGANISA" syntax.
- Iwo akasiyana innodb_change_buffering uye ekare akaregwa (akatsiviwa neinosiyana old_mode).
- FULL TEKSTO tsvaga neapostrophe uye mazwi anosungirwa
- Optimizer inoshandisa zvikamu zvese mushure mekusimudzira kusvika 10.3
- Kune akawanda-tafura UPDATE kana DELETE mibvunzo, iyo optimizer haina kukwanisa kuisa partition yekuchekerera optimization kuti tafura iri kuvandudzwa kana kubviswa.
- Nyowani mariadb mutengi sarudzo, -enable-cleartext-plugin. Iyo sarudzo haiite chinhu uye ndeyeMySQL inoenderana zvinangwa chete.
- Kiya paJSON_EXTRACT
ALTER TABLE ALGORITHM=NOCOPY haishande mushure mekusimudzira - Sevha inotadza KUGADZIRA MAONERO nekoramu isingazivikanwe mune ON mamiriro
- Iyo password_reuse_check plugin inosanganisa username nepassword
- Maererano neMariaDB Deprecation Policy, iyi ichave yekupedzisira vhezheni yeMariaDB 10.9 yeDebian 10 "Buster" yeppc64el.
Chekupedzisira, kana iwe uchida kuziva zvakawanda nezve iyi vhezheni itsva, unogona kutarisa ruzivo pa chinotevera chinongedzo.