ืคึผืจืึธื”ืึธืกื˜ืขืจ > ื‘ืœืึธื’ > ืื™ื ื˜ืขืจื ืขื˜ ื ื™ื™ึทืขืก > ืกื˜ืึทื‘ื™ืœ ืžืขืœื“ื•ื ื’ ืคื•ืŸ MariaDB DBMS 10.9

ืกื˜ืึทื‘ื™ืœ ืžืขืœื“ื•ื ื’ ืคื•ืŸ MariaDB DBMS 10.9

ื“ืขืจ ืขืจืฉื˜ืขืจ ืกื˜ืึทื‘ื™ืœ ืžืขืœื“ื•ื ื’ ืคื•ืŸ ื“ื™ ื ื™ื™ึทืข ืฆื•ื•ื™ื™ึทื’ ืคื•ืŸ ื“ื™ DBMS MariaDB 10.9 (10.9.2) ืื™ื– ืืจื•ื™ืก, ืื™ืŸ ื•ื•ืึธืก ืึท ืฆื•ื•ื™ื™ึทื’ ืคื•ืŸ MySQL ืื™ื– ื“ืขื•ื•ืขืœืึธืคึผืขื“ ื•ื•ืึธืก ืžื™ื™ื ื˜ื™ื™ื ื– ืฆื•ืจื™ืง ืงืึทืžืคึผืึทื˜ืึทื‘ื™ืœืึทื˜ื™ ืื•ืŸ ืื™ื– ืื•ื ื˜ืขืจืฉื™ื™ื“ืŸ ื“ื•ืจืš ื“ื™ ื™ื ืึทื’ืจื™ื™ืฉืึทืŸ ืคื•ืŸ ื ืึธืš ืกื˜ืึธืจื™ื“ื–ืฉ ืขื ื“ื–ืฉืึทื ื– ืื•ืŸ ืึทื•ื•ืึทื ืกื™ืจื˜ืข ืงื™ื™ืคึผืึทื‘ื™ืœืึทื˜ื™ื–. MariaDB ืึทื ื˜ื•ื•ื™ืงืœื•ื ื’ ืื™ื– ืึธื•ื•ื•ืขืจืกืึทืŸ ื“ื•ืจืš ื“ื™ ืคืจื™ื™ึท MariaDB ื•ื•ื™ืงื™ืคึผืขื“ื™ืข, ื ืึธืš ืึท ื’ืึธืจ ืึธืคึฟืŸ ืื•ืŸ ื˜ืจืึทื ืกืคึผืขืจืึทื ื˜ ืึทื ื˜ื•ื•ื™ืงืœื•ื ื’ ืคึผืจืึธืฆืขืก ื•ื•ืึธืก ืื™ื– ืคืจื™ื™ึท ืคื•ืŸ ื™ื—ื™ื“ ื•ื•ืขื ื“ืึธืจืก. MariaDB ืื™ื– ืกืึทืคึผืœื™ื™ื“ ื•ื•ื™ ืึท ืคืึทืจื‘ื™ื™ึทื˜ ืคึฟืึทืจ MySQL ืื™ืŸ ืคื™ืœืข ืœื™ื ื•ืงืก ื“ื™ืกื˜ืจื™ื‘ื™ื•ืฉืึทื ื– (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) ืื•ืŸ ืื™ื– ื™ืžืคึผืœืึทืžืขื ืึทื“ ืื™ืŸ ืึทื–ืึท ื’ืจื•ื™ืก ืคึผืจืึทื“ื–ืฉืขืงืก ื•ื•ื™ Wikipedia, Google Cloud SQL ืื•ืŸ Nimbuzz.

