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.
Thanks, and enjoy MariaDB!
- 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-triggeroption 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.
- 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 Mariabackup 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.
Be notified of new MariaDB Server, Galera Cluster and Connector releases automatically by subscribing to the MariaDB Foundation community announce 'at' mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB Corporation customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB Corporation products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.