New Backported Features Available in MariaDB Enterprise Server Releases 10.3-10.6

New maintenance releases for MariaDB Enterprise Server 10.6.11-6, 10.5.18-13, 10.4.27-18 and 10.3.37-18 are now available. These releases include new backported features and other notable upgrades to the InnoDB storage engine.

Download Now

 

Backported Features

We identified several features that we released in MariaDB Community Server over the last few months that have now reached maturity and are ready for enterprise use. Now available in MariaDB Enterprise Server 10.6:

• To simplify maintenance, the ALTER TABLE statement supports new clauses to convert tables to partitions and partitions to tables.
  • To convert a partition to a table, use the CONVERT PARTITION .. TO TABLE .. clause:

    ALTER TABLE partitioned_table
         CONVERT PARTITION part1
         TO TABLE normal_table;

  • To convert a table to a partition, use the CONVERT TABLE .. TO PARTITION .. clause:

    ALTER TABLE partitioned_table
         CONVERT TABLE normal_table
         TO PARTITION part1 VALUES LESS THAN (12345);

  • The new CONVERT PARTITION and CONVERT TABLE clauses are crash-safe operations.

Now available in MariaDB Enterprise Server 10.5 and 10.6:

• The new slave_max_statement_time system variable is available to set the maximum execution time for queries on replica nodes.
  • When a query takes more than slave_max_statement_time seconds to run on the replica (slave) node, the query is aborted, and replication stops with an error.
  • The system variable can be set to a decimal value, where the decimal component has microsecond precision.

 

Other Release Updates

We have several other maintenance items included in these releases.

MariaDB Enterprise Server 10.6.11-6

• MariaDB Enterprise Server 10.6.11-6 Release Notes
• Notable Changes:
  • The information_schema.INNODB_SYS_TABLESPACES view shows details about the InnoDB temporary tablespace, which is the tablespace where InnoDB temporary tables are stored.
    • Starting with this release, the details details about the InnoDB temporary tablespace can be shown by querying for the name innodb_temporary:

      SELECT * FROM 
      information_schema.INNODB_SYS_TABLESPACES
      WHERE name LIKE 'innodb_temporary';

  • When a table’s default collation is set to the default collation for the table’s character set, SHOW CREATE TABLE shows the COLLATE clause.
  • Implemented CHECK TABLE .. EXTENDED for InnoDB.
    • When CHECK TABLE .. EXTENDED is executed, InnoDB confirms that no index contains orphan records.

 

MariaDB Enterprise Server 10.5.8-13

• MariaDB Enterprise Server 10.5.18-13 Release Notes
• Notable Changes:
  • The information_schema.INNODB_SYS_TABLESPACES view shows details about the InnoDB temporary tablespace, which is the tablespace where InnoDB temporary tables are stored.
    • Starting with this release, the details details about the InnoDB temporary tablespace can be shown by querying for the name innodb_temporary:

      SELECT * FROM 
      information_schema.INNODB_SYS_TABLESPACES
      WHERE name LIKE 'innodb_temporary';

  • When a table’s default collation is set to the default collation for the table’s character set, SHOW CREATE TABLE shows the COLLATE clause.

 

MariaDB Enterprise Server 10.4.27-18

• MariaDB Enterprise Server 10.4.27-18 Release Notes
• Notable Changes:
  • The information_schema.INNODB_SYS_TABLESPACES view shows details about the InnoDB temporary tablespace, which is the tablespace where InnoDB temporary tables are stored.
    • Starting with this release, the details details about the InnoDB temporary tablespace can be shown by querying for the name innodb_temporary:

      SELECT * FROM 
      information_schema.INNODB_SYS_TABLESPACES
      WHERE name LIKE 'innodb_temporary';

  • When a table’s default collation is set to the default collation for the table’s character set, SHOW CREATE TABLE shows the COLLATE clause.

 

MariaDB Enterprise Server 10.3.37-18

• MariaDB Enterprise Server 10.3.37-18 Release Notes
• Notable Changes:
  • The information_schema.INNODB_SYS_TABLESPACES view shows details about the InnoDB temporary tablespace, which is the tablespace where InnoDB temporary tables are stored.
    • Starting with this release, the details details about the InnoDB temporary tablespace can be shown by querying for the name innodb_temporary:

      SELECT * FROM 
      information_schema.INNODB_SYS_TABLESPACES
      WHERE name LIKE 'innodb_temporary';

  • When a table’s default collation is set to the default collation for the table’s character set, SHOW CREATE TABLE shows the COLLATE clause.

 

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 wp.mariadb.com/downloads/enterprise or try it in the cloud using MariaDB SkySQL – the only DBaaS that leverages the entire suite of MariaDB enterprise database products.