MARIADB is a branch of MySQL source code, and as Oracle buys Sun,mysql it falls into the hands of a relational database. After realizing what Oracle would do with the MySQL license (MySQL was acquired by Sun and Oracle), Michael, the father of MySQL, began another derived version of MySQL with the name of his daughter, Maria: MariaDB.
Difference One:
MARIADB is not just a replacement for MySQL, MARIADB includes some new features that make it better than MySQL.
Difference Two:
MARIADB is compatible with MySQL in most respects, and for developers, it almost doesn't feel any different. Currently MARIADB is the fastest-growing MySQL branch version, and the new version has been released faster than the Oracle's official MySQL version.
MariaDB is a MySQL branch version with the ARIA storage Engine, and more code for this project is adapted to MySQL 6.0
Difference Three:
The overall test found that MARIADB's query efficiency increased by 3%-15%, an average increase of 8%, and no exception occurred, in QP, throughput increased by 2%-10%. It is not possible to draw any conclusions from the lack of data support, but the test results appear to be very positive. The use of indexes in joins and query optimization, especially for subqueries, mariadb a lot of improvements. In addition, MARIADB has good support for MySQL import and export.
Learn about MySQL's relationship with MARIADB