MariaDB 10.2.6 Release Notes

The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

DownloadRelease NotesChangelogOverview of 10.2

Release date: 23 May 2017

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.

For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.

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

• MDEV-11117: Auto_increment columns are no longer permitted in CHECK constraints, DEFAULT value expressions and virtual columns. They were permitted in earlier versions, but did not work correctly.

• Fixes for the following security vulnerabilities:

  • CVE-2017-3308

  • CVE-2017-3309

  • CVE-2017-3453

  • CVE-2017-3456

  • CVE-2017-3464

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. A beta version of mariadb-backup was included in MariaDB 10.2.7 and declared stable in MariaDB 10.2.10.

A file format compatibility bug that was introduced in MariaDB 10.2.2 was present in this release. Creating tables with the attribute page_compressed=yes created InnoDB internal data dictionary records that are incompatible with MariaDB 10.1. MariaDB 10.2.7 and later will write the dictionary records in a format that is compatible with MariaDB 10.1 and will also support the malformed metadata from affected 10.2 versions.This bug may prevent a downgrade from later MariaDB 10.2 versions to MariaDB 10.2.6.See the commit for details.

Changelog

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

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on theDistributions which Include MariaDB page.