MariaDB

From Coders.Bay Wiki
Revision as of 08:22, 8 April 2022 by 85.31.21.47 (talk) (Created page with "{{short description|Database management system, relational, open source, community developed fork of MySQL}} {{Infobox software | name = MariaDB | title = MariaDB | logo = Mar...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Template:Short description Template:Infobox software

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.<ref>Template:Cite web</ref>

MariaDB is intended to maintain high compatibility with MySQL, with library binary parity and exact matching with MySQL APIs and commands, allowing it in many cases to function as drop-in replacement for MySQL. However, new features are diverging.<ref>Template:Cite web</ref> It includes new storage engines like Aria, ColumnStore, and MyRocks.

Its lead developer/CTO 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. Sun was then bought the following year by Oracle Corporation. MariaDB is named after Widenius' younger daughter, Maria. (MySQL is named after his other daughter, My.)<ref>Template:Cite web</ref>

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 was making MySQL a more closed software project.<ref name="auto1">Template:Cite web</ref> OpenBSD likewise in April 2013 dropped MySQL for MariaDB 5.5.<ref>Template:Cite web</ref>

However, for recent MySQL features, MariaDB either has no equivalent yet (like geographic function) or deliberately chose not to be 100% compatible (like GTID, JSON).<ref>Template:Cite news</ref> The list of incompatibilities grows longer with each version.<ref>Template:Cite web</ref>