MariaDB 10.9 yakagadzikana kuburitswa

Kusunungurwa kwekutanga kwakagadzikana kwebazi idzva reDBMS MariaDB 10.9 (10.9.2) rakabudiswa, mukati umo bazi reMySQL riri kugadzirwa rinochengetedza kuwirirana kwemashure uye rinosiyaniswa nekubatanidzwa kwemamwe mainjini ekuchengetedza uye unyanzvi hwepamusoro. Kubudirira kweMariaDB kunotariswa neiyo yakazvimirira MariaDB Foundation, ichitevera yakavhurika uye yakajeka yekuvandudza maitiro ayo akazvimirira kune ega vatengesi. MariaDB inopihwa sechinzvimbo cheMySQL pane akawanda Linux kugoverwa (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) uye yakaitwa mumapurojekiti makuru akadai seWikipedia, Google Cloud SQL uye Nimbuzz.

Kuvandudza kwakakosha muMariaDB 10.9:

  • Yakawedzera JSON_OVERLAPS basa, iro rinokutendera kuti uone kupindirana mudata remagwaro maviri eJSON (semuenzaniso, inodzosera chokwadi kana zvese zvinyorwa zvine zvinhu zvine kiyi / kukosha kwakafanana kana zvakajairika array elements).
  • Mataurirwo eJSONPath anopa kugona kudoma mutsara (semuenzaniso, "$[1 kusvika 4]" kuti ushandise array element 1 kusvika 4) nenegative indexes (semuenzaniso, "SELECT JSON_EXTRACT(JSON_ARRAY(1, 2, 3), '$ [- 1]');" kuratidza chinhu chekutanga kubva kumuswe).
  • Yakawedzera Hashicorp Key Management plugin ye encrypt data mumatafura uchishandisa makiyi akachengetwa muHashicorp Vault KMS.
  • Iyo mysqlbinlog utility inopa sarudzo nyowani "--do-domain-ids", "-ignore-domain-ids" uye "-ignore-server-ids" yekusefa ne gtid_domain_id.
  • Yakawedzera kugona kuratidza wrep mamiriro akasiyana mune yakaparadzana faira muJSON fomati, iyo inogona kushandiswa kunze kwekutarisa masisitimu.
  • Yakawedzerwa rutsigiro rwe "SHOW ANALYZE [FORMAT=JSON]" maitiro ekubuda muJSON fomati.
  • Chirevo che "SHOW TSANANGURA" ikozvino chinotsigira chirevo che" TSANANGURA CHEKUBANGANISA" syntax.
  • Iyo innodb_change_buffering uye madhirigi ekare akaregwa (akatsiviwa neyekare_mode chinja).

Source: opennet.ru

Voeg