Software-update: MariaDB 10.2.19

MariaDB is ontstaan als fork van MySQL, nadat dit in 2009-2010 door Oracle werd overgenomen. Voor een overzicht van de verschillen tussen MariaDB en MySQL kun je op deze en deze pagina's terecht. MariaDB is een krachtige opensourcedatabaseserver, die vooral populair is als website- en forumdatabase. De ontwikkelaars hebben versie 10.2.19 uitgebracht. De eerste stable uit de 10.2.x-tak stamt uit mei 2017 en heeft voor vijf jaar ondersteuning meegekregen. De beknopte aankondiging van deze uitgave ziet er als volgt uit:

MariaDB 10.2.19 Release Notes

MariaDB 10.2 is the previous 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.19 will be a Stable (GA) release. Thanks, and enjoy MariaDB!

Notable Changes

• innodb_safe_truncate system variable for a backup-safe TRUNCATE TABLE implementation that is based on RENAME, CREATE, DROP (MDEV-14717, MDEV-14585, MDEV-13564)
  • Default value for this variable is ON
  • If you absolutely must use XtraBackup instead of Mariabackup, you can set it to OFF and restart the server
• MDEV-17289: Multi-pass recovery fails to apply some redo log records
• MDEV-17073: INSERT…ON DUPLICATE KEY UPDATE became more deadlock-prone
• MDEV-17491: micro optimize page_id_t
• MDEV-13671: InnoDB should use case-insensitive column name comparisons like the rest of the server
• Fixes for indexed virtual columns: MDEV-17215, MDEV-16980
• MDEV-17433: Allow InnoDB start up with empty ib_logfile0 from mariabackup --prepare
• MDEV-12547: InnoDB FULLTEXT index has too strict innodb_ft_result_cache_limit max limit
• MDEV-17541: KILL QUERY during lock wait in FOREIGN KEY check causes hang
• MDEV-17531: Crash in RENAME TABLE with FOREIGN KEY and FULLTEXT INDEX
• MDEV-17532: Performance_schema reports wrong directory for the temporary files of ALTER TABLE…ALGORITHM=INPLACE
• MDEV-17545: Predicate lock for SPATIAL INDEX should lock non-matching record
• MDEV-17546: SPATIAL INDEX should not be allowed for FOREIGN KEY
• MDEV-17548: Incorrect access to off-page column for indexed virtual column
• MDEV-12023: Assertion failure sym_node->table != NULL on startup
• MDEV-17230: encryption_key_id from alter is ignored by encryption threads
• As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Fedora 27
• Fixes for the following security vulnerabilities:
  • CVE-2018-3282
  • CVE-2016-9843
  • CVE-2018-3174
  • CVE-2018-3143
  • CVE-2018-3156
  • CVE-2018-3251
  • CVE-2018-3185
  • CVE-2018-3277
  • CVE-2018-3162
  • CVE-2018-3173
  • CVE-2018-3200
  • CVE-2018-3284

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

Versienummer	10.2.19
Releasestatus	Final
Besturingssystemen	Windows 7, Linux, BSD, macOS, Solaris, UNIX, Windows Server 2008, Windows Server 2012, Windows 8, Windows 10, Windows Server 2016
Website	MariaDB
Download	https://downloads.mariadb.org/mariadb/10.2.19/
Licentietype	Voorwaarden (GNU/BSD/etc.)