Javatpoint Logo
Javatpoint Logo

MariaDB vs. MySQL

Both MariaDB and MySQL are the types of Relational Database Management System (RDBMS) which are free and open-source software. In 2009, Michael Monty Widenius, the founder of MySQL, decided to develop a fork of MySQL, which was named MariaDB. MariaDB provides commercial support to MySQL. Both RDBMS softwares are used to store data in the database.

MariaDB vs MySQL

Let's understand the difference between MariaDB and MySQL on the following basis:

1) Initial Release and Stable Release

MariaDB was initially released on 29 October 2009. It had its stable release on 11 September 2019.

MySQL was initially released on 23 May 1995. Its stable release was on 22 July 2019.

2) Developers

MariaDB was developed by MariaDB Corporation AB, MariaDB Foundation.

The original startup of MySQL was done by a Swedish company, MySQL AB in 1994. In 2008, Sun Microsystems acquired MySQL AB. Later, in 2010, Sun Microsystems was led by Oracle Corporation. Thus, Oracle Corporation maintains MySQL at present.

3) Programming Languages used

MariaDB is written in C, C++, Perl, and Bash programming languages.

MySQL is written in C and C++ programming languages.

4) Users

MariaDB prominent customers are DBS, Redhat, Google, Ubuntu, Wikipedia, Suse, etc.

MySQL prominent users are Youtube, Twitter, Facebook, Netflix, NASA, Tesla, etc.

5) Compatibility

MySQL is an open-source RDBMS which stores data in the form of tables, triggers, views, or stored procedures. It uses different keys such as a primary key, foreign key, etc. to maintain data integrity and redundancy.

MariaDB is an extended version (fork) of MySQL having new extensive features, such as Cursors with parameters, INVISIBLE columns, NEW statements, and many more. These additional features are so well that it has replaced MySQL with MariaDB. It has a similar database structure and indexes as MySQL. Therefore, it is compatible to import/export our application from MySQL to MariaDB without any alteration and modification.

6) Versions

In MySQL, there exists a version gap between 5.1 and 5.5 whereas, in MariaDB, it has continuous versions as 5.2, 5.3. MariaDB version 5.5 carries all the features of MySQL version 5.5.

7) Storage Engines

In MySQL, BLACKHOLE, MyISAM, MERGE, CSV, etc. storage engines are included for data storage. On the other hand, MariaDB includes 12 new additional storage engines with MariaDB sources and Binary Packages.

8) Encryption

MariaDB provides support to temporary table encryption as well as binary log encryption.

MySQL does not provide support to temporary tables encryption and binary log encryption. But, it encrypts redo/undo logs when they are configured to do so.

9) Password Validation

MySQL consists of a default feature of improving security by validating and testing the passwords.

MariaDB does not offer such feature.

10) Performance

As MariaDB consists of more storage engines, it is able to fastly execute different operations such as insert, delete on the data. MariaDB performance is 4x times faster than MySQL.

MySQL does not execute as fast as MariaDB can.

11) Replication

Different versions of MariaDB allows to replicate data from MySQL server to MariaDB server, whereas MySQL versions do not allow data to replicate from MariaDB server to it. MySQL offers master-slave replication whereas, MariaDB offers master-master and master-slave replication of the data.

12) Cloud Platforms

MySQL is available as a managed service on Google Cloud platforms, and as a service on Amazon Web Services(AWS), Rackspace Cloud, and Microsoft Azure.

MariaDB is available as a service on Rackspace Cloud, Microsoft Azure, and AWS only.

13) License

MariaDB contains only one license of GPLv2 (for community).

MySQL contains two licenses: GPLv2 (for community) and Enterprise license.

Although there are many differences between MariaDB and MySQl, the syntactical structure is same for both.

Let's see how:

To select all the records from STUDENT table:

  • MariaDB: SELECT * FROM STUDENT;
  • MySQL: SELECT * FROM STUDENT;

To delete records from STUDENT table:

  • MariaDB: DELETE FROM STUDENT <where condition>;
  • MySQL: DELETE FROM STUDENT <where condition>;





Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA