MariaDB

MariaDB is a an open source and cross-platform database engine and server, designed as a drop-in replacement for the well known and powerful MySQL database engine used on numerous web servers around the world. The application is geared toward database professionals that are in search of a scalable, robust, reliable and stable SQL server, a replacement for the MySQL database server.

Supports a wide range of storage engines

By default, it provides users with support for several storage engines, including Aria, XtraDB (drop-in replacement for InnoDB), PBXT, FederatedX (drop-in replacement for Federated), OQGRAPH, SphinxSE, IBMDB2I, and Cassandra.

Compared with MySQL

When compared with MySQL, we can immediately notice that MariaDB is definitely much faster, and extendable through a great number of extensions. It comes with brand-new features, developed by the best and brightest developers in the industry.

Features at a glance

Among some of its major highlights, we can mention multi-source, fast and safe replication, InnoDB asynchronous I/O subsystem, support for over 200,000 database connections, extended user statistics, pluggable authentication, as well as faster subqueries and joins. In addition, it comes with support for dynamic columns, GIS (Geographic Information System) functionality, progress reporting, virtual columns, table elimination, HandlerSocket, as well as fewer bugs and warnings.

Compatible with MySQL databases

Another interesting feature is the full compatibility with the MySQL database server, allowing users to import database tables from MySQL to MariaDB without much hassle. Also, users will be able to easily create logical or physical backups of their databases.

Supported operating systems

MariaDB is a platform-independent application, supporting all major operating system like Linux, Mac OS X, Solaris and Microsoft Windows. In addition to the source code, the software provides binary packages for both 64-bit and 32-bit architectures.

A drop-in replacement for MySQL

Because many Linux distribution developers replaced all the MySQL packages with MariaDB in their operating systems, we feel obliged to strongly recommend this powerful and open source SQL database engine/server for your projects.

What is new in this release:

• MDEV-12837 - WSREP: BF lock wait long
• MDEV-14799 - After UPDATE of indexed columns, old values will not be purged from secondary indexes
• MDEV-12827 - Assertion failure when reporting duplicate key error in online table rebuild
• MDEV-14008 - Failure reading auto-increment values in DOUBLE column from storage engine
• MDEV-12323 - Rollback progress log messages during crash recovery are intermixed with unrelated log messages
• MDEV-12352 - InnoDB shutdown should not be blocked by a large transaction rollback
• MDEV-13797 - InnoDB may hang if shutdown is initiated soon after startup while rolling back recovered incomplete transactions
• MDEV-14422 - Assertion failure in trx_purge_run() on shutdown
• MDEV-14589 - InnoDB should not lock a delete-marked record
• MDEV-14714 / MDEV-14488 / MDEV-14644 - data corruption caused by error log messages ending up in database files or binary logs
• MDEV-14511 - Use fewer transactions for updating InnoDB persistent statistics
• MDEV-13670 / MDEV-14550 - Error log flood : "InnoDB: page_cleaner: 1000ms intended loop took N ms. The settings might not be optimal."
• mariabackup: MDEV-14536 - during backup, retry read of log blocks, if there is (possibly intermittent) checksum mismatch
• As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Ubuntu 17.04 "Zesty".
• The reserved word WINDOW is now only disallowed for table aliases.

What is new in version 10.2.11:

• InnoDB:
• MDEV-13206 INSERT ON DUPLICATE KEY UPDATE foreign key fail
• Support CRC32 SSE2 implementation under Windows
• MDEV-13795/MDEV-14332 Corruption during online table-rebuilding ALTER when VIRTUAL columns exist
• MDEV-13328 ALTER TABLE...DISCARD TABLESPACE takes a lot of time
• MDEV-14140 IMPORT TABLESPACE must not go beyond FSP_FREE_LIMIT
• MDEV-14244 MariaDB 10.2.10 fails to run on Debian Stretch with ext3 and O_DIRECT
• MDEV-14219 Allow online table rebuild when encryption or compression parameters change
• MariaDB Backup:
• MDEV-14499 Mariabackup 10.2 fails to back up a multi-file InnoDB system tablespace
• MDEV-14447 mariabackup incremental incorrectly extends system tablespace for multi-file innodb_data_file_path
• MDEV-13560 Copy all innodb undo tablespaces from the backup directory to destination
• Other:
• Mroonga updated to 7.07.
• As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for RHEL 7.2 and CentOS 7.2. Starting with the next 10.2 release we will be building MariaDB for CentOS 7 and RHEL 7 on version 7.3.
• Repositories for Ubuntu 17.10 Artful added

What is new in version 10.2.10:

