I-ProHoster > Блог > izindaba ze-inthanethi > Ukukhishwa okuzinzile kwe-MariaDB 10.6

Ukukhishwa okuzinzile kwe-MariaDB 10.6

Ngemva konyaka wentuthuko kanye nokukhishwa kokuqala okuthathu, ukukhululwa kokuqala okuzinzile kwegatsha elisha le-MariaDB 10.6 DBMS kushicilelwe, lapho igatsha le-MySQL lithuthukiswa eligcina ukuhambisana emuva futhi lihlukaniswa nokuhlanganiswa kwezinjini zokulondoloza ezengeziwe. kanye namakhono athuthukile. Ukusekelwa kwegatsha elisha kuzonikezwa iminyaka emi-5, kuze kube uJulayi 2026.

Ukuthuthukiswa kwe-MariaDB kwenganyelwe i-MariaDB Foundation ezimele, kulandela inqubo yentuthuko evuleleke ngokuphelele futhi esobala ezimele kubathengisi ngabanye. I-MariaDB ihlinzekwa njengokungena esikhundleni se-MySQL ezindaweni eziningi ezisatshalaliswa ze-Linux (i-RHEL, i-SUSE, i-Fedora, i-openSUSE, i-Slackware, i-OpenMandriva, i-ROSA, i-Arch Linux, i-Debian) futhi isetshenziswe kumaphrojekthi amakhulu njenge-Wikipedia, i-Google Cloud SQL ne-Nimbuzz.

