MariaDB vs MySQL

Posted on by

MariaDB is a popular fork of MySQL created by MySQL’s original developers. It was primarily developed because of concerns that emerged when MySQL was acquired by Oracle Inc. Today it is a great replacement of MySQL. We can easily switch from MySQL to MariaDB.



These are the some similarities and differences between MySQL and MariaDB

 

It also has same these features as mysql like durability, concurrency, triggers, in-memory capabilities.MariaDB is developed by MariaDB Corporation, but also open for public discussion. Anyone can submit patches to MariaDB that can be added to the main repository.

It has two licensing options GPLv2 (Community edition) and Enterprise.It supports different operating systems like FreeBSD, Linux, Solaris, OS X, Windows.It supports different operating systems like FreeBSD, Linux, Solaris, OS X, Windows.

MySQL MariaDB
MySQL is also open source relational database management system. MariaDB is open source relational database management system.
Initially released on 23 May 1995. Initially released on 22 January 2009.
It is written in C, C++. It is written in C, C++, Perl, Bash.
It supports in different operating systems like FreeBSD, Linux, Solaris, OS X, Windows. It supports in different operating systems like FreeBSD, Linux, Solaris, OS X, Windows.
MySQL consists of tables, columns, views, procedures, triggers, cursors, etc. MariaDB has same data structure as mysql, so we can easily migrate from mysql to mariadb.
The supported storage engines of MySQL are InnoDB, MyISAM, Memory, CSV, Archive, Blackhole, Merge, Federated. The supported storage engines of MariaDB are XtraDB, InnoDB, MariaDB ColumnStore, Aria, Archive, Blackhole, Cassandra Storage Engine, Connect, CSV, FederatedX, Memory storage engine, Merge, Mroonga, MyISAM, MyRocks, QQGraph, Sequence Storage Engine, SphinxSE, Spider, TokuDB.
It has features like durability, concurrency, triggers, in-memory capabilities. It also has same these features as mysql like durability, concurrency, triggers, in-memory capabilities.
MySQL is developed and maintained by Oracle Corporation MySQL’s team members. MariaDB is developed by MariaDB Corporation, but also open for public discussion. Anyone can submit patches to MariaDB that can be added to the main repository.
For security concerns, MySQL provides encryption technique to prevent from SQL injections and data corruption. MariaDB provides strong encryption technique, Kerberos, PAM and LDAP authentication to protect data.