MySQL is an open source database system, in recent years, the use of more and more high, is currently owned by Oracle Company, its own MySQL trademark, belongs to the mainstream version, due to its open source features, there are some branches, common mariadb, Percona Server, drizzle. Each of these three editions has its own characteristics. One of the most popular is mariadb, many Linux distributions default MySQL has been switched to MARIADB, but other branches also have their scope of application, in the selection needs to be carefully screened. Percona server is owned by a MySQL consulting firm, and the company's Toolkit Percona Toolkit is very well known. This database is also open source, but does not accept external code contributions, because it is actually an enhanced version of Oracle's mainstream MySQL version, so its version number is essentially the same as the mainstream version of Oracle, with the goal of enhancing the mainstream version functionality, focusing on transparency, performance, and operational flexibility. Compatibility can be directly open the mainstream version of the database, the other is not difficult, which facilitates the temporary switch, the company does not seem to advocate the user to replace the MySQL version, perhaps its subsequent development power is limited. The default search engine is the XTRADB storage engine, the improved version of InnoDB, which is fully compatible with InnoDB.  MARIADB is the founder of MySQL Monty Widenius because of dissatisfaction with the MySQL development process, while leaving Sun after the creation of the Monty company developed by the MySQL branch, mariadb the name of the source of its daughter's name Maria. MARIADB's default storage engine is ARIA, the enhanced version of MyISAM, which supports transactional functionality, and adds many extensions to the server, including the Percona xtradb engine, as well as the Sphinxse and PBXT engines. At present, its version is 10.0.12, the source code from the mainstream version of the MySQL5.5 version, according to its website, porting and re-implemented the characteristics of MySQL5.6, adding some new features. However, its 10.1.0 version is also in development, its website description is "MariaDB 10.1 is currently being developed version, is the evolution of MariaDB 10.0, including some features from MySQL 5.6, 5.7 of the porting and re-implementation, including some new features", from the present , MARIADB's goal is to be compatible with mainstream versions, add new features, and MARIADB is a good choice if Oracle does not update the version for a long time. But there is a problem, Monty company also needs to profit, it also provides MARIADB Enterprise Edition and CLUSter, its persistence does not know whether it is comparable to Oracle. Drizzle is a completely different branch, it is not compatible with MySQL, based on MySQL 4.1 source code, removed the redundant features, the development language to C + +, the use of popular boost library, the target is large memory, multi-core system, more suitable for new applications. In the version of the choice, the mainstream version is the first choice, MARIADB currently see no obvious advantages, and its new features have not caused overwhelming advantage, Percona server itself, is the enhanced version of MySQL, there is no obvious advantage. Drizzle need a more careful choice, after all, it is incompatible with MySQL. So in general, you should choose the mainstream version and test the MARIADB version to see if it is worth migrating.
