MariaDB 10.0.17 Overview and Highlights

MariaDB 10.0.17 was recently released, and is available for download here:

https://downloads.mariadb.org/mariadb/10.0.17/

This is the eighth GA release of MariaDB 10.0, and 18th overall release of MariaDB 10.0.

For the most part, there are not a whole lot of new changes to report for this release, but there is a new version of the Audit Plugin and many other engines have been updated as well.

Here are the main items of note:

  1. The new version of the Audit Plugin is 1.2 is included with the following new features:
    • In the audit log passwords are now masked, i.e. the password characters are replaced with asterisks.
    • It’s now possible to filter logging to include only DDL (CREATE, ALTER, etc.) or DML (INSERT, UPDATE, etc.) statements.
    • For more information please refer to the About the MariaDB Audit Plugin page. The plugin is disabled by default.
  2. InnoDB upgraded to 5.6.23
  3. XtraDB upgraded to 5.6.22-72.0
  4. TokuDB upgraded to 7.5.5
  5. mroonga upgraded to 5.0
  6. Spider upgraded to 3.2.18
  7. Connect upgraded to 1.03.0005
  8. HeidiSQL upgraded to 9.1
  9. –galera-sst-mode option removed from mysqldump (MDEV-7615)
  10. mysqlbinlog –binlog-row-event-max-size support added (MDEV-6703)

Overall, there are no critical nor security related bugs fixes, so that is great. As for upgrading, if you’re using any of the above storage engines or the audit plugin, it would be a good idea to consider upgrading (at least review the fixes applicable to you to determine if they will be worth it or not).

You can read more about the 10.0.17 release here:

https://mariadb.com/kb/en/mariadb-10017-release-notes/

And if interested, you can review the full list of changes in 10.0.17 (changelogs) here:

https://mariadb.com/kb/en/mariadb-10017-changelog/

Hope this helps.

 

MariaDB 10.0.16 Overview and Highlights

MariaDB 10.0.16 was recently released (~1.5 months ago on 1/27/2015 – sorry for the delay on my end – I was just extra busy in my spare time recently), and is available for download here:

https://downloads.mariadb.org/mariadb/10.0.16/

This is the seventh GA release of MariaDB 10.0, and 17th overall release of MariaDB 10.0.

For the most part, there are not a whole lot of changes to report for this release, but there are 2 enhancements of note – one being the JSON table type (still *experimental*) and the other a new variable to aid with index statistics calculations on large tables, as well as some security fixes.

Here are the main items of note:

  1. Updates to the CONNECT handler (supporting the JSON table type) – which is *experimental* currently
  2. The innodb_stats_traditional system variable enables a larger sample of pages for larger tables for the purposes of index statistics calculation.
  3. InnoDB upgraded to 5.6.22
  4. XtraDB upgraded to 5.6.22-71.0
  5. TokuDB upgraded to 7.5.4
  6. Fixes for the following security vulnerabilities:

Given the security fixes, you should plan on upgrading if you’re running a prior version of 10.0.

You can read more about the 10.0.16 release here:

https://mariadb.com/kb/en/mariadb-10016-release-notes/

And if interested, you can review the full list of changes in 10.0.16 (changelogs) here:

https://mariadb.com/kb/en/mariadb-10016-changelog/

Hope this helps.

 

MariaDB 10.0.15 Overview and Highlights

MariaDB 10.0.15 was recently released, and is available for download here:

https://downloads.mariadb.org/mariadb/10.0.15/

This is the sixth GA release of MariaDB 10.0, and 16th overall release of MariaDB 10.0.

This release has an important InnoDB/XtraDB fix, a new addition, security enhancements (and improvement) – all related to yaSSL, so be sure to check out these fixes if you’re running MariaDB 10.0, and not up to 10.0.15 yet. (MariaDB 10.0 is the current stable series of MariaDB. It is an evolution of the MariaDB 5.5 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6.)

