Forks engine MySQL: MariaDB, Percona. who is who?

MySQL has become the property of Oracle, are there any alternatives and how fast is moving forward? .. It seems that there has not yet been a general reviewer "who is who?" So, the reviewer for those who are "out of topic"



Some people are frightened , and many are simply not satisfied that MySQL has become owned by Oracle. Fortunately, we are already living in a world where information spreads at the speed of typing thoughts and solutions are lightning fast.



Michael Widenius , founder of MySQL and founder of MySQL AB (which Sun absorbed and Oracle absorbed)

Petr Zaitsev - MySQL Performance Expert, former High Perfomance Team Leader for MySQL Inc, MySQLPerformanceBlog.com blog host



So what are the alternatives?

')

Percona server is a MySQL build (from Peter Zaitsev and co) with the XtraDB storage engine enabled by default. It differs from MySQL + InnoDB plugin with better performance / scalability, especially on modern multi-core servers. Also improved functionality - more than any useful for optimizing statistics, etc. Gathers in variants based on MySQL 5.0 and 5.1. Fully compatible with innodb tables, i.e., you can switch from innodb to xtradb and back without problems (if you don’t use some xtradb-specific functions, such as smaller page size).



The XtraDB storage is based on the InnoDB-plugin code, is fully compatible with it, but differs in markedly higher performance, thanks to the integration of patches from Google and Percona. In particular, XtraDB improved the mechanism of working with memory, improved the operation of the I / O subsystem InnoDB, added support for multiple read and write streams, support for bandwidth control, implementation of read-ahead, adaptive setting of control points (adaptive checkpointing) , scaling options for large projects were expanded, the system of organizing locks was adapted to work on systems with a large number of CPUs, additional possibilities were added for accumulating and analyzing statistics



MariaDB is an assembly from Monty, synchronized with the MySQL code base and fully compatible with it, i.e. It can act as a transparent replacement for MySQL 5.1, while possessing a number of advanced features, including performance optimization and comes with a set of additional storage engines:

• New data stores:
  
  
  • Aria (formerly Maria ) - based on MyISAM highly reliable storage, characterized by increased stability and preservation of data integrity after the crash, with full compatibility with MyISAM
  • OQGRAPH (storage for the organization of complex graphs)
  • Sphinx - repository for building search engines
  • PrimeBase XT - Description in Russian
  • As a replacement for InnoDB, the XtraDB engine is used.
  • FederatedX - allows you to organize access to remote tables as local
• Patches MyISAM engine - Segmented cache (with high loads gives a significant increase)
• Virtual columns
• Eliminate tables - a new kind of query optimization using JOIN
• Thread pool - now you can open more than one thread for one connection
• Improved slow query debugging mechanisms

MariaDB’s pre-built binary builds are available for Windows, Debian, Ubuntu, RHEL 5, CentOS 5, and Solaris x86 platforms.

GPL v2 license .

PS In the FreeBSD ports all this is not found, the main focus is on Linux. If someone collected and set - share pliz experience.



Additional Information:

csa : http://blogerator.ru/page/mysql-na-steroidah review of a larger number of different MySQL forks

apelsyn : Barracuda InnoDB File Format

bondbig : MySQL and Google MySQL Customer Google