Announcing MariaDB Server 10.6.0 Alpha

We are pleased to announce the first release of MariaDB Server 10.6.  MariaDB Server 10.6 is the next major version of our yearly MariaDB Server Release Series, following the MariaDB Server 10.5 GA release last July.

For MariaDB Server 10.6 a focus has been set on internal optimizations and clean-ups, and also the preparation for new features like storage engine independent foreign key support. Such preparations provide the baseline for a strong storage engine based model for MariaDB Server, to leverage multiple storage engines implemented for different workloads, and to support new, combined use cases.

Some of the new features in MariaDB Server 10.6.0 are:

  • The JSON function JSON_TABLE, which is used to extract JSON data based on a JSON path expression and to return it as a relational table. Column names and types can be defined, nested paths are supported
  • InnoDB can now execute SELECT [FOR UPDATE|LOCK IN SHARED MODE] … SKIP LOCKED where already-locked rows are ignored
  • The SQL:2008 compliant Syntax
    OFFSET start { ROW | ROWS } FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } { ONLY | WITH TIES } can be used instead of LIMIT count OFFSET start. It also provides the new WITH TIES option
  • In addition to an index hint to ignore an index for a query you can now define to ignore the index on the DDL level for CREATE TABLE/INDEX or ALTER TABLE/INDEX. An index hint would be used to control the execution plan for a query. The new DDL level option can be used by DBAs to test the application behavior before the index is completely removed, which is a more expensive task.
  • The Performance Schema includes information related to the replica worker threads, using the  replication_applier_status_by_worker table
  • A System Schema is now provided with MariaDB Server, which includes a set of views, functions and stored procedures to help DBAs analyzing the Performance Schema
  • The length of the primary host name can now be a 255 bytes value
  • MariaDB Cluster (Galera):
    • The primary node for replication can now be switched in MariaDB Cluster without the need to reconfigure the replication when using Global Transaction IDs
    • New configuration options for Galera to assure that some functionality is disabled / enabled to harden a MariaDB Cluster environment

We encourage you to download this release today. Please note that we do not recommend running alpha releases in production.

Try MariaDB Community Server 10.6 Alpha and share your feedback.

 

Release NotesDownload