MariaDB 10.9 tokollo e tsitsitseng

Tokollo ea pele e tsitsitseng ea lekala le lecha la DBMS MariaDB 10.9 (10.9.2) e hatisitsoe, moo lekala la MySQL le ntseng le ntlafatsoa le bolokang ho lumellana ka morao 'me le khetholloa ka ho kopanngoa ha lienjini tse eketsehileng tsa polokelo le bokhoni bo tsoetseng pele. Nts'etsopele ea MariaDB e tsamaisoa ke Mokhatlo o ikemetseng oa MariaDB, ho latela ts'ebetso ea nts'etsopele e bulehileng ka ho felletseng e ikemetseng ho barekisi ka bomong. MariaDB e fanoa e le sebaka sa MySQL ho li-distributions tse ngata tsa Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) 'me e sebelisitsoe mererong e meholo e kang Wikipedia, Google Cloud SQL le Nimbuzz.

Lintlafatso tsa bohlokoa ho MariaDB 10.9:

  • E kentse tšebetso ea JSON_OVERLAPS, e u lumellang hore u tsebe ho fumana mateano a litsela tsa data ea litokomane tse peli tsa JSON (mohlala, e fana ka 'nete haeba litokomane ka bobeli li na le lintho tse nang le senotlolo se tloaelehileng / boleng kapa likarolo tse tloaelehileng).
  • Lipolelo tsa JSONPath li fana ka bokhoni ba ho hlakisa mefuta (mohlala, "$[1 ho isa ho 4]" ho sebelisa likarolo tse 1 ho isa ho tse 4) le li-index tse mpe (mohlala, "SELECT JSON_EXTRACT(JSON_ARRAY(1, 2, 3), '$ [- 1]');" ho hlahisa ntho ea pele ho tloha mohatleng).
  • E kentse plugin ea Hashicorp Key Management ho patala data litafoleng ho sebelisa linotlolo tse bolokiloeng ho Hashicorp Vault KMS.
  • Sesebelisoa sa mysqlbinlog se fana ka likhetho tse ncha "-do-domain-ids", "-ignore-domain-ids" le "-ignore-server-ids" bakeng sa ho sefa ka gtid_domain_id.
  • E kenyellelitse bokhoni ba ho bonts'a mefuta e fapaneng ea boemo ba wsrep faeleng e arohaneng ka sebopeho sa JSON, se ka sebelisoang lits'ebetsong tsa ho beha leihlo kantle.
  • Tšehetso e ekelitsoeng bakeng sa mokhoa oa "SHOW ANALYZE [FORMAT=JSON]" bakeng sa tlhahiso ka mokhoa oa JSON.
  • Polelo ea "SHOW HLALOSA" joale e ts'ehetsa poleloana ea "HLALOSA BAKENG SA KHOPO".
  • Innodb_change_buffering le mefuta ea khale e tlositsoe (e nkeloe sebaka ke mofuta oa khale_mode).

Source: opennet.ru

Eketsa ka tlhaloso