ProHoster > Π‘Π»ΠΎΠ³ > xov xwm hauv internet > MariaDB 10.5 tso tawm ruaj khov

MariaDB 10.5 tso tawm ruaj khov

Tom qab ib xyoos ntawm kev txhim kho thiab plaub qhov kev tso tawm ua ntej npaj thawj ruaj khov tso tawm ntawm DBMS ceg tshiab MariaDB 10.4, nyob rau hauv uas ib ceg ntawm MySQL tau tsim kho uas tswj kev rov qab sib raug zoo thiab txawv kev sib xyaw ua ke ntawm cov cav ntim khoom ntxiv thiab cov peev txheej siab heev. Kev them nyiaj yug rau ceg tshiab yuav muab rau 5 xyoos, txog rau thaum Lub Rau Hli 2025.

MariaDB txoj kev loj hlob yog saib xyuas los ntawm MariaDB Foundation ywj pheej, ua raws li txoj kev loj hlob qhib thiab pob tshab uas yog ywj siab ntawm tus neeg muag khoom. MariaDB tau muab hloov pauv MySQL hauv ntau Linux faib (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) thiab tau ua tiav hauv cov haujlwm loj xws li Wikipedia, Google Cloud SQL ΠΈ Nimbuzz.

Ntsiab kev txhim kho MariaDB 10.5:

  • Ntxiv lub cav cia S3, uas tso cai rau koj los tuav MariaDB cov lus ntawm Amazon S3 lossis lwm qhov chaw khaws huab huab lossis pej xeem ntiag tug uas txhawb nqa S3 API. Muab ob qho tib si tsis tu ncua thiab muab faib cov rooj hauv S3 tau txais kev txhawb nqa. Thaum cov rooj sib faib tau muab tso rau hauv huab, lawv tuaj yeem siv ncaj qha, suav nrog los ntawm lwm tus neeg rau zaub mov uas tau nkag mus rau S3 cia.
  • Ntxiv lub cav cia Nyaj Looj Yaj, uas khaws cov ntaub ntawv khi rau kab thiab siv loj heev parallel faib architecture. Lub cav yog ua raws li kev txhim kho ntawm MySQL cia InfiniDB thiab yog npaj rau kev teeb tsa kev ua thiab ua tiav cov lus nug tshawb xyuas ntau dua cov ntaub ntawv (Data Warehouse).
    ColumnStore khaws cov ntaub ntawv tsis yog kab los ntawm kab, tab sis los ntawm kab, uas tso cai rau koj los txhim kho qhov kev ua tau zoo ntawm pawg los ntawm kab los ntawm cov ntaub ntawv loj, suav nrog petabytes ntawm cov ntaub ntawv. Linear scaling, compressed data storage, vertical and horizontal partitioning, thiab kev ua tau zoo ntawm kev sib tw thov tau txais kev txhawb nqa.

  • Tag nrho cov executables pib nrog lo lus "mysql" tau renamed siv lo lus "mariadb". Cov npe qub tau muab khaws cia rau hauv daim ntawv ntawm cov cim txuas.
  • Ntxiv hom ntaub ntawv tshiab INET 6 rau khaws IPv6 chaw nyob.
  • Kev ua haujlwm tau ua kom cais cov cai rau hauv cov khoom me me. Hloov chaw ntawm SUPER txoj cai dav dav, xaiv cov cai xaiv "BINLOG ADMIN" tau thov,
    "BINLOG REPLAY"
    "CONNECTION ADMIN"
    "FAIB ADMIN"
    "READ_ONLY ADMIN",
    "REPLICATION MASTER ADMIN"
    "REPLICATION SLAVE ADMIN" thiab
    "SET USER".

  • Txoj cai "REPLICATION CLIENT" tau hloov npe mus rau "BINLOG MONITOR" thiab "SHOW MASTER STATUS" qhia rau "Qhia BINLOG STATUS". Lub renaming qhia meej txog tus cwj pwm thiab tsis cuam tshuam nrog kev nom kev tswv qhov tseeb, qhov project tsis tso tseg cov lus tswv / qhev thiab txawm ntxiv cov cai tshiab "MASTER ADMIN" thiab "SLAVE ADMIN". Nyob rau tib lub sijhawm, tus yuam sij tshiab "REPLICA" tau ntxiv rau SQL qhia, uas yog lub ntsiab lus rau "SLAVE".
  • Rau qee cov lus qhia, cov cai uas yuav tsum tau ua rau lawv tau raug hloov pauv. "QHIA BINLOG EVENTS" tam sim no xav tau "BINLOG MONITOR" txoj cai es tsis yog "REPLICATION SLAVE", "QHOV SLAVE HOSTS" yuav tsum "REPLICATION MASTER ADMIN" cov cai es tsis yog "REPLICATION SLAVE", "SHOW SLAVE STATUS" xav tau "REPLICATION" SLAVE "SUPER" es tsis txhob "REPLICATION CLIENT", "Qhia RELAYLOG EVENTS" yuav tsum "REPLICATION SLAVE ADMIN" txoj cai es tsis yog "REPLICATION SLAVE".
  • Ntxiv designs "INSERT...RAU"Thiab"REPLACE...YOG", xa rov qab ib daim ntawv teev npe nkag / hloov pauv hauv daim ntawv zoo li cov txiaj ntsig tau rov qab los siv SELECT qhia (zoo ib yam li "DELETE ... RETURNING").

    INSERT INTO t2 VALUES (1,'Dog'),(2,'Lion'),(3,'Tiger'),(4,'Leopard')
    RETURNING id2,id2+id2,id2&id2,id2||id2;
    --------+--------------------------
    | ib id2 | id2+id2 | id2&id2 | id2 | | id2 |
    --------+--------------------------
    | 1 | 2 | 1 | 1 |
    | 2 | 4 | 2 | 1 |
    | 3 | 6 | 3 | 1 |
    | 4 | 8 | 4 | 1 |
    --------+--------------------------

  • Ntxiv kab lus "TSEEM CEEB"Thiab"INTERSECT TXHUAΒ» kom tshem tawm / ntxiv qhov tshwm sim nrog rau cov txheej txheem tshwj xeeb.
  • Tam sim no nws tuaj yeem hais qhia cov lus hauv "CREATE DATABASE" thiab "ALTER DATABASE" blocks.
  • Ntxiv constructs rau renaming indexes thiab kab "ALTER TABLE ... RENAME INDEX / KEY"Thiab"ALTER TABLE... RENAME COLUMN".
  • Hauv "ALTER TABLE" thiab "RENAME TABLE" kev ua haujlwm, kev txhawb nqa rau "yog tias muaj" tau ntxiv los ua haujlwm tsuas yog tias lub rooj muaj;
  • Rau indexes hauv "CREATE TABLE" tus cwj pwm "SAIB XYOOJ".
  • Ntxiv "CYCLE" qhia los txheeb xyuas cov voj voog rov qab CTE.
  • Nta ntxiv JSON_ARRAYAGG ΠΈ JSON_OBJECTAGG xa rov qab ib qho array lossis JSON khoom nrog cov nqi ntawm kab ntawv teev tseg.
  • Ntxiv cov ntaub ntawv qhia kev pabcuam (THREAD_POOL_GROUPS, THREAD_POOL_QUEUES, THREAD_POOL_STATS thiab THREAD_POOL_WAITS) rau lub pas dej (thread_pool).
  • Qhov kev nthuav qhia TAM SIM NO tau nthuav dav los qhia lub sijhawm siv tshuaj xyuas qhov thaiv qhov twg thiab ua haujlwm pabcuam.
  • Qhov kev ua kom zoo tshaj plaws yuav siv rau hauv tus account "tsis yog NULL" yam ntxwv
  • Qhov loj ntawm cov ntaub ntawv ib ntus siv thaum txheeb nrog VARCHAR, CHAR thiab BLOB hom tau raug txo qis.
  • Π’ binary log, siv los npaj replication, tshiab metadata teb tau muab ntxiv, suav nrog Cov Ntsiab Tseem Ceeb, Kem Lub Npe, Cim Cim thiab Hom Geometry. Cov nqi hluav taws xob mariadb-binlog thiab "QHIA BINLOG EVENTS" thiab "QHOV RELAYLOG EVENTS" cov lus txib muab cov duab ntawm cov chij rov ua dua.
  • Kev tsim kho DROP TABLE tam sim no nws muaj kev nyab xeeb tshem tawm cov ntxhuav uas nyob hauv lub cav cia txawm tias tsis muaj ".frm" lossis ".par" cov ntaub ntawv.
  • Ua haujlwm kho vajtse nrawm nrawm ntawm crc32() ua haujlwm rau AMD64, ARMv8 thiab POWER 8 CPUs.
  • Hloov qee qhov chaw pib. innodb_encryption_threads tau nce mus rau 255 thiab max_sort_length tau nce los ntawm 4 mus rau 8.
  • Muaj ntau qhov kev ua tau zoo rau lub cav InnoDB tau nthuav tawm.
  • Kev txhawb nqa tag nrho tau ntxiv rau Galera synchronous multi-master replication mechanism GTID ua (Global Transaction ID), cov cim kev hloov pauv uas muaj rau txhua pawg ntawm pawg.
  • Hloov mus rau ib ceg tshiab ntawm lub tsev qiv ntawv tau ua PCRE 2 (Perl Compatible Regular Expressions), tsis yog cov classic PCRE 8.x series.
  • Cov qauv tshiab ntawm cov hlua khi tau raug npaj rau kev txuas rau MariaDB thiab MySQL DBMS los ntawm cov kev pab cuam hauv Python thiab C: MariaDB Txuas / Python 1.0.0 ΠΈ MariaDB Connector/C 3.1.9. Python binding ua raws li Python DB API 2.0, sau rau hauv C thiab siv lub tsev qiv ntawv Connector/C los txuas rau lub server.

Tau qhov twg los: opennet.ru

Ntxiv ib saib