Posted by markus_petrux on January 25, 2009 at 9:40am
Reading the MySQL Performance Blog I've found that they have released a new storage engine that's based on InnoDB with a few performance additions. I thought it could be of interest to some of you.
Here's a few links about it:
- Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB (2008/12/16)
- XtraDB benchmarks - 1.5X gain in IO-bound load (2008/12/18)
- XtraDB in CPU-bound benchmark (2008/12/18)
- XtraDB storage engine release 1.0.2-2 (New Year edition) (2008/12/29)
- Documentation: The Percona XtraDB Storage Engine
- Project page: Percona XtraDB Storage Engine for MySQL
Comments
This does sound like a
This does sound like a winner. I am also curious if folks have experimented with this.
Successfully using Percona in Drupal / Pressflow
We have been using Percona Server (which now incorporates the xtradb plug-in) as a drop-in replacement for mysql in a pressflow (from the Pantheon / Mercury Project ) drupal derivative site for more than six months. The site is hosted in an Amazon EC2, with four EBS disks in a RAID 0 configuration. We are not using one of the most important parts of the Pantheon stack, the Varnish cache, due to some cache issues we had and had not been able to resolve yet. The reason for not concentrating on getting Varnish up and running is that we achieved our goal of being within Google´s 20% Server Speed upper band (from Google Webmaster) just by implementing Percona. The site, http://www.organix.com is feature rich, with user registration (high writes) Recipe and Product information forwarding etc. It´s average visitors (not visits) per day range around 1,500, but we have had spikes of about 15,000 visitors per day (helped by some online advertising...) which were hardly noticed by the server!. Would recommend both Percona and Pressflow for High Performance sites without hesitating.