Ukuthuthukiswa Okubalulekile ku-MariaDB 10.6:

  • Ukusetshenziswa kwe-athomu kwezinkulumo ezithi “DALA ITHEBULA|BUKA|OKULANDELANA|TRIGGER”, “ALTER TABLE|SEQUENCE”, “RESHA TABLE|TABLES”, “DROP TABLE|VIEW|VIEW|TRIGGER|DATABASE” kuyaqinisekiswa (noma inkulumo ethi kuqedwe ngokuphelele noma yonke into ibuyiselwa esimweni sayo sokuqala). Esimeni semisebenzi ye-“DROP TABLE” esusa amathebula amaningana ngesikhathi esisodwa, i-athomu iqinisekiswa kuleveli yethebula ngalinye. Injongo yoshintsho iwukuqinisekisa ubuqotho esimweni lapho iseva iphahlazeka phakathi nomsebenzi. Ngaphambilini, ngemva kokuphahlazeka, amatafula esikhashana namafayela ayengasala, ukuvumelanisa amatafula ezinjinini zokulondoloza namafayela e-frm kungase kuphazamiseke, futhi amatafula ngamanye angahlala angaqanjwa kabusha lapho amatafula amaningana eqanjwa kabusha ngesikhathi esisodwa. Ubuqotho buqinisekiswa ngokugcina umlando wokuthola kabusha wombuso, indlela enganqunywa ngenketho entsha “—log-ddl-recovery=file” (ddl-recovery.log ngokuzenzakalelayo).
  • Ukwakhiwa kwe-“KHETHA ... OFFSET ... FETCH” okuchazwe ezingeni le-SQL 2008 sekuqalisiwe, okukuvumela ukuthi ubonise inombolo ethile yemigqa eqala ku-offset ethile, enekhono lokusebenzisa ipharamitha ethi “NGOKUTHATHA” ukuze namathisela elinye inani elilandelayo. Isibonelo, isisho esithi "KHETHA i KUSUKA t1 I-ORDER BY i-ASC OFFSET 1 IMILA LANDA IMIQA ENGU-3 YOKUQALA ENOTHATHA" yehluka ekwakhiweni kokuthi "KHETHA i KUSUKA KU-t1 ORDER BY i ASC LIMIT 3 OFFSET 1" ngokukhipha enye into emsileni. (esikhundleni semigqa engu-3 4 izophuma).
  • Enjinini ye-InnoDB, i-syntax ethi “KHETHA ... YEQA KAYIHLILE” isetshenzisiwe, ekuvumela ukuthi ungafaki imigqa lapho ukukhiya okungenakusethwa khona (“KHIPHA NGEMODI YOKWABELANA” noma “NGOKUBUYEKEZWA”).
  • Ikhono lokuziba izinkomba seliqalisiwe (ku-MySQL 8, lokhu kusebenza kubizwa ngokuthi “izinkomba ezingabonakali”). Ukumaka inkomba okufanele uzibe kwenziwa kusetshenziswa ifulegi elithi IGNORED kusitatimende esithi ALTER TABLE, ngemva kwalokho inkomba ihlala ibonakala futhi ibuyekezwa, kodwa ayisetshenziswa isilungiseleli.
  • Kwengezwe umsebenzi we-JSON_TABLE() ukuze kuguqulwe idatha ye-JSON ibe ifomu lokusebenzelana. Isibonelo, idokhumenti ye-JSON ingashintshwa ukuze isetshenziswe kumongo wethebula, elingacaciswa ngaphakathi kwebhulokhi ethi FROM esitatimendeni esithi KHETHA.
  • Ukusebenzisana okuthuthukisiwe ne-Oracle DBMS: Usekelo olungeziwe lwemibuzo engaphansi engaziwa ngaphakathi kwebhulokhi ethi FROM. Ukwakhiwa kwe-MINUS sekuqalisiwe (okulingana nokuthi NGAPHANDLE). Kwengezwe imisebenzi engu-ADD_MONTHS(), TO_CHAR(), SYS_GUID() kanye ne-ROWNUM() imisebenzi.
  • Enjinini ye-InnoDB, ukufakwa kumatafula angenalutho kusheshisiwe. Ifomethi yeyunithi yezinhlamvu COMPRESSED isethwe kumodi yokufunda kuphela ngokuzenzakalelayo. Uhlelo lwe-SYS_TABLESPACES luthathe indawo ye-SYS_DATAFILES futhi lubonisa ngokuqondile isimo ohlelweni lwefayela. Ukusekelwa kokubhala okuvilaphayo kunikezwa isikhala setafula lesikhashana. Ukusekelwa kwe-algorithm ye-checksum endala, eyagcinwa ukuze ihambisane ne-MariaDB 5.5, inqanyuliwe.
  • Kuhlelo lokuphindaphinda, usayizi wevelu yepharamitha ye-master_host unyusiwe ukusuka kuzinhlamvu ezingu-60 kuya kwezingu-255, futhi master_user ukuya ku-128. Okuguquguqukayo kwe-binlog_expire_logs_seconds kungeziwe ukuze kulungiselelwe isikhathi sokuphelelwa yisikhathi kwelogi kanambambili ngemizuzwana (ngaphambilini, isikhathi sokusetha kabusha besi kunqunywa kuphela ngezinsuku ngokusebenzisa okuguquguqukayo_kwezinsuku_zokuphelelwa yisikhathi).
  • I-Galera synchronous multi-master replication mechanism isebenzisa okuguquguqukayo kwe-wsrep_mode ukuze ilungiselele amapharamitha we-API we-WSREP (Write Set REPlication). Kuvunyelwe ukuguqulwa kwe-Galera kusukela kwezokuxhumana okungabethelwe kuya ku-TLS ngaphandle kokumisa iqoqo.
  • I-schema ye-sys-schema isiqalisiwe, equkethe iqoqo lemibono, imisebenzi kanye nezinqubo zokuhlaziya ukusebenza kwedathabheyisi.
  • Kungezwe amathebula esevisi okuhlaziya ukusebenza kokuphindaphinda.
  • Ukubuka kwe-INFORMATION_SCHEMA.KEYWORDS kanye ne-INFORMATION_SCHEMA.SQL_FUNCTIONS kwengezwe kusethi yamathebula olwazi, okubonisa uhlu lwamagama angukhiye atholakalayo nemisebenzi.
  • Izinqolobane ze-TokuDB ne-CassandraSE zisusiwe.
  • Umbhalo wekhodi we-utf8 ususiwe ekumeleleni amabhayithi amane utf8mb4 (U+0000..U+10FFFF) kwayiswa ku-utf8mb3 yamabhayithi amathathu (ihlanganisa ububanzi be-Unicode U+0000..U+FFFF).
  • Kungezwe ukusekelwa kokuvula isokhethi ku-systemd.
  • I-plugin ye-GSSAPI yengeze usekelo lwamagama weqembu le-Active Directory nama-SID.
  • Kwengezwe isheke lokuba khona kwefayela lokucushwa elingu-$MARIADB_HOME/my.cnf ngaphezu kwe-$MYSQL_HOME/my.cnf.
  • Izinguquko zesistimu entsha binlog_expire_logs_seconds, innodb_deadlock_report, innodb_read_only_compressed, wsrep_mode kanye ne-Innodb_buffer_pool_pages_lru_freed zisetshenzisiwe.

Source: opennet.ru

Engeza amazwana