Here are the main items of note:

  1. This release fixes a serious bug in InnoDB and XtraDB that sometimes could cause a hard lock up of the server (MDEV-7026)
  2. This is the first release that includes Mroonga full-text search storage engine.
  3. When compiled with OpenSSL, MariaDB now supports TLSv1.2 protocol. Limit it to TLSv1.2 ciphers only with –ssl_cipher=TLSv1.2. Limit it to SSLv3 ciphers with –ssl-cipher=SSLv3. RPM and DEB packages from MariaDB.org are built with OpenSSL, others (for Windows and generic Linux) are built with yaSSL.
  4. Fixes for the following security vulnerabilities:
  5. Bundled PCRE is upgraded to 8.36
  6. InnoDB upgraded to 5.6.21
  7. XtraDB upgraded to 5.6.21-70.0
  8. TokuDB upgraded to 7.5.3
  9. SphinxSE upgraded to 2.2.6
  10. Updates to the CONNECT handler including:
  11. We now offer openSUSE repos, see the repository configuration tool for details on how to use it.

Given the severe InnoDB/XtraDB bug, if you’re running a prior MariaDB 10.0 version, I’d recommend upgrading (assuming you’re using InnoDB). Likewise, if you’re using SSL. And then there were a number of fixes to other fixes for TokuDB, CONNECT, and Sphinx, so if you’re using those technologies, you may want to consider upgrading as well.

You can read more about the 10.0.15 release here:

https://mariadb.com/kb/en/mariadb-10015-release-notes/

And if interested, you can review the full list of changes in 10.0.15 (changelogs) here:

https://mariadb.com/kb/en/mariadb-10015-changelog/

Hope this helps.

 

MariaDB 10.0.14 Overview and Highlights

MariaDB 10.0.14 was recently released, and is available for download here:

https://downloads.mariadb.org/mariadb/10.0.14/

This is the fifth GA release of MariaDB 10.0, and 15th overall release of MariaDB 10.0.

This is primarily a bug-fix release. (MariaDB 10.0 is the current stable series of MariaDB. It is an evolution of the MariaDB 5.5 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6.)

Here are the main items of note:

  1. TokuDB upgraded to 7.5.0
  2. XtraDB upgraded to 5.6.20-68.0
  3. InnoDB upgraded to 5.6.20
  4. Spider upgraded to 3.2.11
  5. SphinxSE upgraded to 2.1.9
  6. The Feedback plugin now includes statistics on collation usage.
  7. Error log has a flood protection that is activated after 10 identical unsafe warnings and disables them for the next 5 minutes.
  8. Many fixes and optimizations for the Power8 platform.
  9. As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.0 for both Ubuntu 13.10 “Saucy” and Mint 16 “Petra”.
  10. With the recent release of CentOS 7 and RHEL 7, we are pleased to now provide packages for both distributions. Instructions for how to enable the repositories can be found by visiting the “Installing MariaDB with YUM” page and the repository configuration tool.
  11. Crash in GROUP_CONCAT(IF () ORDER BY 1) (MDEV-6743)
  12. Server crashes in my_hash_first if shutdown is performed when FLUSH LOGS is running (MDEV-6616)
  13. Slave replicating using GTID doesn’t recover correctly when master crashes in the middle of transaction (MDEV-6462)
  14. MariaDB crash on Power8 when built with advance tool chain (MDEV-6450)

As always, it’s great to see all of the fixes alone from TokuDB, XtraDB, InnoDB, Spider, and Sphinx (and thus if you’re relying on any of these technologies, I would consider upgrading). The Power8 enhancements are very nice to see also! (If you’re running Power8 and looking for performance improvements, then you should definitely look into upgrading.) The crash fixes are mostly obscure, but double-check them, just in case they might affect you currently, and if so, then plan to upgrade.

You can read more about the 10.0.14 release here:

https://mariadb.com/kb/en/mariadb-10014-release-notes/

And if interested, you can review the full list of changes in 10.0.14 (changelogs) here:

https://mariadb.com/kb/en/mariadb-10014-changelog/

Hope this helps.

 

MariaDB 10.0.13 Overview and Highlights

MariaDB 10.0.13 was recently released, and is available for download here:

https://downloads.mariadb.org/mariadb/10.0.13/

This is the fourth GA release of MariaDB 10.0, and 14th overall release of MariaDB 10.0.

This is primarily a bug-fix release.