ืฉืœื™ืกืœ ื™ืžืคึผืจื•ื•ื•ืžืึทื ืฅ ืื™ืŸ MariaDB 10.9:

  • ืฆื•ื’ืขื’ืขื‘ืŸ ื“ื™ JSON_OVERLAPS ืคื•ื ืงืฆื™ืข, ื•ื•ืึธืก ืึทืœืึทื•ื– ืื™ืจ ืฆื• ื‘ืึทืฉื˜ื™ืžืขืŸ ื™ื ื˜ืขืจืกืขืงืฉืึทื ื– ืื™ืŸ ื“ื™ ื“ืึทื˜ืŸ ืคื•ืŸ ืฆื•ื•ื™ื™ JSON ื“ืึธืงื•ืžืขื ื˜ืŸ (ืœืžืฉืœ, ืขืก ืงืขืจื˜ ืืžืช ืื•ื™ื‘ ื‘ื™ื™ื“ืข ื“ืึธืงื•ืžืขื ื˜ืŸ ืึทื ื˜ื”ืึทืœื˜ืŸ ืึทื‘ื“ื–ืฉืขืงืฅ ืžื™ื˜ ืึท ืคึผืจืึธืกื˜ ืฉืœื™ืกืœ / ื•ื•ืขืจื˜ ืคึผืึธืจ ืึธื“ืขืจ ืคึผืจืึธืกื˜ ืžืขื ื’ืข ืขืœืขืžืขื ื˜ืŸ).
  • JSONPath ืื•ื™ืกื“ืจื•ืงืŸ ืฆื•ืฉื˜ืขืœืŸ ื“ื™ ืคื™ื™ื™ืงื™ื™ื˜ ืฆื• ืกืคึผืขืฆื™ืคื™ืฆื™ืจืŸ ืจื™ื™ื ื“ื–ืฉืึทื– (ืœืžืฉืœ, "$[1 ืฆื• 4]" ืฆื• ื ื•ืฆืŸ ืžืขื ื’ืข ืขืœืขืžืขื ื˜ืŸ 1 ืฆื• 4) ืื•ืŸ ื ืขื’ืึทื˜ื™ื•ื• ื™ื ื“ืขืงืกื™ื– (ืคึฟืึทืจ ื‘ื™ื™ึทืฉืคึผื™ืœ, "SELECT JSON_EXTRACT(JSON_ARRAY(1, 2, 3), '$ [- 1]');" ืฆื• ื•ื•ื™ื™ึทื–ืŸ ื“ืขืจ ืขืจืฉื˜ืขืจ ืขืœืขืžืขื ื˜ ืคื•ืŸ ื“ื™ ืขืง).
  • ืฆื•ื’ืขื’ืขื‘ืŸ Hashicorp Key Management ืคึผืœื•ื’ื™ืŸ ืฆื• ืขื ืงืจื™ืคึผื˜ ื“ืึทื˜ืŸ ืื™ืŸ ื˜ื™ืฉืŸ ื ื™ืฆืŸ ืฉืœื™ืกืœืขืŸ ืกื˜ืึธืจื“ ืื™ืŸ Hashicorp Vault KMS.
  • ื“ื™ mysqlbinlog ื ื•ืฆืŸ ืึธืคืคืขืจืก ื ื™ื™ึทืข ืึธืคึผืฆื™ืขืก "--do-domain-ids", "-ignore-domain-ids" ืื•ืŸ "-ignore-server-ids" ืคึฟืึทืจ ืคึฟื™ืœื˜ืจื™ืจื•ื ื’ ื“ื•ืจืš gtid_domain_id.
  • ืฆื•ื’ืขืœื™ื™ื’ื˜ ื“ื™ ืคื™ื™ื™ืงื™ื™ื˜ ืฆื• ื•ื•ื™ื™ึทื–ืŸ wsrep ืฉื˜ืึทื˜ ื•ื•ืขืจื™ืึทื‘ืึทืœื– ืื™ืŸ ืึท ื‘ืึทื–ื•ื ื“ืขืจ ื˜ืขืงืข ืื™ืŸ JSON ืคึฟืึธืจืžืึทื˜, ื•ื•ืึธืก ืงืขื ืขืŸ ื–ื™ื™ืŸ ื’ืขื•ื•ื™ื™ื ื˜ ืื™ืŸ ืคื•ื ื“ืจื•ื™ืกื ื“ื™ืง ืžืึธื ื™ื˜ืึธืจื™ื ื’ ืกื™ืกื˜ืขืžืขืŸ.
  • ืฆื•ื’ืขื’ืขื‘ืŸ ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ื“ื™ "ื•ื•ื™ื™ึทื–ืŸ ืึทื ืึทืœื™ืกื™ืก [FORMAT=JSON]" ืžืึธื“ืข ืคึฟืึทืจ ืจืขื–ื•ืœื˜ืึทื˜ ืื™ืŸ JSON ืคึฟืึธืจืžืึทื˜.
  • ื“ื™ "SHOW EXPLAIN" ื“ืขืจืงืœืขืจื•ื ื’ ืฉื˜ื™ืฆื˜ ืื™ืฆื˜ ื“ื™ "ื“ืขืจืงืœืขืจืŸ ืคึฟืึทืจ ืงืึทื ืขืงืฉืึทืŸ" ืกื™ื ื˜ืึทืงืก.
  • ื“ื™ innodb_change_buffering ืื•ืŸ ืึทืœื˜ ื•ื•ืขืจื™ืึทื‘ืึทืœื– ื–ืขื ืขืŸ ื“ื™ืคึผืจื™ืฉื™ื™ื™ื˜ื™ื“ (ืจื™ืคึผืœื™ื™ืกื˜ ื“ื•ืจืš ื“ื™ old_mode ื‘ื™ื™ึทื˜ืขื•ื•ื“ื™ืง).

ืžืงื•ืจ: opennet.ru

ืœื™ื™ื’ืŸ ืึท ื‘ืึทืžืขืจืงื•ื ื’