A preview of MariaDB 12.1, a rolling release, has been made available by the MariaDB Foundation. Performance enhancements in the update include delayed logging for the audit plugin, parallel replication for Galera replicas, segmented key cache for Aria, improved MDL scalability, and quicker vector distance computations through extrapolation. Compatibility features like the caching_sha2_password plugin, associative arrays, optimizer hints, and other features like functional index support, wildcard support, and retrying write sets on Galera nodes are also included.
MariaDB 12.1 preview available
he MariaDB Foundation is pleased to announce the availability of a preview of the MariaDB 12.1 series. MariaDB 12.1 will be a rolling release.
MariaDB 12.1 introduces numerous new features, in particular
Performance improvements
- Segmented key cache for Aria ( MDEV-24)
- MDL scalability improvements ( MDEV-19749)
- Parallel replication for galera replicas ( MDEV-20065)
- Buffered logging for audit plugin ( MDEV-34680)
- Faster vector distance calculations via extrapolation ( MDEV-36205)
Compatibility features
- caching_sha2_password plugin ( MDEV-9804)
- ( + ) for outer join syntax ( MDEV-13817)
- rpl_semi_sync_master_wait_for_slave_count ( MDEV-18983)
- Associative arrays: DECLARE TYPE .. TABLE OF .. INDEX BY ( MDEV-34319)
- DROP USER fails if the user has active session ( MDEV-35617)
- Optimizer hints: [NO_]JOIN_INDEX, [NO_]GROUP_INDEX, [NO_]ORDER_INDEX, [NO_]INDEX ( MDEV-35856)
- Optimizer hints: [NO_]SPLIT_MATERIALIZED ( MDEV-36092)
- Optimizer hints: [NO_]DERIVED_CONDITION_PUSHDOWN, [NO_]MERGE ( MDEV-36106)
Miscellaneous
- Retry applying of write sets on galera nodes ( MDEV-36077)
- Wildcard support in mariadb-dump ( MDEV-21376)
- Per-table unique FOREIGN KEY constraint names ( MDEV-28933)
- Remove depth limit from JSON functions ( MDEV-32854)
- Support for functional indexes in GROUP/ORDER BY ( MDEV-36132)
- Include definitions of tables and views in the optimizer trace ( MDEV-36483)