Here are the main items of note:

  1. InnoDB upgraded to 5.6.19.
  2. XtraDB upgraded to 5.6.19-67.0.
  3. TokuDB upgraded to 7.1.7.
  4. Performance_Schema upgraded to 5.6.20.
  5. Connect engine supports partitioning.
  6. Many plugins have had their maturity level increased (from beta to gamma or from gamma to stable).
  7. filesort-with-small-limit-optimization is now visible through the slow query log and a new status variable, sort_priority_queue_sorts.
  8. New variables aria_pagecache_file_hash_size and key_cache_file_hash_size for determining the number of hash buckets for open and changed files for Aria and MyISAM respectively.

You can read more about the 10.0.13 release here:

https://mariadb.com/kb/en/mariadb-10013-release-notes/

And if interested, you can review the full list of changes in 10.0.13 (changelogs) here:

https://mariadb.com/kb/en/mariadb-10013-changelog/

Hope this helps.

 

MariaDB 10.0.12 Overview and Highlights

MariaDB 10.0.12 was recently released, and is available for download here:

https://downloads.mariadb.org/mariadb/10.0.12/

This is the third GA release of MariaDB 10.0, and 13th overall release of MariaDB 10.0.

This is primarily a bug-fix release.

Here are the main items of note:

  1. Updated Spider storage engine to version 3.2.4.
  2. Updated Connect engine.
  3. Updated pcre to version 8.35.
  4. Exists-to-In optimization is now enabled by default.
  5. performance_schema is now disabled by default.

You can read more about the 10.0.12 release here:

https://mariadb.com/kb/en/mariadb-10012-release-notes/

And if interested, you can review the full list of changes in 10.0.12 (changelogs) here:

https://mariadb.com/kb/en/mariadb-10012-changelog/

Hope this helps.

 

MariaDB 10.0.11 Overview and Highlights

MariaDB 10.0.11 was recently released, and is available for download here:

https://downloads.mariadb.org/mariadb/10.0.11/

This is the second GA release of MariaDB 10.0, and 12th overall release of MariaDB 10.0.

This is primarily a bug-fix release.

Here are the main items of note:

  1. Updated TokuDB engine to version 7.1.6
  2. Updated Spider storage engine to version 3.2 (now Gamma)
  3. Updated XtraDB storage engine to version 5.6.17-65.0
  4. Updated InnoDB storage engine to version 5.6.17
  5. Updated performance_schema to version 5.6.17
  6. Updated Connect, and OQGraph engines.
  7. Online ALTER TABLE works for partitioned tables
  8. New system variable default_regex_flags. To make MariaDB RLIKE operator behave in a non-standard but backward compatible way use
    SET @@default_regex_flags='DOTALL';
  9. As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.0 for both Ubuntu 12.10 “Quantal” and Mint 14 “Nadia”.

You can read more about the 10.0.11 release here:

https://mariadb.com/kb/en/mariadb-10011-release-notes/

And if interested, you can review the full list of changes in 10.0.11 (changelogs) here:

https://mariadb.com/kb/en/mariadb-10011-changelog/

Hope this helps.

 

MariaDB 10.0.10 Overview and Highlights

MariaDB 10.0.10 was recently released, and is available for download here:

https://downloads.mariadb.org/mariadb/10.0.10/

This is the first GA (“Generally Availability“, aka “recommended for production systems”) release of MariaDB 10.0, and 11th overall release of MariaDB 10.0.

Since this is the initial 10.0 GA release, this is primarily a bug-fix and polishing release.

Here are the main items of note:

  1. The Audit Plugin is now included in MariaDB (MDEV-5584)
  2. Improved XtraDB performance by fixing incorrect calculation of flushed pages (MDEV-5949)
  3. Fix for GTID duplicate key multi-master corruption bug (MDEV-5804)
  4. Default TokuDB compression is now TOKUDB_ZLIB (instead of TOKUDB_UNCOMPRESSED)
  5. Various algorithm improvements for engine-independent table statistics (EITS) (MDEV-5901, MDEV-5917, MDEV-5950, MDEV-5962, MDEV-5926)

You can read more about the 10.0.10 release here:

https://mariadb.com/kb/en/mariadb-10010-release-notes/

And if interested, you can review the full list of changes in 10.0.10 (changelogs) here:

https://mariadb.com/kb/en/mariadb-10010-changelog/

Hope this helps.