published The first stable release of the new DBMS branch mariadb 10.9 (10.9.2), which develops a branch from MySQL, which retains reverse compatibility and characterized by the integration of additional storage and advanced capabilities. The development of Mariadb is supervised by the independent organization of Mariadb Foundation in accordance with a fully open and transparent development process, independent of individual manufacturers. Mariadb is supplied instead of MySQL in many distributions of Linux (Rhel, Suse, Fedora, Opensuse, Slackware, OpenMandriva, Rosa, Arch Linux, Debian) and implemented in large projects as Wikipedia, Google Cloud SQL and NIMBUZ. href=”https://mariadb.com/kb/en/mariadb-1092-release-notes/”> improvements mariadb 10.9 :
- Added the function json_overlaps , which allows you to determine the intersections in these two JSON documents (for example, it gives out True if both in both Documents are found objects with a common pair key/value or general elements of an array).
- Jsonpath’s expressions are given the ability to indicate the ranges (for example, “$ [1 to 4]” to use the elements of an array from 1 to 4) and negative indices (for example, “Select json_extract (json_array (1, 2, 3), ‘ $ [-1] ‘); “To withdraw the first element from the tail).
- Added plugin hashicorp key management for encryption of the keys stored in Hashicorp vault kms.
- In the utility mysqlbinlog new options are offered “–Do-domain-ids”, “–IGNORE-DOMAIN -ids “and” ignore-server-iods “for filtering by identifiers gtid_domain_id.
- Added the possibility of reflecting the variable WSREP state in a separate file in JSON format, which can be used in external monitoring systems.
- Added support for the “Show Analyze [Format = JSON]” mode for the output in JSON.
- In the expression “ show explain ” support for syntax “Explain for Connection”.
- Transferred in the category of outdated variables innodb_change_buffering and OLD (replaced by the Old_Mode variable).