Software update: MariaDB 10.6.6

Spread the love

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

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-27068MDEV-27107MDEV-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-27608MDEV-23326
  • MariaDB names of executable programs and scripts used instead of historical mysql ones

Security

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

Version number 10.6.6
Release status Final
Operating systems Windows 7, Linux, BSD, macOS, Solaris, UNIX, Windows Server 2008, Windows Server 2012, Windows 8, Windows 10, Windows Server 2016, Windows Server 2019, Windows 11
Website MariaDB
Download
License type Conditions (GNU/BSD/etc.)
.fb-background-color { background: #ffffff !important; } .fb_iframe_widget_fluid_desktop iframe { width: 100% !important; }
CentOSDebianFedoraGPGMariaDBMySQLSoftwareUbuntuWindowsWindows Server
Share