Kutulutsidwa koyamba kokhazikika kwa nthambi yatsopano ya DBMS MariaDB 10.9 (10.9.2) kwasindikizidwa, momwe nthambi ya MySQL ikupangidwira yomwe imasunga kuyanjana kwa m'mbuyo ndipo imasiyanitsidwa ndi kuphatikiza kwa injini zosungirako zowonjezera ndi luso lapamwamba. Kukula kwa MariaDB kumayang'aniridwa ndi MariaDB Foundation yodziyimira payokha, kutsatira njira yotseguka komanso yowonekera bwino yomwe ili yodziyimira pawokha kwa ogulitsa. MariaDB imaperekedwa m'malo mwa MySQL m'magawo ambiri a Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) ndipo yakhala ikugwiritsidwa ntchito m'mapulojekiti akuluakulu monga Wikipedia, Google Cloud SQL ndi Nimbuzz.
Zosintha zazikulu mu MariaDB 10.9:
- Onjezani ntchito ya JSON_OVERLAPS, yomwe imakupatsani mwayi wodziwa mphambano muzolemba ziwiri za JSON (mwachitsanzo, zimakhala zowona ngati zolemba zonse zili ndi zinthu zomwe zili ndi makiyi / mtengo wofanana kapena magulu ofanana).
- Mawu a JSONPath amapereka kuthekera kofotokozera masinthidwe (mwachitsanzo, "$[1 mpaka 4]" kuti agwiritse ntchito magulu 1 mpaka 4) ndi ma index olakwika (mwachitsanzo, "SELECT JSON_EXTRACT(JSON_ARRAY(1, 2, 3), '$ [- 1]');" kusonyeza chinthu choyamba kuchokera kumchira).
- Anawonjezera pulogalamu yowonjezera ya Hashicorp Key Management kuti mubise deta pamatebulo pogwiritsa ntchito makiyi osungidwa mu Hashicorp Vault KMS.
- Chida cha mysqlbinlog chimapereka zosankha zatsopano "--do-domain-ids", "-ignore-domain-ids" ndi "-ignore-server-ids" posefa ndi gtid_domain_id.
- Anawonjezera kuthekera kowonetsa kusintha kwa boma la wsrep mu fayilo yosiyana mu mtundu wa JSON, womwe ungagwiritsidwe ntchito pamakina owunikira akunja.
- Thandizo lowonjezera la "SHOW ANALYZE [FORMAT=JSON]" kuti litulutsidwe mumtundu wa JSON.
- Mawu akuti "SHOW EXPLAIN" tsopano akugwirizana ndi mawu akuti "KUFOTOKOZA KWA KULUMIKIZANA".
- Zosintha za innodb_change_buffering ndi zakale zatsitsidwa (zosinthidwa ndi old_mode variable).
Source: opennet.ru