Pulogalamu ya ProHoster > Blog > nkhani zapaintaneti > MariaDB 10.6 kumasulidwa kokhazikika

MariaDB 10.6 kumasulidwa kokhazikika

Pambuyo pa chaka cha chitukuko ndi kutulutsidwa koyambirira katatu, kutulutsidwa kokhazikika kwa nthambi yatsopano ya MariaDB 10.6 DBMS kwasindikizidwa, momwe nthambi ya MySQL ikupangidwira yomwe imasunga kuyanjana kwa m'mbuyo ndipo imasiyanitsidwa ndi kuphatikiza kwa injini zosungirako zowonjezera. ndi luso lapamwamba. Thandizo la nthambi yatsopano lidzaperekedwa kwa zaka 5, mpaka July 2026.

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 yakhala ikugwiritsidwa ntchito m'mapulojekiti akuluakulu monga Wikipedia, Google Cloud SQL ndi Nimbuzz.

Zosintha zazikulu mu MariaDB 10.6:

  • Mawu akuti "CREATE TABLE|VIEW|SEQUENCE|TRIGGER", "ALTER TABLE|SEQUENCE", "RENAME TABLE|TABLES", "DROP TABLE|VIEW|VIEW|TRIGGER|DATABASE" amatsimikizidwa (mwina mawuwa ndi kutsirizika kwathunthu kapena chirichonse chibwezeredwa momwe chinalili poyamba). Pankhani ya "DROP TABLE" ntchito zomwe zimachotsa matebulo angapo nthawi imodzi, atomiki imatsimikiziridwa pamlingo wa tebulo lililonse. Cholinga cha kusinthaku ndikuwonetsetsa kukhulupirika pakagwa seva pakachitika opaleshoni. M'mbuyomu, pambuyo pa kuwonongeka, matebulo osakhalitsa ndi mafayilo amatha kukhalabe, kugwirizanitsa matebulo mu injini zosungiramo zinthu ndi mafayilo a frm akhoza kusokonezedwa, ndipo matebulo amodzi angakhale osatchulidwa pamene matebulo angapo adasinthidwa nthawi imodzi. Umphumphu umatsimikiziridwa mwa kusunga chipika chobwezeretsa boma, njira yomwe ingadziwike kupyolera mu njira yatsopano "-log-ddl-recovery=file" (ddl-recovery.log mwachisawawa).
  • Kumanga kwa "SELECT ... OFFSET ... FETCH" kumatanthauzidwa mu SQL 2008 muyezo wakhazikitsidwa, kukulolani kuti muwonetse chiwerengero cha mizere kuyambira pamtundu wina, ndikutha kugwiritsa ntchito parameter ya "WITH TIES" Gwirizanitsani mtengo wina. Mwachitsanzo, mawu oti "SAKHANI i KUCHOKERA KU t1 ORDER BY i ASC OFFSET 1 ROWS TSWANITSA MIZANI 3 YOYAMBA NDI MA TIY" amasiyana ndi zomangamanga "SAKHANI I KUCHOKERA KU t1 ORDER BY i ASC LIMIT 3 OFFSET 1" potulutsa chinthu chinanso mchira. (m'malo mwa mizere 3 4 idzasindikizidwa).
  • Pa injini ya InnoDB, mawu oti "SAKHANI ... SKIP LOCKED" akhazikitsidwa, omwe amakulolani kuti musamaphatikizepo mizere yomwe loko sikungakhazikitsidwe ("LOCK IN SHARE MODE" kapena "FOR UPDATE").
  • Kutha kunyalanyaza zolemba zakhazikitsidwa (mu MySQL 8, ntchitoyi imatchedwa "invisible indexes"). Kuyika chizindikiro kuti musanyalanyaze kumachitidwa pogwiritsa ntchito mbendera ya IGNORED mu mawu a ALTER TABLE, pambuyo pake ndondomekoyi imakhalabe yowonekera ndikusinthidwa, koma sichigwiritsidwa ntchito ndi optimizer.
  • Anawonjezera ntchito ya JSON_TABLE() kuti musinthe data ya JSON kukhala mawonekedwe ogwirizana. Mwachitsanzo, chikalata cha JSON chikhoza kusinthidwa kuti chigwiritsidwe ntchito patebulo, chomwe chingatchulidwe mkati mwa FROM block mu SELECT statement.
  • Kugwirizana kwabwino ndi Oracle DBMS: Thandizo lowonjezera lazambiri zosadziwika mkati mwa block FROM. Zomanga za MINUS zakhazikitsidwa (zofanana ndi KUKHALA). Onjezani ntchito za ADD_MONTHS(), TO_CHAR(), SYS_GUID() ndi ROWNUM().
  • Mu injini ya InnoDB, kuyika m'matebulo opanda kanthu kwafulumizitsa. Mitundu ya zingwe ya COMPRESSED imayikidwa kuti ikhale yowerengera-pokhapokha. Chiwembu cha SYS_TABLESPACES chinalowa m'malo mwa SYS_DATAFILES ndipo chimawonetseratu zomwe zili mu fayilo. Thandizo lolemba laulesi limaperekedwa kwa malo osakhalitsa a tebulo. Thandizo la algorithm yakale ya cheke, yomwe idasungidwa kuti igwirizane ndi MariaDB 5.5, yathetsedwa.
  • Mu ndondomeko yobwerezabwereza, kukula kwa mtengo wa parameter master_host kwawonjezeka kuchokera ku zilembo za 60 kufika ku 255, ndi master_user kufika ku 128. Kusintha kwa binlog_expire_logs_seconds kwawonjezedwa kuti akonze nthawi yotsiriza ya chipika cha binary mumasekondi (m'mbuyomu, nthawi yokonzanso inalipo. kutsimikiziridwa m'masiku okha kudzera mu kusintha kwa expire_logs_days).
  • Njira ya Galera synchronous multi-master replication mechanism imagwiritsa ntchito kusintha kwa wsrep_mode kukonza magawo a WSREP (Write Set REPlication) API. Amalola kutembenuka kwa Galera kuchoka pamalumikizidwe osabisika kupita ku TLS popanda kuyimitsa gulu.
  • Dongosolo la sys-schema lakhazikitsidwa, lomwe lili ndi malingaliro, ntchito ndi njira zowunikira ntchito za database.
  • Matebulo a mautumiki owonjezera kuti muwunikenso magwiridwe antchito.
  • Mawonedwe a INFORMATION_SCHEMA.KEYWORDS ndi INFORMATION_SCHEMA.SQL_FUNCTIONS awonjezedwa ku gulu lazidziwitso, kusonyeza mndandanda wa mawu osakira ndi ntchito zomwe zilipo.
  • Zosungirako za TokuDB ndi CassandraSE zachotsedwa.
  • Kabisidwe ka utf8 kasamutsidwa kuchokera ku mawonekedwe a ma byte anayi utf8mb4 (U+0000..U+10FFFF) kupita ku utf8mb3 wa ma baiti atatu (amakwirira mtundu wa Unicode U+0000..U+FFFF).
  • Thandizo lowonjezera la socket activation mu systemd.
  • Pulogalamu yowonjezera ya GSSAPI yawonjezera chithandizo cha mayina amagulu a Active Directory ndi ma SID.
  • Chowonadi chowonjezedwa kuti muwone ngati fayilo yosinthira ilipo $MARIADB_HOME/my.cnf kuwonjezera pa $MYSQL_HOME/my.cnf.
  • Zosintha zatsopano binlog_expire_logs_seconds, innodb_deadlock_report, innodb_read_only_compressed, wsrep_mode ndi Innodb_buffer_pool_pages_lru_freed zakhazikitsidwa.

Source: opennet.ru

Kuwonjezera ndemanga