Kaddamar da ingantaccen sigar farko ta sabon reshen DBMS MariaDB 10.9 (10.9.2), wanda a cikinsa ake haɓaka reshe na MySQL wanda ke kula da dacewa da baya kuma an bambanta shi ta hanyar haɗakar ƙarin injunan ajiya da abubuwan ci gaba.
Gidauniyar MariaDB mai zaman kanta ce ke kula da haɓakar ci gaban MariaDB, bin tsarin ci gaba gabaɗaya da buɗe ido, mai zaman kansa daga kowane dillalai.
MariaDB yana jigilar kayayyaki maimakon MySQL akan yawancin rarrabawar Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) kuma manyan ayyuka sun karbe su.
Babban sabon fasalin MariaDB 10.9
A cikin wannan sabon sigar na MariaDB, an haskaka hakan an ƙara aikin JSON_OVERLAPS don gano tsaka-tsakin bayanai na takaddun JSON guda biyu (misali, yana dawowa gaskiya idan duk takaddun sun ƙunshi abubuwa tare da maɓalli/ƙimar gama gari ko abubuwan tsararru na gama gari).
Har ila yau, an nuna cewa an yi gyare-gyaren da suka dace don rashin lafiyar tsaro kamar haka: CVE-2022-32082, CVE-2022-32089, CVE-2022-32081, CVE-2018-25032, CVE-2022-32091 y CVE-2022-32084
Wani canjin da ya fito waje shine maganganun JSONPath yana ba da ikon tantance jeri (misali "$[1 zuwa 4]" don amfani da abubuwan tsararru 1 zuwa 4) da fihirisa mara kyau don nuna kashi na farko a cikin jerin gwano).
Baya ga wannan, zamu iya gano cewa Hashicorp Key Management plugin an ƙara shi don ɓoye bayanai a cikin tebur ta amfani da maɓallan da aka adana a Hashicorp Vault KMS.
Duk da yake don amfani mysqlbinlog, yanzu kuna da sabbin zaɓuɓɓuka "-do-domain-ids", "-kula-lalle-domain-ids" da "-kula da-sabar-ids" don tace ta gtid_domain_id.
An ƙara ikon yin nuni da masu canjin jihar wsrep a cikin wani fayil na JSON daban wanda tsarin sa ido na waje zai iya amfani da shi.
Optimizer yana amfani da duk ɓangarori bayan haɓakawa zuwa 10.3, don UPDATE mai yawan tebur ko tambayoyi, mai ingantawa ya kasa amfani da inganta aikin yanki don sabunta ko sharewa.
Bayan haka, ya aiwatar da koma baya na inganta kewayo don maɓallin IN (const, ....), An riga an sami matsala a cikin MariaDB 10.5.9 kuma daga baya yana da gyara don MDEV-9750. Wannan maganin ya gabatar da Optimizer_max_sel_arg_weight. Idan mutum ya saita Optimizer_max_sel_arg_weight zuwa ƙima mai girma ko sifili (ma'ana "mara iyaka") kuma yana gudanar da tambayoyin da ke samar da hotuna masu nauyi, suna iya lura da jinkirin aiki.
Sauran gyare-gyare wanda aka yi a cikin wannan sabon sigar na MariaDB, yana cikin cin hanci da rashawa na InnoDB saboda rashin kulle fayil, haka kuma gyara a ALTER TABLE SHIGO DA TABLESPACE wanda ya lalata tebur da aka rufaffen, kuma gyarawa ALTER TABLE fitowar kuskure, gyaran gyare-gyaren tarwatsewa, gyare-gyaren dawo da kuskuren DD, hana makullai a kan gurbatattun bayanai, ƙayyadaddun ƙayyadaddun bug bug gyare-gyare, da gyaran kwaro.
Na sauran canje-canje wanda ya fice daga wannan sabon sigar:
- Ƙara goyon baya ga yanayin "SHOW PARCEL [FORMAT=JSON]" don fitowar JSON.
- Bayanin "NUNA BAYYANA" yanzu yana goyan bayan tsarin "bayani DON HADA".
- Masu canjin innodb_change_buffering da tsoffi an soke su (maye gurbinsu da m old_mode).
- CIKAKKEN RUBUTU bincike tare da ridda da kalmomi na dole
- Optimizer yana amfani da duk ɓangarori bayan haɓakawa zuwa 10.3
- Don UPDATE mai yawan tebur ko tambayoyi, mai ingantawa ya kasa amfani da inganta aikin yanki don sabunta ko gogewa.
- Sabon zaɓi na abokin ciniki na mariadb, -enable-cleartext-plugin. Zaɓin ba ya yin komai kuma yana don dalilai na daidaitawa na MySQL kawai.
- Kulle kan JSON_EXTRACT
ALTER TABLE ALGORITHM=NOCOPY baya aiki bayan haɓakawa - Uwar garken ta kasa KIRKIRO DUBI tare da ginshiƙin da ba a sani ba a cikin ON yanayin
- The password_reuse_check plugin yana haɗa sunan mai amfani da kalmar sirri
- Dangane da Manufar Deprecation na MariaDB, wannan zai zama sigar ƙarshe na MariaDB 10.9 don Debian 10 "Buster" don ppc64el
A ƙarshe, idan kuna sha'awar ƙarin sani game da wannan sabon sigar, kuna iya duba cikakkun bayanai a mahada mai zuwa.