10 REASONS TO MIGRATE MYSQL TO MARIADB
10 reasons to migrate MySQL to MariaDB MySQL was created by David Axmark, Michael “Monty” Allan Larsson and Widenius. The first version of MySQL appeared in 1995. Was initially created for personal use, but in a short time evolved into an enterprise database and has become the open source software more popular in the world. In January 2008, Sun Microsystems purchased MySQL for $ 1 billion. Soon after, Oracle acquired Sun Microsystems after obtaining the approval of the European Commission at the end of 2009, which initially stopped the transaction due to concerns that such a merger would hurt the market of the database, since the MySQL was the main competitor of the database product from Oracle.
In the midst of several uncertainties regarding the administration of the Oracle with MySQL, the original developers of MySQL had split and created MariaDB in 2009. With the passing of time, the Library gradually was replacing the MySQL and you who are reading this article, should also consider this replacement in your server. Here at Hostdime, we are recommending that our clients migrate their databases from MySQL to MariaDB.
Development more open and vibrant
MariaDB is fully developed in open source (free and open source software). All development decisions can be reviewed and discussed on a public mailing list in the public Bug tracker. Contribute to MariaDB with patches is easy, and the flow of patch is transparent in the code repository. The statistics of Github for MySQL 5.7 show much more employees compared with the Maria DB. In addition, MariaDB seems more active in issues of documentation and distribution.
Security more quick and transparent
The Oracle only has a policy to make security releases (and related announcements) every three months for all its products. However, MySQL has a new version every two months. This sometimes leads to situations in which these security updates and the security information are not synchronized. In addition, the MySQL release notes do not list all the identifiers CVE.
More advanced features
MySQL 5.7 has some new features such as GIS. However, MariaDB has new features in the last few years, and they are posted in advance where in the majority of cases, these features seem to go through an overhaul more extensive prior to its release. For this reason, we believe that MariaDB offers the best features and least bugs.
For example, GIS have already been introduced in the series 5.3 of MariaDB, which makes the storage of coordinates and query location data very easy. Support for dynamic columns (only MariaDB) is interesting because it allows the functionality of the NoSQL-type and, therefore, a single database interface can provide SQL and “not only SQL” to the various needs of projects.
Best performance
MariaDB has a query optimizer that improved and many other best practices related to performance. Some benchmarks show that MariaDB is most powerful faster than MySQL. However, the benchmarks do not always translate directly to real-life situations. For example, when we migrate from MySQL to MariaDB, we observed performance improvements of between 3-5%. Although it seems little, the ideal is to always be the fastest, right?
Galera cluster multi-master
The Galera cluster uses its own replication technology. The version gives the users of the Library, access to a scale solution for SQL database with replication, multi-master and synchronous data consistency guaranteed.
The cluster management is handled by an automated control of the members, with automatic grouping of nodes, and abandonment of we flawed. The database synchronization, replication, parallel level lines, has been developed to improve the Library to support the Write Set Replication API (wsrep). The developers report that the solution provides a system with no slave lag or loss of transactions.
Easy migration and compatibility
MariaDB 5.5 is a complete replacement for MySQL 5.5. The migration to MariaDB is as easy as running the apt-get install mariadb-server or linux command of your choice (that, in 2015, has included MariaDB in their official repositories).
Despite the migration to be considered as easy, we recommend that the database administrators to perform their own tests and always do backup of your databases just for security issues
