Changes and Improvements in MariaDB 10.9

MariaDB 10.9 is no longer maintained. Please use a more recent release.

The most recent release of MariaDB 10.9 is:MariaDB 10.9.8 Stable (GA) Download Now

MariaDB 10.9 is a previous short-term release series. The first stable release was in August 2022, and it was maintained until August 2023.

Upgrading

• See Upgrading Between Major MariaDB Versions and Upgrading from MariaDB 10.8 to 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)

• 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)

and Status Variables Added in MariaDB 10.9.

Security Vulnerabilities Fixed in MariaDB 10.9

For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the Security Vulnerabilities Fixed in MariaDB page.

• CVE-2022-47015: MariaDB 10.9.6

• CVE-2022-38791: MariaDB 10.9.2

• CVE-2022-32091: MariaDB 10.9.2

• CVE-2022-32089: MariaDB 10.9.2

• CVE-2022-32084: MariaDB 10.9.2

• CVE-2022-32082: MariaDB 10.9.2

• CVE-2022-32081: MariaDB 10.9.2

• CVE-2018-25032: MariaDB 10.9.2

List of All MariaDB 10.9 Releases

Date	Release	Status	Release Notes	Changelog
Date	Release	Status	Release Notes	Changelog
14 Aug 2023	MariaDB 10.9.8	Stable (GA)	Release Notes	Changelog
7 Jun 2023	MariaDB 10.9.7	Stable (GA)	Release Notes	Changelog
10 May 2023	MariaDB 10.9.6	Stable (GA)	Release Notes	Changelog
6 Feb 2023	MariaDB 10.9.5	Stable (GA)	Release Notes	Changelog
7 Nov 2022	MariaDB 10.9.4	Stable (GA)	Release Notes	Changelog
19 Sep 2022	MariaDB 10.9.3	Stable (GA)	Release Notes	Changelog
22 Aug 2022	MariaDB 10.9.2	Stable (GA)	Release Notes	Changelog
20 May 2022	MariaDB 10.9.1	RC	Release Notes	Changelog
23 Mar 2022	MariaDB 10.9.0	Alpha	Release Notes

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

_{This page is licensed: CC BY-SA / Gnu FDL}