• InnoDB updated to 5.7.20
• CONNECT updated to 1.6.0005
• MariaDB Backup now Stable (GA)
• MDEV-14051: 'Undo log record is too big.' error occurring in very narrow range of string lengths
• MDEV-13918: Race condition between INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS and ALTER/DROP/TRUNCATE TABLE
• MDEV-13838: Wrong result after altering a partitioned table
• fixed bugs in InnoDB FULLTEXT INDEX
• MDEV-12676: InnoDB FTS duplicate key error
• MDEV-13051: InnoDB crash after failed ADD INDEX and table_definition_cache eviction
• MDEV-13446: fts_create_doc_id() unnecessarily allocates 8 bytes for every inserted row
• MDEV-13941 Fix high NTFS fragmentation
• MDEV-13512 Fix corruption of SPATIAL INDEX in ROW_FORMAT=COMPRESSED tables
• MDEV-14023 10.1 InnoDB tables with virtual columns cannot be accessed in 10.2
• MDEV-11336 innodb_defragment was enabled
• Fixes for the following security vulnerabilities:
• CVE-2017-10378, MDEV-13819
• CVE-2017-10268
• CVE-2017-15365

What is new in version 10.2.7:

• TokuDB updated to 5.6.36-82.0
• MariaDB Backup beta now included for Red Hat, CentOS, and Fedora packages
• MDEV-13125: Core dumps can now be enabled dynamically
• New variables:
• tmp_disk_table_size
• tmp_memory_table_size
• As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Ubuntu 16.10 "Yakkety"

What is new in version 10.2.6:

• 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-trigger option 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

What is new in version 10.1.9:

• CONNECT engine updated to version 1.04.0003
• The SHOW SLAVE STATUS field, seconds_behind_master, is now, with parallel replication, only updated after transactions commit.
• Includes all bug fixes from MariaDB 5.5.46, MariaDB 10.0.22, and MariaDB Galera Cluster 10.0.22 releases

What is new in version 10.0.21 / 10.1.6 Beta:

• XtraDB updated to XtraDB-5.6.25-73.1
• Innodb updated to InnoDB-5.6.26
• Performance Schema updated to 5.6.26
• Connect engine has now Gamma maturity (was: Beta)

What is new in version 10.0.20 / 10.1.3 Beta:

• XtraDB updated to XtraDB-5.6.24-72.2
• Innodb updated to InnoDB-5.6.25
• Performance Schema updated to 5.6.25
• TokuDB updated to TokuDB-7.5.7
• Client command line option --ssl-verify-server-cert (and MYSQL_OPT_SSL_VERIFY_SERVER_CERT option of the client API) when used together with --ssl will ensure that the established connection is SSL-encrypted and the MariaDB server has a valid certificate. This fixes CVE-2015-3152.

What is new in version 10.0.19 / 10.1.3 Beta:

• Fixed the server crash caused by mysql_upgrade (MDEV-8115)

What is new in version 10.0.16:

• The innodb_stats_traditional system variable enables a larger sample of pages for larger tables for the purposes of index statistics calculation.
• InnoDB upgraded to 5.6.22
• XtraDB upgraded to 5.6.22-71.0
• TokuDB upgraded to 7.5.4
• Updates to the CONNECT handler (supporting the JSON table type)
• Fixes for the following security vulnerabilities:
• CVE-2015-0411
• CVE-2015-0382
• CVE-2015-0381
• CVE-2015-0432
• CVE-2014-6568
• CVE-2015-0374

What is new in version 10.0.15:

• This release fixes a serious bug in InnoDB and XtraDB that sometimes could cause a hard lock up of the server (MDEV-7026).
• This is the first release that includes Mroonga full-text search storage engine.
• 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.
• Fixes for the following security vulnerabilities:
• CVE-2014-6507
• CVE-2014-6491
• CVE-2014-6500
• CVE-2014-6469
• CVE-2014-6555
• CVE-2014-6559
• CVE-2014-6494
• CVE-2014-6496
• CVE-2014-6464
• Bundled PCRE is upgraded to 8.36
• InnoDB upgraded to 5.6.21
• XtraDB upgraded to 5.6.21-70.0
• TokuDB upgraded to 7.5.3
• SphinxSE upgraded to 2.2.6
• Updates to the CONNECT handler including:
• A new VIR virtual table type.
• New variables connect_use_tempfile and connect_exact_info
• We now offer openSUSE repos, see the repository configuration tool for details on how to use it.

What is new in version 10.0.14:

• TokuDB upgraded to 7.5.0
• XtraDB upgraded to 5.6.20-68.0
• InnoDB upgraded to 5.6.20
• Spider upgraded to 3.2.11
• SphinxSE upgraded to 2.1.9
• The Feedback plugin now includes statistics on collation usage.
• Error log has a flood protection that is activated after 10 identical unsafe warnings and disables them for the next 5 minutes.
• Many fixes and optimizations for the Power8 platform.
• 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".
• 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.

