Changes and Improvements in MariaDB 11.3

MariaDB 11.3 is a current short-term development series, and will be maintained for one year after its Generally Available release. See Plans for MariaDB 11.3.

New Features & Improvements

Connection Redirection

• Added a redirect mechanism using the redirect_url system variable (MDEV-15935)
• At the moment client-side support is missing

InnoDB

• Shrink temporary tablespaces without restart by setting the innodb_truncate_temporary_tablespace_now system variable. (MDEV-28699)

Replication

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

SSL/TLS

• SSL 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 (MDEV-31856).
• Clients now can validate self-signed server certificates if the mysql_native_password or ed25519 authentication is used and account password is not empty (MDEV-31855).
• Clients now require SSL and have --ssl-verify-server-cert enabled by default (MDEV-31857).
• Replication clients do that too, MASTER_SSL_VERIFY_SERVER_CERT is enabled by default.
• Use --disable-ssl or --disable-ssl-verify-server-cert to revert to the old behavior.
• Clients can use new command line options --tls-fp and --tls-fplist to verify the server certificate by its fingerprint

Data Types

• INET4 data types can now be cast into INET6 types (MDEV-31626)
• 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

• Key derivation function KDF for generating good encryption keys for AES_ENCRYPT (MDEV-31474)

Date and Time

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

Optimizer

• Queries like UCASE(varchar_col)=... can now use an index on varchar_col if its collation is case insensitive. An optimizer_switch option, sargable_casefold=ON, has been added to enable this optimization. (MDEV-31496)

Privileges

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

Processlist

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

Application-Time Periods

• Add views for periods in information_schema (MDEV-22597), in particular
• New view INFORMATION_SCHEMA.PERIODS
• New view INFORMATION_SCHEMA.KEY_PERIOD_USAGE
• New columns IS_SYSTEM_TIME_PERIOD_START and IS_SYSTEM_TIME_PERIOD_END in the INFORMATION_SCHEMA.COLUMNS view

OLD_MODE

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

Mariabackup

• mariabackup --innobackupex mode has been deprecated (MDEV-31505)

Spider

• The Spider 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 spider_ignore_comment is introduced to ignore them globally at all levels (table/partition/subpartition). Another variable spider_suppress_comment_ignored_warning is introduced to suppress warnings when spider ignores COMMENT/CONNECTION strings. (MDEV-28856)

Removed

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

• debug (deprecated since MariaDB 5.5.37)
• sr_YU locale (deprecated since MariaDB 10.0.11)
• "engine_condition_pushdown" in optimizer_switch (deprecated since MariaDB 10.1.1)
• date_format, datetime_format, time_format, max_tmp_tables (deprecated since MariaDB 10.1.2)
• wsrep_causal_reads (deprecated since MariaDB 10.1.3)
• "parser" in mroonga table comment (deprecated since MariaDB 10.2.11)

Variables

• For a list of all new variables, see System Variables Added in MariaDB 11.3.

List of All MariaDB 11.3 Releases