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

MariaDB 10.4 tso tawm ruaj khov

Tom qab ib xyoos ntawm txoj kev loj hlob thiab rau lub pre-tso tawm 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 2024.

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 hloov pauv MySQL hauv ntau Linux kev faib tawm (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.4:

  • Xws li synchronous multi-master replication technology Galera 4, uas tso cai rau ib qho active-active multi-master topology uas tuaj yeem nyeem thiab sau los ntawm txhua qhov. Nrog synchronous replication, tag nrho cov nodes ib txwm muaj cov ntaub ntawv tshiab, i.e. tsis muaj kev lag luam poob yog lav, txij li qhov kev sib pauv tau cog lus tsuas yog tom qab cov ntaub ntawv tau nthuav tawm mus rau tag nrho cov nodes. Replication yog ua nyob rau hauv parallel hom, nyob rau theem kab, hloov tsuas yog cov ntaub ntawv hais txog kev hloov;
  • Ntawm Unix-zoo li tshuab, qhov kev lees paub qhov tseeb yog qhib los ntawm lub neej ntawd unix_socket, uas tso cai rau koj siv cov nyiaj tam sim no hauv lub kaw lus txuas rau DBMS siv lub qhov (socket) unix hauv zos;
  • Ntxiv sijhawm muab ib lub neej rau tus neeg siv tus password, tom qab uas tus password raug cim tias tas sij hawm. Txhawm rau teeb tsa tus password tas hnub nyob rau hauv "CREATE USER" thiab "ALTER USER" ua haujlwm, cov lus qhia "PASSWORD EXPIRE INTERVAL N DAY" tau ntxiv;
  • Ntxiv kev txhawb nqa thaiv DBMS cov neeg siv los ntawm "ACCOUNT LOCK" qhia hauv "CREATE USER" thiab "ALTER USER" ua haujlwm;
  • Kev ua tiav ntawm cov cai tswj xyuas hauv kev teeb tsa nrog ntau tus neeg siv lossis cov cai nkag tau nrawm nrawm;
  • txiav tawm siv mysql.user thiab mysql.host ntxhuav. Lub rooj mysql.global_priv tam sim no siv los khaws cov nyiaj thiab cov cai thoob ntiaj teb;
  • Π’ plugins kev lees paub ntxiv txhawb rau "SET PASSWORD" qhia;
  • Ntxiv muaj peev xwm siv ntau tshaj ib qho kev lees paub tseeb plugin rau txhua tus account, uas tuaj yeem pab tau kom maj mam tsiv cov neeg siv mus rau lub plugin. ed25519. Thaum tsim tus neeg siv hauv paus @ localhost nrog cov ntawv mysql_install_db, ob qhov kev lees paub qhov tseeb tam sim no tau qhib los ntawm lub neej ntawd - unix_socket thiab mysql_native_password;
  • Lub InnoDB cia siv cov kev khiav hauj lwm ntawm instantly rho txhua txhua (ALTER TABLE ... DROP COLUMN ... ALGORITHM = INSTANT) thiab hloov qhov kev txiav txim ntawm txhua. Qhov luaj li cas ntawm qhov pib cav rau rollback kev khiav hauj lwm (redo cav) tau raug txo. Ntxiv qhov tseem ceeb hloov kev txhawb nqa rau innodb_encrypt_log. Ua ib qho algorithm rau kev txheeb xyuas cov checksums
    innodb_checksum_algorithm=full_crc32. Muab kev nthuav dav tam sim ntawm VARCHAR hom thiab hloov cov ntawv sau rau cov kab uas tsis tau txheeb xyuas;

  • Txhim kho optimizer. Ntxiv lub peev xwm los taug qab cov optimizer, enabled ntawm lub system kuj sib txawv optimizer-txoj kev... Default suav nrog tswj xyuas cov txheeb cais ywj pheej ntawm cov tshuab cia.
    Muaj ob hom kev siv tshiab_stat_tables - COMPLEMENTARY_FOR_QUERIES thiab PREFERABLY_FOR_QUERIES. optimize_join_buffer_size hom yog qhib. Cov tshiab ntxiv chij rowid_filter thiab condition_pushdown_from_having;

  • Kev them nyiaj yug rau qhov system versioned ntxhuav, uas tsis tsuas yog khaws cov ntaub ntawv tam sim no, tab sis kuj txuag cov ntaub ntawv hais txog txhua qhov kev hloov pauv yav dhau los, tau nthuav dav. kev ua haujlwm nrog rau lub sijhawm;
  • Ntxiv ib qho tshiab "FLUSH SSL" hais kom rov ua dua SSL daim ntawv pov thawj yam tsis tau rov pib dua lub server;
  • Ntxiv kev txhawb nqa rau "YOG TSIS TAU" thiab "YOG EXISTS" kab lus hauv "INSTALL PLUGIN", "UNINSTALL PLUGIN" thiab "UNINSTALL SONAME" ua haujlwm;
  • Crash-resistant system rooj yog npaj, rau khaws cia uas lub cav siv Aria;
  • Kev hloov pauv mus rau kev siv C ++ 11 tus qauv tau ua tiav (kev ua haujlwm atomic tau koom nrog);
  • Kev ua tau zoo ntawm Collation locale zog rau Unicode tau txhim kho tau zoo, tso cai rau koj los qhia txog kev txheeb xyuas cov cai thiab kev sib txuam raws li lub ntsiab lus ntawm cov cim;
  • Ntxiv plugin rau txhais koj tus kheej hom teb;
  • Ntxiv kev txhawb nqa rau windowsed UDF muaj nuj nqi (Tus neeg siv-txhais ua haujlwm);
  • Hauv "FLUSH TABLE" ua haujlwm ua raws "BACKUP LOCK" hom, uas tuaj yeem siv thaum thaub qab cov ntaub ntawv database;
  • Ntxiv kev them nyiaj yug rau cov neeg rau zaub mov commands pib nrog mariadb, lwm txoj rau cov lus txib pib nrog "mysql" (piv txwv li, mariadump es tsis txhob mysqldump).

Tau qhov twg los: opennet.ru

Ntxiv ib saib