Release Notes for MariaDB Enterprise Server 10.5.4-2

This release of MariaDB Enterprise Server 10.5 is the first GA (Generally Available) release. It Includes a variety of new features.

MariaDB Enterprise Server 10.5.4-2 was released on 2020-07-16.

Note

With MariaDB Enterprise Server 10.5 "mysql" command names are replaced with "mariadb" command names. Symbolic links are in place to maintain backward compatibility with the old names and prevent disruption. (MDEV-21303)

Notable Changes

MariaDB Enterprise ColumnStore is a columnar storage engine for analytical workloads. MariaDB Enterprise ColumnStore 1.5.3 is included in this release. Specific details on this component may be found in the .

Changes in Storage Engines

• New in storage engine ColumnStore:

  • This release includes Enterprise .

  • Comprehensive rewrite of installation, cluster management, and failover logic

  • Support for standard MariaDB Server collations and character sets

SQL Level Enhancements

• MariaDB SQL statements support REPLICA a synonym for SLAVE ()

• RETURNING clause can be used for INSERT and REPLACE statements to return a result set of the inserted rows or another specified SQL statement ()

Replication and High Availability (HA)

• Replica aware server shutdown (MENT-731)

  • Primary only shuts down when replication transactions have been processed

  • Added the system variable to control default behavior

• based on Galera 4.1

Privileges and Security Features

• Key Management plugin for HashiCorp Vault System

• System variable for rejecting connections attempted using insecure transport ()

• privilege split into several smaller privileges, allowing for more fine grained tuning of what each user can do: , , , , , , , and ()

Optimizer Changes

• For filesort, the mode addon_fields, addon_fields, or packed_addon_fields used for sorting will be shown in ANALYZE FORMAT=JSON ()

• Through enhancement to Query Optimizer, now shows the time spent for checking WHERE clauses and performing other auxiliary operations ()

• Enhancement for the sort buffer to allow packed values of non-sorted fields in the sort buffer (

Interface Changes

Tools

• aria_pack supports transactional tables

• aria_pack now supports --datadir, --ignore-control-file, and --require-control-file options

• now supports --ignore-table-data

Privileges and Security

• privilege renamed to , the old syntax still understood for compatibility ()

• Several statements changed required privileges and may require a number of statements to be issued after upgrade:

  • now requires BINLOG MONITOR privilege, instead of

New defaults

• Increased gcache.size option default in system variable to 1 GB via the MariaDB Enterprise Server config file

• Changed system variable default to OFF ()

• Changed system variable default to full_crc32 ()

Configuration Options

• Upgraded Performance Schema instrumentation and tables ()

• Support added for ENFORCE option with slave_run_triggers_for_rbr system variable ()

• Support added for sql_if_exists session system variable, which provides an implicit IF EXISTS to SQL statements altering, renaming, or dropping tables, views, functions, and packages (

Deprecated/Removed System Variables

• system variable removed ()

• system variable deprecated ()

• system variable removed ()

• system variable removed ()

Deprecated/Removed Information Schema

• Information Schema table removed ()

Aria Storage Engine

• Maximum key length for storage engine increased from 1000 to 2000 bytes

Platforms

In alignment with the , MariaDB Enterprise Server 10.5.4-2 is provided for:

• AlmaLinux 8 (x86_64, ARM64)

• AlmaLinux 9 (x86_64, ARM64)

• Debian 11 (x86_64, ARM64)

• Debian 12 (x86_64, ARM64)

Some components of MariaDB Enterprise Server might not support all platforms. For additional information, see "".

Note

MariaDB Enterprise Server 10.5 removes support for Red Hat Enterprise Linux (RHEL) 6 and CentOS 6.

Installation Instructions

Upgrade Instructions