MariaDB is a community-developed, commercially supported fork of the MySQL Relational Database Management System (RDBMS), intended to remain free and open-source software under the GNU General Public License. Development is led by some of the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle Corporation in 2009.
MariaDB intended to maintain high compatibility with MySQL, ensuring a drop-in replacement capability with library binary parity and exact matching with MySQL APIs and commands. However, new features diverge more. It includes new storage engines like Aria, ColumnStore, and MyRocks.
In December 2012 Michael Widenius, David Axmark, and Allan Larsson announced the formation of a foundation that would oversee the development of MariaDB.
Simon Phipps quit in 2014 on the sale of the MariaDB trademark to SkySQL. He later said: “I quit as soon as it was obvious the company was not going to allow an independent foundation.” On 1 October 2014, SkySQL Corporation AB changed its name to MariaDB Corporation AB to reflect its role as the main driving force behind the development of MariaDB Server and the biggest support-provider for it. MariaDB is a registered trademark of MariaDB Corporation AB, used under license by the MariaDB Foundation.
From January 2015 to September 2018, Otto Kekalainen was the CEO of the MariaDB Foundation. He stepped down effectively on 1 October of that year. Arjen Lentz was appointed CEO of the Foundation in October 2018 but resigned in December 2018. Kaj Arno joined as the CEO on 1 February 2019. Eric Herman is the current Chairman of the Board.
MariaDB Server is one of the most popular database servers in the world. It’s made by the original developers of MySQL and guaranteed to stay open source. Notable users include Wikipedia, WordPress.com, and Google.
It turns data into structured information in a wide array of applications, ranging from banking to websites. It is an enhanced, drop-in replacement for MySQL. MariaDB is used because it is fast, scalable and robust, with a rich ecosystem of storage engines, plugins, and many other tools that make it very versatile for a wide variety of use cases.
The app is developed as open-source software and as a relational database, it provides an SQL interface for accessing data. The latest versions of MariaDB also include GIS and JSON features.
MariaDB Database Software Features
MariaDB provides the same features of MySQL with some extensions. It is relatively new and advances.
Following is a list of features of MariaDB:
- MariaDB is licensed under GPL, LGPL, or BSD.
- MariaDB includes a wide selection of storage engines, including high-performance storage engines, for working with other RDBMS data sources.
- MariaDB uses a standard and popular querying language.
- MariaDB runs on a number of operating systems and supports a wide variety of programming languages.
- MariaDB offers support for PHP, one of the most popular web development languages.
- MariaDB offers Galera cluster technology.
- MariaDB also offers many operations and commands unavailable in MySQL and eliminates/replaces features impacting performance negatively.
MariaDB Server began its life as a fork of MySQL, inheriting the strong performance and the legacy Relational DBMS capabilities that made the ecosystem so popular in the first place. In the years since this fork, differences have begun to emerge between these platforms, as It has advanced as a leader in its own right.
These differences translate into advantages, many of which are specific to users, including enhancements to the optimizer, window functions, system and application-time period versioned tables, replication and clustering support, and support for new storage engines like ColumnStore, MyRocks, Spider, and Aria.
In the interest of providing a superior product, the Server utilizes its own testing suite for evaluating new features and patches. This suite includes many more tests and bugs found in these tests are fixed before the code ships. Furthermore, the tests are run against several configurations of Maria DB Server 64 bit, to better test the feature in different environments, and are not run when the feature is not available in the given configuration.
It includes a number of new features and extensions. When the community submits patches or features that are found to be useful, safe, and stable, every effort is made to integrate them with and include in the program.
The list of clients compatible with includes Database Workbench, DBEdit, HeidiSQL, Navicat, phpMyAdmin, and SQLyog. As far as web applications are concerned, official support is provided by Drupal, ERP5, Kajona, MediaWiki, and Moodle.
The developers have their own security patches, in addition to those supplied by MySQL. Critical security issues are rapidly identified, resolved and distributed with new versions of the database server. Details about them are usually made available to the public after the latest editions of MariaDB and MySQL are published. Download MariaDB On Linux Os.
Comparison of MariaDB And MySQL Database Software
|Description||MySQL application compatible open-source RDBMS, enhanced with high availability, security, interoperability and performance capabilities. With MariaDB ColumnStore a column-oriented storage engine is available too.||Widely used opensource RDBMS|
|Primary Database Model||Relational DBMS||Relational DBMS|
|Secondary database models||Document store
|DBaaS offerings (sponsored links)||
|Implementation of Languages||C and C++||C and C++|
|Server operating systems||FreeBSD, Linux, Solaris, Windows||FreeBSD, Linux, OS X, Solaris, Windows|
|APIs and other access methods||Proprietary native API, ADO.NET, JDBC, ODBC||Proprietary native API, ADO.NET, JDBC, ODBC|
|Server Side Script||Yes||Yes|
|Partitioning methods||Horizontal partitioning, sharding with Spider storage engine or Galera cluster||Horizontal partitioning, sharding with MySQL Cluster or MySQL Fabric|
|Replication Method||Master-master replication||Master-master replication|
|Consistency concepts||Immediate Consistency||Immediate Consistency|
|User concepts||fine-grained access rights according to SQL-standard||Users with fine-grained authorization concept|
|Processor||Intel Core Processor|
|RAM||512 MB RAM|
|Operating System||Windows 7, Windows 8, Windows 10, Linux OS|
|Software Name||MariaDB Database Software V 10.4.7|
|File Size||Windows: 53.3 MB Linux: 308 MB|