Mushure megore rekuvandudza uye mana asati aburitswa yekutanga yakagadzikana kuburitswa kwebazi idzva reDBMS , mukati meiyo bazi reMySQL riri kugadzirwa rinochengetedza kumashure kuenderana uye kubatanidzwa kwemamwe mainjini ekuchengetedza uye kugona kwepamusoro. Bazi idzva richatsigirwa kwemakore mashanu, kusvika muna June 5.
Kubudirira kweMariaDB kunotariswa neiyo yakazvimirira MariaDB Foundation, ichitevera yakavhurika uye yakajeka yekuvandudza maitiro ayo akazvimirira kune ega vatengesi. MariaDB inopihwa pachinzvimbo cheMySQL mune dzakawanda Linux kugovera (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) uye yakaitwa mumapurojekiti makuru akadai se. , и .
Key :
- Yakawedzera injini yekuchengetedza , iyo inokutendera kuti utore matafura eMariaDB paAmazon S3 kana chero imwe yeruzhinji kana yakavanzika gore yekuchengetedza inotsigira S3 API. Kuisa ese akajairwa uye akapatsanurwa matafura muS3 inotsigirwa. Kana matafura akapatsanurwa akaiswa mugore, anogona kushandiswa zvakananga, kusanganisira kubva kune imwe sevha inokwanisa kuwana S3 yekuchengetedza.
- Yakawedzera injini yekuchengetedza , iyo inochengetedza data yakasungwa kumakoramu uye kushandiswa akaparadzirwa zvivakwa. Injini yakavakirwa pakuvandudzwa kweMySQL kuchengetedza uye inoitirwa kuronga kugadzirisa uye kuitwa kwemibvunzo yekuongorora pamusoro pehuwandu hwedata (Data Warehouse).
ColumnStore inochengetedza data kwete mutsara nemutsara, asi nemakoramu, izvo zvinokutendera iwe kukwidziridza kuita kwemapoka nemakoramu kubva kune yakakura dhatabhesi, kusanganisira petabytes yedata. Linear scaling, yakamanikidzwa kuchengetedza data, yakatwasuka uye yakachinjika partitioning, uye kuita kwakanaka kwezvikumbiro zvekukwikwidza kunotsigirwa. - Zvese zvinoitwa zvinotanga neshoko rekuti "mysql" zvakapihwa zita rekushandisa izwi rekuti "mariadb". Mazita ekare anochengetwa muchimiro chezvisungo zvekufananidzira.
- Yakawedzera mhando itsva yedata yekuchengetedza IPv6 kero.
- Basa rakaitwa kuparadzanisa maropafadzo muzvikamu zviduku. Panzvimbo peiyo yakajairika SUPER rombo, nhevedzano yesarudzo dzesarudzo "BINLOG ADMIN" inokurudzirwa,
"BINLOG REPLAY"
"CONNECTION ADMIN"
"FEDERATED ADMIN"
"VERENGA_CHETE ADMIN",
"REPLICATION MASTER ADMIN"
"REPLICATION SLAVE ADMIN" uye
"SET USER". - Ropafadzo ye "REPLICATION CLIENT" yapihwa zita rekuti "BINLOG MONITOR" uye "SHOW MASTER STATUS" kutaura ku "RATIDZA BINLOG STATUS". Iko kutumidza zita rinojekesa maitiro uye haaenderane nekurongeka kwezvematongerwo enyika, chirongwa hachisiye mazwi tenzi / muranda uye kunyange akawedzera maropafadzo matsva "MASTER ADMIN" uye "SLAVE ADMIN". Panguva imwecheteyo, kiyi nyowani "REPLICA" yakawedzerwa kune iyo SQL kutaura, inova yakafanana ne "SLAVE".
- Kune mamwe mashoko, ropafadzo dzinodiwa pakuaita dzakachinjwa. "SHOW BINLOG EVENTS" ikozvino inoda "BINLOG MONITOR" ropafadzo pachinzvimbo che "REPLICATION Slave", "SHOW SLAVE HOSTS" inoda "REPLICATION MASTER ADMIN" maropafadzo pachinzvimbo chekuti "REPLICATION SLAVE", "SHOW SLAVE STATUS" inoda "REPLICATION SLAVE ADMIN" kana " SUPER" pachinzvimbo che "REPLICATION CLIENT", "SHOW RELAYLOG EVENTS" inoda kodzero dze "REPLICATION SLAVE ADMIN" pachinzvimbo che "REPLICATION SLAVE".
- Akawedzera madhizaini ""Uye"", kudzosa runyoro rweakaiswa / akatsiviwa muchimiro sekunge kukosha kwadzoserwa uchishandisa SELECT kutaura (yakafanana ne" DELETE ... RETURNING ").
PINDA MU t2 ZVINOKOSHA (1,'Imbwa'),(2,'Shumba'),(3,'Tiger'),(4,'Leopard')
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 |
+——+———+————+————-+ - Akawedzera mazwi ""Uye"»kubvisa/kuwedzera mhedzisiro neseti chaiyo yemakoshero.
- Izvozvi zvinogoneka kutsanangura zvirevo mukati me "CREATE DATABASE" uye "ALTER DATABASE" blocks.
- Akawedzera zvigadziriso zvekutumidza mazita indexes nemakoramu ""Uye"".
- Mu "ALTER TABLE" uye "RENAME TABLE" mashandiro, rutsigiro rwe "IF EXISTS" mamiriro akawedzerwa kuti aite oparesheni chete kana tafura iripo;
- Kune ma indexes mu "CREATE TABLE" hunhu "".
- Yakawedzera "CYCLE" kutaura kuona zvishwe zvinodzokororwa .
- Zvimiro zvakawedzerwa и kudzosa array kana JSON chinhu chine kukosha kwekoramu yakatarwa.
- Matafura eruzivo rwesevhisi (THREAD_POOL_GROUPS, THREAD_POOL_QUEUES, THREAD_POOL_STATS neTHREAD_POOL_WAITS) akawedzerwa e thread pool (thread_pool).
- Izwi reANALYZE rinowedzerwa kuratidza nguva yakashandiswa kutarisa WHERE block uye kuita mabasa ekubatsira.
- Iyo renji yekugadzirisa optimizer inofunga nezve "HAISI NULL" maitiro
- Ukuru hwemafaira enguva pfupi anoshandiswa pakurongedza neVARCHAR, CHAR uye BLOB marudzi akadzikiswa zvakanyanya.
- В , inoshandiswa kuronga kudzokorora, minda mitsva yemetadata yakawedzerwa, kusanganisira Primary Key, Column Name, Character Set uye Geometry Type. Iyo mariadb-binlog utility uye "RATIDZA BINLOG ZVIITIKO" uye "RATIDZA RELAYLOG ZVIITIKO" mirairo inopa kuratidzwa kwemireza yekudzokorora.
- Kuvaka zvino zvakachengeteka matafura anosara muinjini yekuchengetera kunyangwe pasina ".frm" kana ".par" mafaera.
- Yakamisikidza hardware yakamhanyisa vhezheni ye crc32 () basa re AMD64, ARMv8 uye POWER 8 CPUs.
- Yakachinja mamwe marongero ekutanga. innodb_encryption_threads yawedzerwa kusvika pa255 uye max_sort_length yawedzerwa kubva pa4 kusvika pa8.
- Kwakawanda kwekuita optimizations yeInnoDB injini inounzwa.
- Rutsigiro rwakazara rwakawedzerwa kuGalera synchronous multi-master replication mechanism (Global Transaction ID), zviziviso zvekutengeserana zvakajairika kune ese masumbu node.
- Shanduko yebazi idzva reraibhurari yaitwa (Perl Inowirirana Regular Expressions), pachinzvimbo chekare PCRE 8.x dzakatevedzana.
- Shanduro nyowani dzemaharnesses dzakarongwa kuti dzibatanidzwe kuMariaDB uye MySQL DBMS kubva kuzvirongwa muPython neC: и . Iyo Python inosunga inoenderana nePython DB API 2.0, yakanyorwa muC uye inoshandisa raibhurari yeConnector/C kubatanidza kune server.
Source: opennet.ru