The first stable release of the new branch of the MariaDB database system 10.9 (10.9.2) has been published. This branch develops as a fork of MySQL, maintaining backward compatibility and featuring the integration of additional storage engines and advanced capabilities. The development of MariaDB is overseen by the independent MariaDB Foundation, in accordance with a fully open and transparent development process, independent of specific vendors. MariaDB replaces MySQL in many Linux distributions (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) and is implemented in major projects such as Wikipedia, Google Cloud SQL, and Nimbuzz.
Key improvements in MariaDB 10.9:
- The JSON_OVERLAPS function has been added, allowing the determination of intersections between two JSON documents (for example, it returns true if both documents contain objects with a common key/value pair or common array elements).
- In JSONPath expressions, it is now possible to specify ranges (for example, '$[1 to 4]' for using array elements from 1 to 4) and negative indexes (for instance, 'SELECT JSON_EXTRACT(JSON_ARRAY(1, 2, 3), '$[-1]');' to return the last element).
- A Hashicorp Key Management plugin has been added for encrypting data in tables using keys stored in Hashicorp Vault KMS.
- The mysqlbinlog utility now offers new options '--do-domain-ids', '--ignore-domain-ids', and '--ignore-server-ids' for filtering by gtid_domain_id identifiers.
- The ability to mirror wsrep state variables into a separate JSON file has been added, which can be used in external monitoring systems.
- Support for the 'SHOW ANALYZE [FORMAT=JSON]' mode has been added for output in JSON format.
- The 'SHOW EXPLAIN' expression 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
