MariaDB vs. MySQL: Complete Comparison | Dataplugs

MariaDB vs. MySQL: Complete Comparison

Web Hosting

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

NameMariaDB  MySQL  
DescriptionMySQL 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 modelRelational DBMSRelational DBMS
Secondary database modelsDocument store
Graph DBMS
Key-value store
Document store
Key-value store
Websitemariadb.com
mariadb.org
www.mysql.com
Technical documentationmariadb.com/kb/en/library/dev.mysql.com/doc/
DeveloperMariaDB Corporation Ab (MariaDB Enterprise),
MariaDB Foundation (community MariaDB Server)
Oracle
Initial release20091995
Current release10.3.10, October 20188.0.12, July 2018
License Open Source Open Source
Cloud-based only NoNo
DBaaS offerings Google Cloud SQL: A fully-managed database service for the Google Cloud Platform
Implementation languageC and C++C and C++
Server operating systemsFreeBSD
Linux
Solaris
Windows
FreeBSD
Linux
OS X
Solaris
Windows
Data schemeYesYes
Typing YesYes
XML support YesYes
Secondary indexesYesYes
SQL YesYes
APIs and other access methodsProprietary native API
ADO.NET
JDBC
ODBC
Proprietary native API

ADO.NET

JDBC

ODBC

Supported programming languagesAda
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 YesYes
TriggersYesYes
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 NoNo
Consistency concepts Immediate ConsistencyImmediate Consistency
Foreign keys yes yes
Transaction concepts ACID ACID
Concurrency yesyes
Durability yes yes
In-memory capabilities yesyes
User concepts fine grained access rights according to SQL-standardUsers 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 phone +852 3959 1888 or email sales@dataplugs.com.