MySQL branch Percona

Reprinted from: http://www.cnblogs.com/cevin/archive/2012/05/12/2496859.html

Http://www.percona.com/

 

Percona has improved the MySQL database server and significantly improved its functions and performance compared with MySQL.

This version improves the performance of InnoDB under high loads and provides DBA with some useful performance diagnostic tools. In addition, more parameters and commands are available to control server behavior.

Percona Server only contains the MySQL Server version, and does not provide corresponding improvements to MySQL Connector and GUI tools.

Percona Server uses google-mysql-tools, Proven Scaling, and Open Query to transform MySQL.

 

Compared with the built-in MySQL storage engine, XtraDB provides some significant improvements, but it is not an independent product and cannot be easily installed in existing MySQL.

Therefore, if you want to use this new engine, you must use the product that provides it.

Percona Server is such a product released by Percona, a leading MySQL consulting company.

Percona Server is an independent database product that provides users with the ability to install and switch from MySQL to Percona Server.

By doing so, you can use the XtraDB storage engine. Percona Server claims to be fully compatible with MySQL, So theoretically you do not need to change any code in the software.

This is indeed a great advantage and is suitable for quality control when you are looking for fast performance improvements. Therefore, a good reason for using Percona Server is to use the XtraDB engine to minimize code changes.

They are also the original authors of the XtraDB storage engine. Percona uses this code as the open source code, so you can find it in other products, but the engine's original creator is the same person who wrote this product,

Therefore, you can use this information as you like.

The following is a Percona Server statement from their own website: • Scalability: handles more transactions;

Expansion on powerful servers • Performance: XtraDB's Percona Server is used for extremely fast speeds • Reliability: damage prevention, crash-safe replication • Management: online backup,

Online table import/export • diagnosis: advanced analysis and detection • Flexibility: Variable page size, improved Buffer Pool Management

The final statement of the Percona team is that "Percona Server is the closest version to the official MySQL Enterprise release version released by Oracle", which is different from other branches that have changed a large number of basic core MySQL code.

One disadvantage of Percona Server is that they manage their own code and do not accept contributions from external developers. In this way, they ensure their control over the features included in the product.