Pambuyo pa chaka cha chitukuko ndi zinayi zisanayambe kumasulidwa kutulutsidwa koyamba kwa nthambi yatsopano ya DBMS , momwe nthambi ya MySQL ikupangidwira yomwe imasunga kuyanjana kwam'mbuyo ndi kuphatikiza kwa injini zosungirako zowonjezera ndi luso lapamwamba. Thandizo la nthambi yatsopano lidzaperekedwa kwa zaka 5, mpaka June 2025.
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 yakhazikitsidwa m'mapulojekiti akuluakulu monga , и .
Chinsinsi :
- Injini yosungira yowonjezeredwa , zomwe zimakulolani kuti mukhale ndi matebulo a MariaDB pa Amazon S3 kapena malo ena onse amtundu kapena achinsinsi omwe amathandizira S3 API. Kuyika matebulo okhazikika komanso ogawa mu S3 kumathandizidwa. Matebulo ogawidwa akayikidwa mumtambo, amatha kugwiritsidwa ntchito mwachindunji, kuphatikiza kuchokera ku seva ina yomwe imatha kusungirako S3.
- Injini yosungira yowonjezeredwa , yomwe imasunga deta yomangidwa kumagulu ndi ntchito kugawa zomangamanga. Injiniyo imachokera pakukula kwa MySQL yosungirako ndipo cholinga chake ndicho kukonza zokonza ndi kuyankha mafunso owunika pazambiri zambiri (Data Warehouse).
ColumnStore imasunga deta osati mzere ndi mzere, koma ndi mizati, yomwe imakulolani kuti muwongolere bwino ntchito yamagulu ndi mizati kuchokera ku database yayikulu, kuphatikizapo ma petabytes a data. Kuchulukitsa kwa liniya, kusungidwa kwa data koponderezedwa, kugawa koyima ndi kopingasa, ndikukwaniritsa zopempha zopikisana zimathandizidwa. - Zonse zomwe zimayambira ndi mawu oti "mysql" zasinthidwa kuti zigwiritse ntchito mawu oti "mariadb". Mayina akale amasungidwa m'njira yophiphiritsira.
- Adawonjezera mtundu watsopano wa data posungira ma adilesi a IPv6.
- Ntchito yachitidwa kuti alekanitse maudindo m'zigawo zing'onozing'ono. M'malo mwamwayi wa SUPER, mndandanda wamwayi wosankha "BINLOG ADMIN" akuperekedwa,
"BINLOG REPLAY"
"CONNECTION ADMIN"
"FEDERATED ADMIN"
"WERENGANI_POKHA ADMIN",
"REPLICATION MASTER ADMIN"
"REPLICATION KAPOLO ADMIN" ndi
"SET USER". - Mwayi wa "REPLICATION CLIENT" wasinthidwanso kukhala "BINLOG MONITOR" komanso mawu oti "SHOW MASTER STATUS" kukhala "SOW BINLOG STATUS". Kusinthidwanso kumamveketsa bwino khalidweli ndipo sikukugwirizana ndi kulondola kwa ndale, pulojekitiyi siyisiya mawu akuti master / kapolo komanso kuwonjezeranso mwayi watsopano "MASTER ADMIN" ndi "ALAVE ADMIN". Nthawi yomweyo, kiyi yatsopano "REPLICA" yawonjezedwa ku mawu a SQL, omwe ndi ofanana ndi "KUKAPALA".
- M'mawu ena, maudindo ofunikira kuti awapereke asinthidwa. "SHOW BINLOG EVENTS" tsopano ikufuna mwayi wa "BINLOG MONITOR" m'malo mwa "REPLICATION SKLAVE", "SHOW SLAVE Hosts" ikufuna mwayi wa "REPLICATION MASTER ADMIN" m'malo mwa "REPLICATION SLAVE", "SHOW STATUS SKLAVE" imafuna "REPLICATION SKLAVE ADMIN" kapena " SUPER" m'malo mwa "REPLICATION CLIENT", "SHOW RELAYLOG EVENTS" imafuna maufulu a "REPLICATION SLAVE ADMIN" m'malo mwa "REPLICATION SLAVE".
- Mapangidwe owonjezera ""Ndipo"", kubweza mndandanda wazolemba zomwe zidalowetsedwa / zosinthidwa m'mawonekedwe ngati kuti zosinthazo zidabwezedwa pogwiritsa ntchito mawu akuti SELECT (ofanana ndi "FUTA ... KUBWERETSA").
LOWANI M'MFUNDO t2 (1,'Galu'), (2,'Mkango'), (3,'Tiger'), (4,'Nyalugwe')
RETURNING id2,id2+id2,id2&id2,id2||id2;
+——+———+————+————+
| | id2 | id2+id2 | id2&id2 | id2||id2 |
+——+———+————+————+
| | 1 | 2 | 1 | 1 |
| | 2 | 4 | 2 | 1 |
| | 3 | 6 | 3 | 1 |
| | 4 | 8 | 4 | 1 |
+——+———+————+————+ - Mawu owonjezera ""Ndipo"»kupatula/kuwonjezera zotsatira ndi gulu linalake la zikhalidwe.
- Tsopano ndizotheka kufotokoza ndemanga mkati mwa "CREATE DATABASE" ndi "ALTER DATABASE" blocks.
- Zomanga zowonjezeredwa kuti musinthe ma index ndi ma column ""Ndipo"".
- Muzochita za "ALTER TABLE" ndi "RENAME TABLE", chithandizo cha chikhalidwe cha "IF EXISTS" chawonjezeredwa kuti chigwire ntchito pokhapokha ngati tebulo lilipo;
- Kwa ma index omwe ali mu "CREATE TABLE" malingaliro "".
- Onjezani mawu a "CYCLE" kuti muzindikire malupu obwereza .
- Zina zowonjezera и kubweza gulu kapena chinthu cha JSON chokhala ndi zikhalidwe zomwe zafotokozedwa.
- Matebulo owonjezera pazantchito (THREAD_POOL_GROUPS, THREAD_POOL_QUEUES, THREAD_POOL_STATS ndi THREAD_POOL_WAITS) a ulusi pool (thread_pool).
- Mawu a ANALYZE amakulitsidwa kuti awonetse nthawi yomwe amayang'ana WHERE block ndikuchita ntchito zothandizira.
- Makina opangira ma optimizer amaganizira za "S NOT NULL".
- Kukula kwa mafayilo osakhalitsa omwe amagwiritsidwa ntchito posankha ndi mitundu ya VARCHAR, CHAR ndi BLOB kwachepetsedwa kwambiri.
- В , omwe amagwiritsidwa ntchito pokonzekera kubwereza, magawo atsopano a metadata awonjezedwa, kuphatikizapo Kiyi Yoyambira, Dzina la Column, Character Set ndi Geometry Type. Zogwiritsira ntchito za mariadb-binlog ndi malamulo a "SHOW BINLOG EVENTS" ndi "SHOW RELAYLOG EVENTS" amapereka chiwonetsero cha mbendera zobwereza.
- Ntchito yomanga tsopano zili bwino matebulo omwe atsalira mu injini yosungirako ngakhale palibe ".frm" kapena ".par" mafayilo.
- Anakhazikitsa mtundu wofulumira wa hardware wa crc32() ntchito ya AMD64, ARMv8 ndi POWER 8 CPUs.
- Zasintha zina zokhazikika. innodb_encryption_threads yawonjezedwa kufika pa 255 ndipo max_sort_length yawonjezedwa kuchoka pa 4 mpaka 8.
- Kukhathamiritsa kochuluka kwa injini ya InnoDB kumaperekedwa.
- Thandizo lathunthu lawonjezeredwa ku Galera synchronous multi-master replication mechanism (ID ya Global Transaction), zozindikiritsa zochitika zomwe zimapezeka m'magulu onse.
- Kusintha kupita ku nthambi yatsopano ya laibulale kwapangidwa (Perl Compatible Regular Expressions), m'malo mwa gulu lakale la PCRE 8.x.
- Ma harnesses atsopano aperekedwa kuti alumikizike ku MariaDB ndi MySQL DBMS kuchokera ku mapulogalamu a Python ndi C: и . Kumanga kwa Python kumagwirizana ndi Python DB API 2.0, yolembedwa mu C ndipo imagwiritsa ntchito laibulale ya Connector / C kuti igwirizane ndi seva.
Source: opennet.ru