In this article you will find the comparison between MariaDB vs MySQL.
MariaDB
MariaDB is a community-developed, commercially supported fork of the MySQL RDBMS,
It is intended to remain free and open-source software under the GNU General Public License.
Made by the original developers of MySQL.
MySql
MySQL is the most popular Open Source SQL relational database management system.
It was started by a Swedish company “MySQL AB” in 1995. MySQL AB was later acquired by Sun Microsystems in 2008. Later, Sun Microsystems was acquired by Oracle in 2010. It is developed, distributed, and supported by Oracle Corporation now.
- MariaDB has faster speed of executing statements.
- MariaDB is an improved version of MySQL in terms of security and performance.
- There are 12 Storage engines in MariaDB. You have to install them Manually in MySQl.
- In MariaDB INSERT statement can be completed 24% faster than in the standard MySQL.
- MariaDB is open-source, the Enterprise Edition of MySQL uses a proprietary code. Only users of MySQL Enterprise Edition have access to this.
- MariaDB has better Performance in Flash Storage.(Because of MyRocks storage engine).
- When you query a view in MySql, all of the tables that are connected to the view are queried. In MariaDB only those tables are queried that are required by the query.
- MariaDB supports virtual columns.
- MariaDB allows Parallel Execution of Queries.
