MariaDB 12.1 preview available

We are 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)

Download MariaDB 12.1 preview


Thanks, and enjoy MariaDB!