The launch of the first stable version of the new DBMS branch MariaDB 10.9 (10.9.2), within which a branch of MySQL is being developed that maintains backward compatibility and is distinguished by the integration of additional storage engines and advanced features.
The development of MariaDB is overseen by the independent MariaDB Foundation, following a completely open and transparent development process, independent of individual vendors.
MariaDB ships instead of MySQL on many Linux distributions (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) and has been adopted by large projects.
Main new features of MariaDB 10.9
In this new version of MariaDB, it is highlighted that added JSON_OVERLAPS function to detect intersections in data of two JSON documents (for example, returns true if both documents contain objects with a common key/value pair or common array elements).
Also, it is highlighted that the pertinent corrections were made for the following security vulnerabilities: CVE-2022-32082, CVE-2022-32089, CVE-2022-32081, CVE-2018-25032, CVE-2022-32091 y CVE-2022-32084
Another change that stands out is that the expressions JSONPath provide the ability to specify ranges (eg "$[1 to 4]" to use array elements 1 to 4) and negative indices to display the first element in the queue).
In addition to this, we can find that the Hashicorp Key Management plugin was added to encrypt data in tables using keys stored in Hashicorp Vault KMS.
While for utility mysqlbinlog, now you have 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 by external monitoring systems.
Optimizer uses all partitions after upgrade to 10.3, for multi-table UPDATE or DELETE queries, the optimizer was unable to apply partition pruning optimization for the table being updated or deleted.
Besides that, performed a range optimizer regression for the IN key (const, ....), there was already an issue in MariaDB 10.5.9 and later that has the fix for MDEV-9750. That solution introduced Optimizer_max_sel_arg_weight. If one sets Optimizer_max_sel_arg_weight to a very high value or zero (meaning "unlimited") and runs queries that produce heavy graphs, they may notice slow performance.
Other fixes that were made in this new version of MariaDB, is in InnoDB corruption due to the lack of file locking, as well as a fix in ALTER TABLE IMPORT TABLESPACE which corrupted an encrypted table, also fixed ALTER TABLE incorrect output, crash recovery fixes, DD error recovery fixes, prevented locks on corrupted data, fixed bulk load bug fixes, and bug fixes performance.
Of the other changes that stand out from this new version:
- Added support for "SHOW PARCEL [FORMAT=JSON]" mode for JSON output.
- The "SHOW EXPLAIN" statement now supports the "EXPLAIN FOR CONNECTION" syntax.
- The variables innodb_change_buffering and old have been deprecated (replaced by the variable old_mode).
- FULL TEXT search with apostrophe and mandatory words
- Optimizer uses all partitions after upgrade to 10.3
- For multi-table UPDATE or DELETE queries, the optimizer was unable to apply partition pruning optimization for the table being updated or deleted.
- New mariadb client option, -enable-cleartext-plugin. The option does nothing and is for MySQL compatibility purposes only.
- Lock on JSON_EXTRACT
ALTER TABLE ALGORITHM=NOCOPY does not work after upgrade - Server fails to CREATE VIEW with unknown column in ON condition
- The password_reuse_check plugin combines username and password
- Per the MariaDB Deprecation Policy, this will be the last version of MariaDB 10.9 for Debian 10 "Buster" for ppc64el
Finally, if you are interested in knowing more about this new version, you can check the details at the following link.