Software update: MariaDB 10.6.6

MariaDB originated as a fork of MySQL, after it was taken over by Oracle. For an overview of the differences between MariaDB and MySQL you can visit: this one and this one pages right. MariaDB is a powerful open source database server, which is especially popular as a website and forum database. The developers have released version 10.6.6 and the main changes made to it are listed below:

InnoDB

• –skip-symbolic-links does not disallow .isl file creation (MDEV-26870†
• Indexed CHAR columns are broken with NO_PAD collations (MDEV-25440†
• insert-intention lock conflicts with waiting ORDINARY lock (MDEV-27025†
• Crash recovery improvements (MDEV-26784† MDEV-27022† MDEV-27183† MDEV-27610†
• mariabackup skips valid .ibd file (MDEV-26326†
• Allow seamless upgrade despite ROW_FORMAT=COMPRESSED (MDEV-27736†

gallery

• gallery updated to 26.4.11
• Galera SST scripts should use ssl_capath (not ssl_ca) for CA directory (MDEV-27181†
• Alter Sequence do not replicate to another nodes with in Galera Cluster (MDEV-19353†
• Galera crash – Assertion. Possible parallel writeset problem (MDEV-26803†
• CREATE TABLE with FOREIGN KEY constraint fails to apply in parallel (MDEV-27276†
• Galera cluster node consider old server_id value even after modification of server_id [wsrep_gtid_mode=ON] †MDEV-26223†

Replication

• Seconds behind master corrected from artificial spikes at relay-log rotation (MDEV-16091†
• Statement rollback in binlog when transaction creates or drop temporary table is set right (MDEV-26833†
• CREATE-or-REPLACE SEQUENCE is made to binlog with the DDL flag to stabilize its parallel execution on slave (MDEV-27365†

Packaging & Misc

• prohibition running two upgrades in parallel (MDEV-27068† MDEV-27107† MDEV-27279†
• As per the MariaDB Deprecation Policythis will be the last release of MariaDB 10.6 for Ubuntu 21.04 Hirsute, CentOS 8, and Fedora 33
• mariadb_repo_setup script updated to version 2022-02-08, with the following fixes and enhancements:
  • Default location of the script has been moved to: (old location is deprecated, but still works)
  • The GPG keyring file, used with Debian and Ubuntu repositories, has moved to: and the checksum for the file can be found at: .sha256
  • Support for RHEL and SLES aarch64 repositories added
  • New function added to verify that the MariaDB Server version, if specified on the command line, follows the correct naming and that a corresponding repository actually exists.
  • Fixed repository pinning for Ubuntu and Debian repositories
  • MariaDB Server 10.7 is now the default server version

Docker Library

• Faster initialization by disabling binary logging during initialization (MDEV-27074†
• mysql_upgrade can be run if needed using the environment variable MARIADB_AUTO_UPGRADE=1 (MDEV-25670†
• A healthcheck script /usr/local/bin/healthcheck.sh is installed in the container with various checking options (MDEV-25434†
• mysql@localhost user is created with the environment variable MARIADB_MYSQL_LOCALHOST_USER=1 and additional grants (beyond USAGE) with MARIADB_MYSQL_LOCALHOST_GRANTS={global grant list} (MDEV-27732†
• skip innodb buffer pool loads/dumps on temporary startup/shutdown for faster startup/initialization, and accurate “healthcheck.sh –innodb_buffer_pool_loaded”
• change group ownership on datadir/socket dir (issue #401†
• log note about note on Securing system users, mysql_secure_installation not required (reddit suggestion†
• speed up Docker Library initialization of timezones (MDEV-27608† MDEV-23326†
• MariaDB names of executable programs and scripts used instead of historical mysql ones

Security

• Fixes for the following security vulnerabilities†
  • CVE-2022-24052
  • CVE-2022-24051
  • CVE-2022-24050
  • CVE-2022-24048

changelog

For a complete list of changes and bug fixes made in MariaDB 10.6.6with links to detailed information on each push, see the changelog†