November 14, 2010 at 04:51Forks of the MySQL engine: MariaDB, Percona. who is who?
MySQL has become the property of Oracle, are there any alternatives and how fast is it moving forward? .. It seems like a generalized overview of “who is who?” not yet been. So, the reviewer for those who are "off topic"
Some people are scared , but many are simply not happy that MySQL has become owned by Oracle. Fortunately, we already live in a world where information is spreading with the speed ofprinting thoughts and decisions are lightning fast.
Michael Widenius , founder of MySQL and founder of MySQL AB (which Sun absorbed and Oracle absorbed)
Peter Zaitsev, MySQL performance expert, former team leader for High Performance at MySQL Inc, host of MySQLPerformanceBlog.com,
so what are there alternatives?
Percona server is a MySQL build (from Peter Zaitsev and co) with the XtraDB storage engine enabled by default. Differs from MySQL + InnoDB plugin in better performance / scalability, especially on modern multi-core servers. The functionality is also improved - more than anything useful for optimizing statistics, etc. It is assembled in versions based on MySQL 5.0 and 5.1. It is fully compatible with innodb tables, that is, you can switch from innodb to xtradb and vice versa without problems (if you do not use some functions specific to xtradb, such as a smaller page size). XtraDB
Storagebased on InnoDB-plugin code, fully compatible with it, but markedly higher performance thanks to the integration of patches from Google and Percona. In particular, XtraDB improved the mechanism for working with memory, improved the work of the InnoDB I / O subsystem, added support for multiple read and write streams, support for bandwidth management, implementation of read-ahead data, adaptive checkpointing , scaling capabilities for large projects have been expanded, the lock organization system has been adapted to work on systems with a large number of CPUs, additional features have been added for the accumulation and analysis of MariaDB statistics
- the assembly from Monti is synchronized with the MySQL code base and is fully compatible with it, i.e. can act as a transparent replacement for MySQL 5.1, while possessing a number of advanced functions, including performance optimizations and coming with a set of additional storage engines:
MariaDB prebuilt binary builds are available for Windows, Debian, Ubuntu, RHEL 5, CentOS 5, and Solaris x86.
License the GPL v2 .
PS All this cannot be found in FreeBSD ports, the main emphasis is on Linux. If someone collected and installed - share experience.
Additional information:
csa : http://blogerator.ru/page/mysql-na-steroidah overview of a larger number of different forks of MySQL
apelsyn : Barracuda InnoDB File Format
bondbig : MySQL and Google MySQL Customer Google
Some people are scared , but many are simply not happy that MySQL has become owned by Oracle. Fortunately, we already live in a world where information is spreading with the speed of
Michael Widenius , founder of MySQL and founder of MySQL AB (which Sun absorbed and Oracle absorbed)
Peter Zaitsev, MySQL performance expert, former team leader for High Performance at MySQL Inc, host of MySQLPerformanceBlog.com,
so what are there alternatives?
Percona server is a MySQL build (from Peter Zaitsev and co) with the XtraDB storage engine enabled by default. Differs from MySQL + InnoDB plugin in better performance / scalability, especially on modern multi-core servers. The functionality is also improved - more than anything useful for optimizing statistics, etc. It is assembled in versions based on MySQL 5.0 and 5.1. It is fully compatible with innodb tables, that is, you can switch from innodb to xtradb and vice versa without problems (if you do not use some functions specific to xtradb, such as a smaller page size). XtraDB
Storagebased on InnoDB-plugin code, fully compatible with it, but markedly higher performance thanks to the integration of patches from Google and Percona. In particular, XtraDB improved the mechanism for working with memory, improved the work of the InnoDB I / O subsystem, added support for multiple read and write streams, support for bandwidth management, implementation of read-ahead data, adaptive checkpointing , scaling capabilities for large projects have been expanded, the lock organization system has been adapted to work on systems with a large number of CPUs, additional features have been added for the accumulation and analysis of MariaDB statistics
- the assembly from Monti is synchronized with the MySQL code base and is fully compatible with it, i.e. can act as a transparent replacement for MySQL 5.1, while possessing a number of advanced functions, including performance optimizations and coming with a set of additional storage engines:
- New data warehouses:
- Aria (formerly Maria ) - MyISAM-based highly reliable storage, characterized by increased stability and preservation of data integrity after a crash, with full compatibility with MyISAM
- OQGRAPH (storage for organizing complex graphs)
- Sphinx - storage for building search engines
- PrimeBase XT - description in Russian
- XtraDB engine is used as a replacement for InnoDB
- FederatedX - allows you to organize access to remote tables as local
- MyISAM engine patches - Segmented cache (at high loads gives a significant increase)
- Virtual columns
- Table elimination - a new kind of query optimization using JOIN
- Thread pool - now you can open more than one thread per connection
- Improved mechanisms for debugging slow queries
MariaDB prebuilt binary builds are available for Windows, Debian, Ubuntu, RHEL 5, CentOS 5, and Solaris x86.
License the GPL v2 .
PS All this cannot be found in FreeBSD ports, the main emphasis is on Linux. If someone collected and installed - share experience.
Additional information:
csa : http://blogerator.ru/page/mysql-na-steroidah overview of a larger number of different forks of MySQL
apelsyn : Barracuda InnoDB File Format
bondbig : MySQL and Google MySQL Customer Google