Announcing MariaDB Community Server 10.10 GA and 10.11 RC

Posted on November 17, 2022 by
spacer

We are pleased to announce MariaDB Community Server 10.10 as GA (Generally Available) and the first RC (Release Candidate) of MariaDB Community Server 10.11.

MariaDB Community Server 10.10 now GA

MariaDB Community Server 10.10 GA adds features such as new collations based on the Unicode Collation Algorithm (UCA) 14.0.0, the INET4 data type, replication is using Global Transaction Ids per default, the maximum allowed execution time for a replicated query can be configured. MariaDB Galera Cluster increases security by restricting the nodes which can join a cluster. Read this blog for a full list of all new features in the 10.10 release series. The MariaDB Community Server 10.10 release series started with Preview Releases, then an RC release in August 2022. MariaDB Community Server 10.10.2 marks the first GA release in this series.

MariaDB Community Server 10.11 now RC

For the 10.11 community server release series, a DBA/DevOps can use GRANT … TO PUBLIC, defined in the SQL:1999 standard, to grant privileges to data objects to any user who has access to the server.

In accordance with our work of splitting up the SUPER privilege to more fine grain privileges we are now also working on making sure there is no overlap between SUPER and the new privileges. The READ ONLY ADMIN now needs to be set explicitly also for a SUPER user to be able to make changes on a replica.

A full logical dump of system versioned tables can now be created and used to restore a system versioned table.

In more detail, MariaDB Community Server 10.11 RC includes the following new features:

Community Server 10.11 RC Complete List of Features

For Developers
  • Optimizations to information schema system tables
    • The information schema provides tables with metadata about stored procedures and stored routines, which are often used by third party tools and MariaDB Connectors to retrieve details about existing routines. Previously, a high number of rows in these tables would have resulted in a performance impact. We have made a number of internal improvements to eliminate the performance impact completely for use cases, where metadata had to be queried regularly
For DevOps and DBAs
  • The new SQL syntax GRANT .. TO PUBLIC can now be used to easily grant privileges to databases or tables for any user, who has access to the server.
    • SHOW GRANTS FOR PUBLIC is an enhancement to the existing SHOW GRANTS syntax to retrieve all privileges granted to public
  • SUPER and READ ONLY ADMIN privileges are now separated
    • The READ ONLY ADMIN privileges now needs to be granted to a user with the SUPER privilege explicitly, if this user should have write access to a read only replica (a replica having read_only=1 set).
    • Read-only replicas are used to ensure that they stay consistent with the primary. This can now be ensured also if SUPER users try to update data on the replica
  • System versioned tables can now be dumped and restored by mariadb-dump
    • The new parameter mariadb-dump parameter --dump-history dumps all historical data
    • To restore from a dump file the new parameter system_versioning_insert_history needs to be enabled to allow direct inserts into ROW_START and ROW_END columns
    • The existing parameter secure_timestamp needs to be set to a value which allows changing session timestamps
  • ANALYZE FORMAT=JSON now shows the time spent in the query optimizer
    • In some cases optimizing the query can take a while. ANALYZE FORMAT=JSON now reports time as "query_optimization": {  "r_total_time_ms": NNNN.NNN } in the JSON string
  • The system variables innodb_write_io_threads and innodb_read_io_threads are now dynamic, and their values can be changed without restarting the server

We encourage you to Try MariaDB Community Server 10.11 RC today. Please note that we do not recommend running RC releases in production.

Resources