Changes and Improvements in MariaDB 10.9

MariaDB 10.9 is a current short-term support development branch. See Plans for MariaDB 10.9.

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)

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/mysqlbinlog (MDEV-20119)
• 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