MariaDB
220px | |
Developer(s) | MariaDB Corporation Ab, MariaDB Foundation |
---|---|
Initial release | 22 January 2009 |
Stable release | 10.1.14 (May 10, 2016[1]) [±] |
Written in | C, C++, Perl, Bash |
Operating system | Cross-platform (Unix, Windows, Solaris, Linux, OS X, BSD)[2] |
Available in | English |
Type | RDBMS |
License | GNU General Public License (version 2), GNU Lesser General Public License (for client-libraries)[3] |
Website | mariadb mariadb |
MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. Being a fork of a leading open source software system, it is notable for being led by the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle.[4] Contributors are required to share their copyright with the MariaDB Foundation.[5]
MariaDB intends to maintain high compatibility with MySQL, ensuring a "drop-in" replacement capability with library binary equivalency and exact matching with MySQL APIs and commands.[6] It includes the XtraDB storage engine for replacing InnoDB,[7] as well as a new storage engine, Aria, that intends to be both a transactional and non-transactional engine perhaps even included in future versions of MySQL.[8]
Its lead developer is Michael "Monty" Widenius, one of the founders of MySQL AB and the founder of Monty Program AB. On 16 January 2008, MySQL AB announced that it had agreed to be acquired by Sun Microsystems for approximately $1 billion. The acquisition completed on 26 February 2008. MariaDB is named after Monty's younger daughter Maria, similar to how MySQL is named after his other daughter My.[9]
Contents
Versioning
MariaDB version numbers follow the MySQL's numbering scheme up to version 5.5. Thus, MariaDB 5.5 offers all of the MySQL 5.5 features. There exists a gap in MySQL versions between 5.1 and 5.5, while MariaDB issued 5.2 and 5.3 point releases.
After the 5.5 version, MariaDB developers decided to start a branch numbered 10, as an attempt to make it clear that MariaDB 10.0 will not import all features from MySQL 5.6; however, they might be imported in future versions. Since specific new features have been developed in MariaDB, the developers decided that a major version number change was necessary.[10][11]
Version | Original release date | Latest version | Release date | Status |
---|---|---|---|---|
5.1 | 2009-10-29[12] | 5.1.67 | 2013-01-30[13] | Stable (GA) |
5.2 | 2010-04-10[14] | 5.2.14 | 2013-01-30[15] | Stable (GA) |
5.3 | 2011-07-26[16] | 5.3.12 | 2013-01-30[17] | Stable (GA) |
5.5 | 2012-02-25[18] | 5.5.47 | 2015-12-10[19] | Stable (GA) |
10.0 | 2012-11-12[20] | 10.0.23 | 2015-12-18[21] | Stable (GA) |
10.1 | 2014-06-30[22] | 10.1.10 | 2015-12-24[23] | Stable (GA) |
Legend:
Old version
Older version, still supported
Latest version
Latest preview version
|
Third-party software
MariaDB's API and protocol are compatible with those used by MySQL, plus some features to support native non-blocking operations and progress reporting. This means that all connectors, libraries and applications which work with MySQL should also work on MariaDB—whether or not they support its native features. On this basis, Fedora developers replaced MySQL with MariaDB in Fedora 19, out of concerns that Oracle is making MySQL a more closed software project.[24]
Here is a list of tools that are known to work properly with MariaDB:
Clients
- Database Workbench – a software application for development and administration of multiple relational databases including MySQL, with interoperationality between different database systems.
- DBEdit – a free administration application for MariaDB and other databases.
- HeidiSQL – a free and open source client for MySQL on Windows. It supports MariaDB specific features like Virtual Columns, and is included with the Windows MSI package of MariaDB beginning with the 5.2.7 release.[25][26]
- Navicat – a series of proprietary database management applications for Windows, Mac OS X, and Linux.
- phpMyAdmin – a web-based database management application for MySQL.
- SQLyog – a database management application on Windows, Linux.
- DBeaver – a database management application on Windows, Linux, Mac OS X.
- Sequel Pro – a MySQL database management application on Mac OS X[27]
Applications
The following applications officially support MariaDB:[28]
<templatestyles src="Div col/styles.css"/>
MariaDB Foundation
In December 2012, Michael Widenius, David Axmark, and Allan Larsson announced the creation of a foundation that would oversee the development of MariaDB.[29][30] In April 2013, the Foundation announced that it had appointed Simon Phipps as its Secretary and interim Chief Executive Officer, Rasmus Johansson as Chairman of the Board, and Andrew Katz, Jeremy Zawodny, and Michael Widenius as Board members.[31] Noting that it wished to create a governance model similar to that used by the Eclipse Foundation, the Board appointed the Eclipse Foundation's Executive Director Mike Milinkovich as an advisor to lead the transition.[31]
SkySQL Corporation Ab, a company formed by ex-MySQL executives and investors after Oracle bought MySQL, announced in April 2013 that they were merging their company with Monty Program Ab, and joining the MariaDB Foundation. SkySQL's CEO Patrik Sallner would lead the new merged company, and Widenius was appointed as its CTO by the MariaDB Foundation.[32]
On October 1, 2014, SkySQL Corporation Ab changed its name to MariaDB Corporation Ab[33] to reflect its role as the main driving force behind the development of MariaDB server and the biggest support provider for it.[34]
MariaDB is a registered trademark of MariaDB Corporation Ab,[35] used under license by the MariaDB Foundation.[36]
Prominent users
<templatestyles src="Div col/styles.css"/>
- LAMP stack
- Arch Linux[37]
- Chakra Linux[38]
- Fedora (from Fedora 19)[39]
- Gentoo Linux[40]
- Google[41]
- Mozilla[42]
- OpenBSD[43][44] (from 5.7)
- openSUSE (from openSUSE 12.3)[45]
- Oracle Linux (from 7)
- Red Hat Enterprise Linux (from RHEL 7)[46]
- Slackware[47]
- Wikimedia Foundation[48]
- SaltOS[49]
- Web Of Trust[50]
- WPN-XM[51]
- Zimbra (from 8.5)[52]
Support
Google has sent an engineer to the MariaDB Foundation.[53] A group of investment companies, including Intel, has invested $20 million in SkySQL.[54]
See also
References
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ MariaDB 5.2.7 released!, Monty Program Group Blog
- ↑ Sequel Pro official website
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ 31.0 31.1 Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ https://www.archlinux.org/news/mariadb-replaces-mysql-in-repositories/ Arch Linux News - 25 March 2013 MariaDB replaces MySQL in repositories
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.'
- ↑ Lua error in package.lua at line 80: module 'strict' not found.'
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
Further reading
- Lua error in package.lua at line 80: module 'strict' not found.
- Lua error in package.lua at line 80: module 'strict' not found.
- Lua error in package.lua at line 80: module 'strict' not found.
External links
Wikibooks has a book on the topic of: MariaDB |
- MariaDB Foundation website
- MariaDB Corporation website
- MariaDB Knowledge Base – MariaDB documentation
- MariaDB, the Backward Compatible Branch of MySQL(R) Database Server on YouTube – a lecture given by Monty Widenius at Google