MariaDB 11.3.0 Release Notes

Download | Release Notes | Changelog | Overview of 11.3

Release date: 20 September 2023

Do not use alpha releases in production!

MariaDB 11.3 is a current development series of MariaDB. It is an evolution of MariaDB 11.2 with several entirely new features.

MariaDB 11.3.0 is a single preview release. Features are to be considered preview, and none are guaranteed to make it into MariaDB 11.3.

The preview is available as a container quay.io/mariadb-foundation/mariadb-devel:11.3-preview.

For an overview of MariaDB 11.3 see theWhat is MariaDB 11.3? page.

Thanks, and enjoy MariaDB!

Connection Redirection

• Added a using the system variable ()

• At the moment client-side support is missing

InnoDB

• Shrink without restart by setting the system variable. ()

Replication

• Add keywords "SQL_BEFORE_GTIDS" and "SQL_AFTER_GTIDS" for (). SQL_BEFORE_GTIDS stops the replica when it sees gtids of the option's argument list, without executing them.

SSL/TLS

• Note that this feature did not make it into , but is in .

• is now enabled in the server by default. No configuration necessary, if no server certificate was provided a self-signed certificate will be automatically generated by the server. See on mariadb.org ().

• Clients now can validate self-signed server certificates if the or authentication is used and account password is not empty ().

Data Types

• data types can now be cast into types ()

• This means, INET4 values can be compared with INET6 values and can be inserted into INET6 columns, the server can automatically convert INET4 value into INET6 as needed.

Functions

• Values generated by the Key Derivation Function are resistant against password hashing generators, so are good for strongly hashed passwords ().

Date and Time

• function can now print the current time zone abbreviation and current time zone offset from UTC with %Z and %z format specifiers. ()

Optimizer

• Queries like can now use an index on varchar_col if its collation is case insensitive. An option, , has been added to enable this optimization. ()

Privileges

• Add a new database-level , SHOW CREATE ROUTINE that allows to see the routine definition even if the user isn't the routine owner ()

Processlist

• Added a SENT_ROWS column to the table, as well as extended the display size for the columns in processlist to ensure that most results will fit in display ()

Application-Time Periods

• Note that this feature did not make it into , but is in .

• Add views for in information_schema (), in particular

• New view

• New view

OLD_MODE

• Setting a non-default value will now always issue a deprecation warning ()

mariadb-backup

• mode has been deprecated ()

Spider

• The storage engine now supports table options instead of having to encode them in COMMENT/CONNECTION strings. When any table option is specified, Spider will ignore COMMENT/CONNECTION strings at the same table/partition/subpartition. A new variable is introduced to ignore them globally at all levels (table/partition/subpartition). Another variable, , is introduced to suppress warnings when Spider ignores COMMENT/CONNECTION strings. ()

Removed

The following deprecated features and system variables have been removed ():

• (deprecated since )

• sr_YU (deprecated since )

• "engine_condition_pushdown" in (deprecated since )

• , , , (deprecated since )