Thawj qhov ruaj khov tso tawm ntawm ceg tshiab ntawm DBMS MariaDB 10.9 (10.9.2) tau tshaj tawm, nyob rau hauv uas ib ceg ntawm MySQL tau tsim kho uas tswj kev rov qab sib raug zoo thiab txawv los ntawm kev sib koom ua ke ntawm cov cav ntxiv thiab cov peev txheej siab heev. MariaDB txoj kev txhim kho yog saib xyuas los ntawm MariaDB Foundation ywj pheej, ua raws li cov txheej txheem kev loj hlob qhib thiab pob tshab uas yog ywj siab ntawm tus neeg muag khoom. MariaDB tau muab los ua kev hloov pauv rau MySQL hauv ntau qhov kev faib tawm Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) thiab tau ua tiav hauv cov haujlwm loj xws li Wikipedia, Google Cloud SQL thiab Nimbuzz.
Kev txhim kho tseem ceeb hauv MariaDB 10.9:
- Ntxiv rau JSON_OVERLAPS muaj nuj nqi, uas tso cai rau koj los txiav txim qhov kev sib tshuam hauv cov ntaub ntawv ntawm ob JSON cov ntaub ntawv (piv txwv li, nws rov qab muaj tseeb yog tias ob qho ntaub ntawv muaj cov khoom nrog ib qho tseem ceeb / tus nqi khub lossis cov khoom sib xws).
- JSONPath kab lus muab lub peev xwm los qhia txog ntau yam (piv txwv li, "$[1 txog 4]" siv cov ntsiab lus array 1 txog 4) thiab qhov ntsuas tsis zoo (piv txwv li, "SELECT JSON_EXTRACT(JSON_ARRAY(1, 2, 3), '$ [- 1]');" los tso saib thawj lub ntsiab lus ntawm tus Tsov tus tw).
- Ntxiv Hashicorp Key Management plugin los encrypt cov ntaub ntawv hauv cov ntxhuav siv cov yuam sij khaws cia hauv Hashicorp Vault KMS.
- Cov khoom siv mysqlbinlog muaj cov kev xaiv tshiab "--do-domain-ids", "-ignore-domain-ids" thiab "-ignore-server-ids" rau kev lim los ntawm gtid_domain_id.
- Ntxiv lub peev xwm los tso saib wsrep lub xeev hloov pauv hauv cov ntaub ntawv sib cais hauv JSON hom, uas tuaj yeem siv rau hauv kev saib xyuas sab nraud.
- Ntxiv kev txhawb nqa rau "QHOV TSEEB [FORMAT=JSON]" hom rau cov zis hauv JSON hom.
- Cov lus "QHOV PAUB" tam sim no txhawb nqa "Qhia rau kev sib txuas" syntax.
- Lub innodb_change_buffering thiab cov hloov pauv qub tau raug tshem tawm (hloov los ntawm old_mode hloov pauv).
Tau qhov twg los: opennet.ru