MySQL Branch Select reference: Percona or MARIADB_MARIADB

After MySQL was acquired by Oracle, more and more people expressed concern about the future of MySQL, the open source of MySQL, more or less of Oracle's own database products, the impact of the open source of free MySQL for Oracle more baggage than assets. For example, Taobao turned from Oracle to MySQL, some large internet companies are also in the implementation of IoE (I:IBM,O:ORACLE,E:EMC), Oracle acquired MySQL, there will be MySQL closed source of potential risks, so the community to use a branch of the way to avoid this risk.

Percona

Before introducing Percona, the first thing to introduce is the XTRADB storage engine, in MySQL contact more is MyISAM and InnoDB these two storage engines, the previous article: "MySQL MyISAM and InnoDB difference" also carried out a detailed introduction.

MySQL 4 and 5 use the default MyISAM storage engine to install each table. Starting with 5.5, MySQL has changed the default storage engine from MyISAM to InnoDB. MyISAM does not provide transactional support, while InnoDB provides transactional support. Compared with MyISAM, InnoDB provides a number of minor performance improvements and provides greater reliability and security when dealing with potential data loss.

Percona XTRADB is an enhanced version of the InnoDB storage engine that is designed to better use the performance of updated computer hardware systems, and includes new features in high-performance environments. The XTRADB storage engine is fully backward compatible, and in mariadb, the XTRADB storage engine is identified as "Engine=innodb", which is the same as InnoDB, so you can replace xtradb with InnoDB without any problems. The Percona xtradb contains all InnoDB ' s robustness, an ACID-compatible design that can be relied upon, and a high-level MVCC architecture. XTRADB is built on a solid foundation of InnoDB, enabling XTRADB to have more features, better invocations, more parameter metrics and more extensions. From a practical standpoint, XTRADB is designed to use memory more efficiently and more conveniently and more readily in multiple core conditions. New features are used to reduce the limitations of InnoDB. Performance level, XTRADB can handle 2.7 times times more transactions per minute than the built-in MySQL 5.1 InnoDB engine.

Percona server is released by Percona, a leading MySQL consulting firm. Percona Server is a stand-alone database product that can be completely compatible with MySQL and can be replaced with xtradb without changing the code.

The Percona team's final statement is that "Percona server is the closest version of the official MySQL enterprise release released by Oracle," and therefore differs from other branches that change a large number of basic core MySQL code. One drawback of Percona server is that they manage their own code and do not accept the contributions of outside developers in such a way as to ensure that they control the functionality contained in the product.

Website address: http://www.percona.com/

Mariadb

MARIADB was developed by MySQL founder Macker Vidnius, who previously sold his company, MySQL AB, to Sun at a price of 1 billion dollars, and then, as Sun was bought by Oracle, the ownership of MySQL fell into Oracle's hands. Mariadb name comes from Macker Vidnius's daughter Maria (English: Maria).

MARIADB is designed to be completely compatible with MySQL, including APIs and command lines, making it easy to become a replacement for MySQL. On the storage engine side, the 10.0.9 version uses XTRADB (name code ARIA) to replace the MySQL InnoDB.

Version, mariadb until version 5.5, all in accordance with the MySQL version. As a result, people using MariaDB5.5 will learn all the features of mariadb from MySQL 5.5. Starting from November 12, 2012, release 10.0.0, no longer in accordance with the MySQL version number. The 10.0.x version is based on version 5.5, combined with the features of the MySQL 5.6 version and the new features developed by itself.

Compared to the latest mysql5.6,mariadb, it includes richer features in performance, functionality, management, and NoSQL scalability. such as microsecond support, thread pool, subquery optimization, group submission, progress report, etc.
Website address: https://mariadb.org/

Percona OR mariadb

Choice is already painful things, for the above two databases, is large companies also have differences, like Taobao is currently using Percona 5.5.18, and Google\wikipedia is standing on the mariadb side. The specific one will go farther, we will wait and see.