Software update: MariaDB 10.6.1

MariaDB originated as a fork of MySQL, after it was taken over by Oracle in 2009-2010. For an overview of the differences between MariaDB and MySQL you can go to this one and this one pages rightly so. MariaDB is a powerful open source database server, which is especially popular as a website and forum database. The developers released version 10.6.1 as a beta. The main changes of this release are as follows:

MariaDB 10.6.1 Release Notes

MariaDB 10.6 is the current development series of MariaDB. It is an evolution of MariaDB 10.5 with several entirely new features. MariaDB 10.6.1 is a Beta release. Thanks, and enjoy MariaDB!

Notable Changes

Atomic DDL

  • CREATE TABLE, ALTER TABLE, RENAME TABLE, DROP TABLE, DROP DATABASE and related DDL statements are now atomic. Either the statement is fully completed, or everything is reverted to it’s original state. Note that when deleting multiple tables with DROP TABLE, only each individual drop is atomic, not the full list of tables). (MDEV-23842).

Replication, Galera and Binlog

  • The delay between binary log purges can now be specified with much greater precision. The system variable binlog_expire_logs_seconds is introduced as a form of alias for expire_logs_days, which now accepts a precision of 1/1000000 days (MDEV-19371)
  • Allow transition from unencrypted to TLS Galera cluster communication without cluster downtime (MDEV-22131)
  • DDL information logged on all Galera cluster nodes if wsrep_debug is set to SERVER and wsrep_OSU_method is ‘TOI’ (MDEV-9609)

Oracle Compatibility

  • ADD_MONTHS () added (MDEV-20025)
  • TO_CHAR () added (MDEV-20017)
  • SYS_GUID () added (MDEV-24285)
  • MINUS is mapped to EXCEPT in UNION (MDEV-20021)
  • ROWNUM function returns the current number of accepted rows in the current context (MDEV-24089)

Character Sets

  • The utf8 character set (and related collations) is now by default an alias for utf8mb3 rather than the other way around. It can be set to imply utf8mb4 by changing the value of the old_mode system variable (MDEV-8334)

For a complete list of changes made in MariaDB 10.6.1, with links to detailed information on each push, see the changelog.

Version number 10.6.1
Release status Beta
Operating systems Windows 7, Linux, BSD, macOS, Solaris, UNIX, Windows Server 2012, Windows 8, Windows 10, Windows Server 2016, Windows Server 2019
Website MariaDB
License type Conditions (GNU / BSD / etc.)