Old Jiang installed the MySQL database by default when installing the website environment on the Linux MB small memory VPS server the day before yesterday. It was found that the installation was not possible because the memory was insufficient during script compilation, and even if the installation is successful, the memory resources are still relatively large. The MariaDB database will be replaced later to replace the MySQL database and the database will be installed successfully, occupying resources and running everything is normal.
Most of the websites we build are probably still using MySQL databases. After all, everyone is familiar with this method, but none of our products have the same advantages. It turns out that MySQL founder Widenius re-created the MariaDB branch after leaving the company, and used the open-source method to re-create a new database, which is gradually used by more merchants and users.
This is also because MySQL has been acquired by Sun and Oracle and is in the form of closed source. Due to various possible problems, MariaDB databases are also widely promoted and used based on this factor, in terms of functions, it can basically replace the MYSQL database and most programs support it. Are there any differences between the two?
1. MariaDB development trend and update frequency
After all, the MariaDB database developed based on the founder of MySQL must know the weaknesses of the MYSQL database and provide better compatibility and scalability, we can basically recommend MYSQL databases to the MariaDB database, and MariaDB's development speed and upgrade speed are far preferred.
2. MySQL closed and slow development
After MySQL was acquired, the update speed and performance were optimized very slowly, and the source was closed. No one outside of Oracle was involved, many problems that need to be solved are not upgraded. On the contrary, many companies also use their own developed branch MYSQL versions.
Third, MariaDB's characteristics and advantages
MariaDB is a transaction-based Maria storage engine that replaces MySQL's MyISAM storage engine. It uses Percona's XtraDB and InnoDB variants. MariaDB's default storage engine is Aria, not MyISAM. Aria supports transactions, but it does not enable transaction support by default, because transaction support affects performance. MariaDB is a MySQL branch version using the Maria storage engine. It is a free open-source database server developed by MySQL author Michael Widenius.
IV. Comparison between MariaDB and MySQL
This intuitive difference lies in MariaDB's ability to quickly query and process data and occupy less resources than MySQL databases. In addition, MariaDB is superior to MYSQL databases in terms of running speed and Unicode sorting.
Summary: there are still a lot of disputes over the discussion between MariaDB and MySQL databases on the internet. Although MariaDB has been released to version 10.1, it is still in the test version, and some users prefer it, however, for new users, you can choose to use it. There are few documents on document or environment deployment and problem solving. However, in the future, Chiang will try some MariaDB database tutorials.
