What’s new and changed with MariaDB 10.8?
The lag-free ALTER TABLE MariaDB Replication: In MariaDB 10.8, ALTER TABLE gets replicated and starts executing on replicas when it starts executing on the primary, not when it finishes. So the replication lag caused by a heavy ALTER TABLE can be completely eliminated (MDEV-11675).
MariaDB 10.8 support Descending Indexes: You can now explicitly sort individual columns in ascending or descending order improving performance on selected ORDER BY cases (MDEV-13756, MDEV-26938, MDEV-26939, MDEV-26996)
InnoDB redo log improvements:
- innodb_buffer_pool_chunk_size (MDEV-25342) autosize
- More optimal and efficient redo log (MDEV-14425) concurrency
JSON storage for Histograms in the statistics table
Improvements on Spider Storage Engine
You can now declare Spider connections with REMOTE_SERVER, REMOTE_DATABASE, and REMOTE_TABLE attributes and not abuse the COMMENT field for that. This feature works for both the whole table and per partition (MDEV-5271, MDEV-27106).
MariaDB 10.8 mariadb-binlog with GTID support
MariaDB 10.8 binary logs/mysqlbinlog (mariadb-binlog) GTID support both filtering events by GTID ranges through –start-position and –stop-position, and validating a binary log’s ordering of GTIDs through –gtid-strict-mode (MDEV-4989).
MariaDB 10.8 new system variables