What is new in version 10.0.13:

• filesort-with-small-limit-optimization is now visible through the slow query log and a new status variable, sort_priority_queue_sorts.
• 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.
• Connect engine supports partitioning.
• Many plugins have had their maturity level increased (from beta to gamma or from gamma to stable).
• TokuDB upgraded to 7.1.7
• XtraDB upgraded to 5.6.19-67.0
• InnoDB upgraded to 5.6.19
• Performance_Schema upgraded to 5.6.20

What is new in version 10.0.12:

• Updated Spider storage engine to version 3.2.4
• Updated Connect engine.
• Updated pcre to version 8.35
• Exists2In optimization is now enabled by default
• performance_schema is now disabled by default

What is new in version 10.0.11:

• Updated TokuDB engine to version 7.1.6
• Updated Spider storage engine to version 3.2
• Updated XtraDB storage engine to version 5.6.17-65.0
• Updated InnoDB storage engine to version 5.6.17
• Updated performance_schema to version 5.6.17
• Updated Connect, and OQGraph engines.
• Online ALTER TABLE works for partitioned tables
• 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';

What is new in version 10.0.10:

• Replication:
• MariaDB 10 sets a new standard in performance. It is many times faster than previous generations of MariaDB and especially legacy database MySQL thanks to new features including parallel replication and a further advanced group commit. Also, the replication slaves are now crash-safe.
• It's also now possible to replicate data from multiple master servers giving a complete view of the distributed data across big datasets for real-time analytical purposes via the multi-source replication feature.
• NoSQL Capabilities:
• The CONNECT engine enables dynamic access to diverse data sources dynamically, including unstructured files such as log files in a folder, or any ODBC database, from within MariaDB 10. Great for ETL (Extraction, Transformation and Load) and Real-Time analysis.
• Dynamic Columns store disparate labelled data objects in each row of a table in much the same way as NoSQL technologies.
• Access data from Cassandra data directly inside MariaDB 10, and interoperate directly with a widely adopted Big Data technology.
• Sharding:
• MariaDB 10 includes built-in sharding in the form of the SPIDER engine, allowing big database tables to be split across multiple servers, for performance and scale. MariaDB combines sharding with the new replication features to provide true high availability.

What is new in version 5.5.35:

• MySQL 5.5.35
• XtraDB from Percona-Server-5.5.35-rel33.0
• OLD_MODE, to emulate behavior from old MySQL/MariaDB versions.

What is new in version 10.0.6 Beta:

• MDEV-5248 Serious incompatibility and data corruption of DATETIME and DATE types due to get_innobase_type_from_mysql_type refactor combined with InnoDB Online DDL
• MDEV-5275 Problems upgrading from MySQL 5.1 to MariaDB
• Add missing plugins to deb packages
• Various Parallel Replication fixes: MDEV-4506, MDEV-5217.

What is new in version 5.5.34:

• MySQL 5.5.34
• XtraDB from Percona-Server-5.5.34-rel32.0
• TokuDB 7.1.0

What is new in version 10.0.5 Beta:

• Replication enhancements
• Storage engines
• Optimizer enhancements
• Administration improvements
• Other important new features
• Merged features and functionality from MySQL 5.6

What is new in version 10.0.4 Alpha:

• Newly Implemented Features:
• MDEV-4438 - Spider storage engine
• MDEV-4568 - Port Percona response time distribution as audit plugin
• MDEV-4702 - Reduce usage of LOCK_open
• Features and Fixes Merged or Backported from MySQL 5.6.10:
• MDEV-330 - Support for MySQL-5.6 created tables (frm and data files) that have columns of types TIME(N), DATETIME(N) and TIMESTAMP(N). Previously, an attempt to open such a table in MariaDB would return an error.
• MDEV-3838 - Support for standard SQL temporal literals
• MDEV-4058 - Merge the host_cache P_S table
• WL #5185 Remove deprecated 5.1 features
• InnoDB from MySQL 5.6.10
• Performance schema updates, including new defaults.
• Information Schema updates, including new defaults.
• InnoDB persistent statistics.
• Online ALTER for InnoDB and thread information for in-place operations
• EXCHANGE PARTITION
• Partition selection
• For temporary tables created with the CREATE TEMPORARY TABLE statement, the privilege model has changed (MySQL Bug #27480, Bug #11746602)
• GET DIAGNOSTICS statement

What is new in version 5.5.33:

• This release includes MariaDB 5.3.12 and MySQL 5.5.32.

What is new in version 5.5.32:

• This release is primarily a bug-fix release. It includes MariaDB 5.3.12 and MySQL 5.5.32.