Which is better, MariaDB or MySQL? Compare the differences and functions between MariaDB and MySQL

These days, when helping netizens maintain their servers, I saw that their websites actually use the MariaDB database. We usually use MySQL. Of course, most of the current programs also support these two database types. When we set up the server WEB environment, we also saw that two databases can be selected. Which is better, MariaDB or MySQL? If we install it, which one should we choose.

First, MariaDB database

The MariaDB database is actually a branch of MySQL that we often use. It has been maintained and upgraded by open source settings. It is licensed under the GPL license. What's more, we should know that MariaDB is fully compatible with MySQL, and we can use it as a substitute for MySQL. However, in terms of storage engine, XtraDB is used to replace MySQL InnoDB. At the beginning, we saw that the version and model are synchronized, but the current version is higher than MYSQL. Its version number starts directly from 10.0, and it is developed at its own pace. Of course, it is fully compatible with MySQL. In some aspects, we can see that the data characteristics and performance of MariaDB surpass MySQL.

Second, MySQL database

MySQL is a fairly old database type. Since MySQL 5.5 was released, Oracle has made InnoDB the default storage engine for MySQL, which has greatly improved the efficiency and storage performance. Therefore, if we have low configuration servers, we recommend starting from 5.5. At present, the MYSQL version has been upgraded to version 8.0, but if we need to install the advanced version, we need to see the compatibility of our own configuration server and program.

Third, which one to choose between MariaDB and MySQL

According to the trend, our general users can use MySQL, but if we want to pursue performance, we can start to try MariaDB. After all, the development flexibility of MariaDB is really different from before. We can try different projects and compare them. Anyway, the two can be switched, and there is no problem.