The first stable release of the new MariaDB 10.9 (10.9.2) DBMS branch has been published, within which a branch from MySQL is being developed that maintains backward compatibility and is distinguished by the integration of additional storage engines and advanced features. MariaDB development is overseen by the independent MariaDB Foundation, following a fully open and transparent development process independent of individual vendors. MariaDB is shipped in place of MySQL on many Linux distributions (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) and has been adopted by major projects such as Wikipedia, Google Cloud SQL, and Nimbuzz.
Key improvements in MariaDB 10.9:
- The JSON_OVERLAPS function has been added, which allows you to determine the intersections in the data of two JSON documents (for example, returns true if both documents contain objects with a common key/value pair or common array elements).
- JSONPath expressions provide the ability to specify ranges (for example, "$[1 to 4]" to use array elements 1 to 4) and negative indexes (for example, "SELECT JSON_EXTRACT(JSON_ARRAY(1, 2, 3), '$[- 1]');" to display the first element from the tail).
- Added Hashicorp Key Management plugin to encrypt data in tables using keys stored in Hashicorp Vault KMS.
- The mysqlbinlog utility has new options "--do-domain-ids", "--ignore-domain-ids", and "--ignore-server-ids" to filter by gtid_domain_id.
- Added the ability to reflect wsrep state variables in a separate JSON file that can be used in external monitoring systems.
- Added support for "SHOW ANALYZE [FORMAT=JSON]" mode for output in JSON format.
- The "SHOW EXPLAIN" statement now supports the "EXPLAIN FOR CONNECTION" syntax.
- The innodb_change_buffering and old variables have been deprecated (replaced by the old_mode variable).
Source: opennet.ru