Software Update: MariaDB 10.2.6 / 10.0.31

MariaDB originated as a fork of MySQL after it was acquired by Oracle in 2009/2010. For an overview of the differences between MariaDB and MySQL you can visit: this one and this one pages right. It is a powerful open source database server that is especially popular as a website and forum database. The developers released versions 10.2.6 and 10.0.31 a few days ago with the following announcements:

MariaDB 10.2.6 Release Notes

MariaDB 10.2 is the current stable series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7. MariaDB 10.2.6 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Changes

This is the first stable release in the MariaDB 10.2 series. As such, please refer to the What is MariaDB 10.2? page for details on all of the new features.

• MyRocks alpha storage engine added (MDEV-9658)
• Window functions have been introduced.
• Recursive Common Table Expressions (MDEV-9864)
• AWS Key Management plugin added for Windows, CentOS, RHEL, and Fedora packages
• Update InnoDB to 5.7.18 (MDEV-11751)
• Galera wsrep library updated to 25.3.20
• Packages for Ubuntu 17.04 “zesty” added
• MDEV-10431: The –add-drop-trigger option has been added to mysqldump
• MDEV-12472: Ignore XtraDB-specific parameters in InnoDB, warning that they are ignored
• MDEV-12253, MDEV-12602: Numerous Encryption fixes
• MDEV-11336: Disabled Defragmentation
• MDEV-10332: Added support for OpenSSL 1.1 and LibreSSL
• innodb_deadlock_detect and innodb_stats_include_delete_marked variables introduced

Notes

• Percona XtraBackup (as of 2.4) will not work with MariaDB 10.2 (and MariaDB 10.1) compression. However, MariaDB’s fork, MariaDB Backup, will work with compression. It will be included in a future version of MariaDB 10.2.

changelog

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

MariaDB 10.0.31 Release Notes

MariaDB 10.0 is a previous stable series of MariaDB. It is an evolution of MariaDB 5.5 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6. This is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable changes

• XtraDB updated to 5.6.36-82.0
• TokuDB updated to 5.6.36-82.0
• Innodb updated to 5.6.36
• Performance Schedule updated to 5.6.36
• As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.0 for Ubuntu 12.04 LTS “Precise” and Mint 13 LTS “Maya”
• MDEV-11520: Extending an InnoDB data file unnecessarily allocates a large memory buffer on Windows
• MDEV-11027: InnoDB log recovery is too noisy
• MDEV-12091: Shutdown fails to wait for rollback of recovered transactions to finish
• MDEV-12534: Use atomic operations whenever available
• MDEV-12674: Innodb_row_lock_current_waits has overflow
• MDEV-12188: information schema – errors populating fail to free memory, unlock mutexes
• MDEV-12358: Fixes for GCC 7
• Miscellaneous compiler warning fixes
• MDEV-6262: Fixes from coverity report on MariaDB

changelog

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