MariaDB vs. MySQL: Complete Comparison
Both MySQL and MariaDB are being used by many large corporations and organizations today. MySQL was created by a Swedish company in 1995. It was evolved into an enterprise grade database and became the world’s most popular open source relational database software. In January 2008, Sun Microsystems bought MySQL. Then it was soon acquired by Oracle in late 2009. Out of distrust in Oracle stewardship of MySQL, a group of former MySQL developers had left and created MariaDB in 2009.
The goal for MariaDB is to be a binary drop-in replacement for MySQL which offers more features and better performance. The database structure and indexes of MariaDB are the same as MySQL. Users can switch from MySQL to MariaDB without having to alter their applications since the data and data structures do not need to change. To make sure MariaDB maintains drop-in compatibility, the MariaDB developers do a monthly merge of the MariaDB code with the MySQL code, along with some added bug fixes, additional storage engines, new features, and performance improvements. This means that for most cases, you can just uninstall MySQL and install MariaDB and you are good to go.
However, there are still some differences between MariaDB and MySQL that could cause some minor compatibility issues. For incompatibilities between MariaDB and MySQL, you can refer to https://mariadb.com/kb/en/library/mariadb-vs-mysql-compatibility/ for details.
People who advocate for MariaDB think that MariaDB development is more open and vibrant. All development decisions can be debated and reviewed via a public mailing list. People can also submit patches for MariaDB. This allows for more transparent and quicker security releases. MySQL, by contrast, is developed by Oracle and decisions are not open to public discussion. Starting from 2013, many web giants such as Wikipedia and Google are using MariaDB instead of MySQL. MariaDB has leapt in popularity since then. We expect to see more companies and organizations will choose MariaDB over MySQL in the future.
Comparison of MariaDB and MySQL
| Name | MariaDB | MySQL |
| 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 open source RDBMS |
| Primary database model | Relational DBMS | Relational DBMS |
| Secondary database models | Document store Graph DBMS Key-value store | Document store Key-value store |
| Website | mariadb.com mariadb.org | www.mysql.com |
| Technical documentation | mariadb.com/kb/en/library/ | dev.mysql.com/doc/ |
| Developer | MariaDB Corporation Ab (MariaDB Enterprise), MariaDB Foundation (community MariaDB Server) | Oracle |
| Initial release | 2009 | 1995 |
| Current release | 10.3.10, October 2018 | 8.0.12, July 2018 |
| License | Open Source | Open Source |
| Cloud-based only | No | No |
| DBaaS offerings | Google Cloud SQL: A fully-managed database service for the Google Cloud Platform | |
| Implementation language | C and C++ | C and C++ |
| Server operating systems | FreeBSD Linux Solaris Windows | FreeBSD Linux OS X Solaris Windows |
| Data scheme | Yes | Yes |
| Typing | Yes | Yes |
| XML support | Yes | Yes |
| Secondary indexes | Yes | Yes |
| SQL | Yes | Yes |
| APIs and other access methods | Proprietary native API ADO.NET JDBC ODBC | Proprietary native API ADO.NET JDBC ODBC |
| Supported programming languages | Ada C C# C++ D Eiffel Erlang Go Haskell Java JavaScript (Node.js) Objective-C OCaml Perl PHP Python Ruby Scheme Tcl | Ada C C# C++ D Delphi Eiffel Erlang Haskell Java JavaScript (Node.js) Objective-C OCaml Perl PHP Python Ruby Scheme Tcl |
| Server-side scripts | Yes | Yes |
| Triggers | Yes | Yes |
| Partitioning methods | Horizontal partitioning, sharding with Spider storage engine or Galera cluster | horizontal partitioning, sharding with MySQL Cluster or MySQL Fabric |
| Replication methods | Master-master replication Master-slave replication | Master-master replication Master-slave replication |
| MapReduce | No | No |
| Consistency concepts | Immediate Consistency | Immediate Consistency |
| Foreign keys | yes | yes |
| Transaction concepts | ACID | ACID |
| Concurrency | yes | yes |
| Durability | yes | yes |
| In-memory capabilities | yes | yes |
| User concepts | fine grained access rights according to SQL-standard | Users with fine-grained authorization concept |
Source: DB-Engines
All of our web hosting and SSD web hosting plans come with MariaDB 10.2.17 currently. If you have any questions about our hosting services, feel free to contact us by email at sales@dataplugs.com.