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 versies 10.3.9 en 10.2.17 uitgebracht. De eerste stable uit de 10.3.x-tak stamt uit mei 2018 en heeft voor vijf jaar ondersteuning meegekregen, terwijl de eerste stable uit de 10.2.x-tak uit mei 2017 stamt en tevens voor vijf jaar ondersteuning heeft meegekregen. De beknopte aankondigingen van deze uitgaves zien er als volgt uit:
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:MariaDB 10.2.17 Release Notes
- 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
- Galera: 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 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
- Galera: 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
:strip_exif()/i/2003683020.png?f=thumbmedium)