MariaDB Enterprise Server Q4 2024 Maintenance Releases with Backported Features

Posted on December 10, 2024 by
spacer

New maintenance releases for MariaDB Enterprise Server 10.6.20-16 and 10.5.27-21 are now available. These releases include new backported features.

Download Now

Backported Features in MariaDB 10.6.20-16

New, Detailed Replication Lag Representation

  • The Seconds_Behind_Master field of SHOW REPLICA STATUS can be complex and confusing, especially when parallel replication, delayed replication, or the option sql_slave_skip_counter is used. To help provide a consistent view of replication lag, three new fields have been added to the statement’s output to provide specific timing information about the state of the IO and SQL threads.

New Information Schema Table For Password Related Data

  • A new information Schema view, USERS, has been added, which DBAs can use to get insights about password related information for a user. This information can be used:
    • by an application to inform a user about a password about to expire or an account which is at risk of being blocked due to the number of wrong passwords entered
    • by DBAs to query users which have been blocked because of too many invalid passwords entered

GTID binary log events now include the thread ID

  • The thread ID and the corresponding statement can now be retrieved from binary logs
  • The output of mariadb-dump also includes the thread ID

For more information check the backports section of the MariaDB Enterprise Server 10.6.20-16 Release Notes.

Other Notable Release Updates

MariaDB Enterprise Server 10.6.20-16
  • MariaDB Enterprise Server 10.6.20-16 Release Notes
  • Notable Changes:
    • A new parameter --quick-max-column-width is now available to limit the field width when used with the --quick mode
    • JSON_TABLE allows to specify default column values, but they had to be specified as string constants
    • A new option --skip-freed-pages has been added
    • This release incorporates Galera library version 26.4.20
    • This release incorporates MariaDB ColumnStore storage engine version 23.10.2
MariaDB Enterprise Server 10.5.27-21

Why MariaDB Enterprise Server

MariaDB Enterprise Server is an enhanced, hardened and secured version of MariaDB Community Server that delivers enterprise reliability, stability and long-term support as well as greater operational efficiency when it comes to managing large database deployments for business and mission critical applications. MariaDB Enterprise Server offers additional features needed for production workloads that are not available in the community edition, such as Enterprise Audit and Enterprise Backup, and also backports certain enterprise features to older versions so customers can take advantage of critical fixes and features immediately instead of having to upgrade to the newest version.

Being able to backport features from newer release series to older versions is a key advantage of MariaDB Enterprise Server. Quality assurance and internal processes do not always allow customers to upgrade production environments to the newest and greatest release series, although some of the new features would be of value. MariaDB Enterprise Server can help in this case, as we can backport highly requested features to existing versions in cases where we can assure that a backported feature does not decrease the stability of that release series of MariaDB Enterprise Server.

Download MariaDB Enterprise Server

MariaDB customers can download MariaDB Enterprise Server versions at mariadb.com/downloads/enterprise.