Changes and Improvements in MariaDB 10.9

MariaDB 10.9 is the current short-term branch, maintained until August 2023.

New Features & Improvements

JSON

• JSON_OVERLAPS function (MDEV-27677)
• Implement range notation for JSONPath (MDEV-27911)
• Support JSONPath negative index (MDEV-22224)

InnoDB

• innodb_log_file_size is now dynamic (MDEV-27812)
• InnoDB performance improvements (MDEV-27557, MDEV-28185, MDEV-27767, MDEV-28313, MDEV-28137, MDEV-28465, MDEV-26789)
• innodb_disallow_writes removed (MDEV-25975)

Hashicorp Key Management Plugin

• Hashicorp Key Management Plugin for implementing encryption using keys stored in the Hashicorp Vault KMS (MDEV-19281)

Replication and Galera

• Implement the --do-domain-ids, --ignore-domain-ids, and --ignore-server-ids options for mariadb-binlog (MDEV-20119)
• Semisync-slave server recovery is extended to work on new server_id server (MDEV-27342)
• mariadb-binlog --stop-never --raw now flushes the result file to disk after each processed event so the file can be listed with the actual bytes (MDEV-14608)
• JSON file interface to wsrep node state / SST progress logging (MDEV-26971)

SHOW ANALYZE FORMAT=JSON

• Extend SHOW EXPLAIN to support SHOW ANALYZE [FORMAT=JSON] (MDEV-27021)
• Add EXPLAIN FOR CONNECTION syntax support to SHOW EXPLAIN (MDEV-10000)

Variables

• For a list of all new variables, see System Variables Added in MariaDB 10.9.
• Merge old to old_mode sql variable (MDEV-24920)

The following variables have been deprecated:

• innodb_change_buffering
• old (replaced by old_mode)

List of All MariaDB 10.9 Releases