Software Update: MariaDB 10.3.9 / 10.2.17

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. MariaDB is a powerful open source database server, which is especially popular as a website and forum database. The developers have released versions 10.3.9 and 10.2.17. The first stable from the 10.3.x branch dates from May 2018 and has received support for five years, while the first stable from the 10.2.x branch dates from May 2017 and has also received support for five years. The abbreviated announcements of these releases are as follows:

MariaDB 10.3.9 Release Notes

MariaDB 10.3 is an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL. MariaDB 10.3.9 is a Stable (GA) release.

Notable changes of this release include:

• New variable innodb_log_optimize_ddl for avoiding delay due to page flushing and allowing concurrent backup.
• InnoDB updated to 5.7.23
• ALTER TABLE fixes:
  • MDEV-14637 – Fix hang due to DDL with FOREIGN KEY or persistent statistics
  • MDEV-15953 – Alter InnoDB Partitioned Table Moves Files (which were originally not in the datadir) to the datadir
  • MDEV-16515 – InnoDB: Failing assertion: ++retries < 10000 in file dict0dict.cc line 2737
  • MDEV-16809 – Allow full redo logging for ALTER TABLE
  • MDEV-16131 – Assertion `is_instant() || id == DICT_INDEXES_ID’ failed in dict_index_t::instant_field_value
  • MDEV-16830 – ALTER TABLE DROP FOREIGN KEY – unexpected end of stream error
• Temporary tables: MDEV-16713 – InnoDB hang with repeating log entry
• MDEV-16596 – Windows – redo log does not work on native 4K sector disks
• indexed virtual columns: MDEV-15855 – Deadlock between purge thread and DDL statement
• locking: MDEV-16664 – Change the default to innodb_lock_schedule_algorithm=fcfs
• Gallery: MDEV-15822 – WSREP: BF lock wait long for trx
• MDEV-16675 – Unnecessary explicit lock acquisition during UPDATE or DELETE
• Packages and a repository for openSUSE 15 have been added with this release, visit the Repository Configuration Tool for instructions on adding the repository
• Fixes for the following security vulnerabilities:
  • CVE-2018-3060
  • CVE-2018-3064
  • CVE-2018-3063
  • CVE-2018-3058
  • CVE-2018-3066

MariaDB 10.2.17 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.17 is a Stable (GA) release.

Notable changes of this release include:

• New variable innodb_log_optimize_ddl for avoiding delay due to page flushing and allowing concurrent backup
• InnoDB updated to 5.7.23
• ALTER TABLE fixes:
  • MDEV-14637 – Fix hang due to DDL with FOREIGN KEY or persistent statistics
  • MDEV-15953 – Alter InnoDB Partitioned Table Moves Files (which were originally not in the datadir) to the datadir
  • MDEV-16515 – InnoDB: Failing assertion: ++retries < 10000 in file dict0dict.cc line 2737
  • MDEV-16809 – Allow full redo logging for ALTER TABLE
• Temporary tables: MDEV-16713 – InnoDB hang with repeating log entry
• MDEV-16596 – Windows – redo log does not work on native 4K sector disks
• indexed virtual columns: MDEV-15855 – Deadlock between purge thread and DDL statement
• locking: MDEV-16664 – Change the default to innodb_lock_schedule_algorithm=fcfs
• Gallery: MDEV-15822 – WSREP: BF lock wait long for trx
• Packages and a repository for openSUSE 15 have been added with this release, visit the Repository Configuration Tool for instructions on adding the repository
• Fixes for the following security vulnerabilities:
  • CVE-2018-3060
  • CVE-2018-3064
  • CVE-2018-3063
  • CVE-2018-3058
  • CVE-2018-3066