… many years back. We wrote about it, other people from MySQL Community too. The situation did not get better, at least… with failed hard drive (and during rebuild stage), what overhead LVM takes for backup etc. It may be performance drop is… can be done without server restart with Innodb Plugin, Percona Server and MySQL 5.5. Note it might also be good to…
Post: Improving InnoDB recovery time
July 7, 2009 By 12 Comments
… LVM and xtrabackup / innobackup) In this is simple test, I do crash mysql during in-memory tpcc-mysql benchmark with 16 running threads. MySQL… XtraDB tree yet, it lives in http://bazaar.launchpad.net/~percona-dev/percona-xtradb/recovery-speed-hack/ tree. The patch by itself… InnoDB experts to review it: http://bazaar.launchpad.net/~percona-dev/percona-xtradb/recovery-speed-hack/revision/86 So your comments about…
Post: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 15 Comments
… I heard about Galera on Percona Performance Conference 2009, Seppo Jaakola was presenting “Galera: Multi-Master Synchronous MySQL Replication Clusters”. It was… nodes (“donor”). In next release Codership is going to support LVM snapshot and xtrabackup which will make the setup of new… recently, http://www.mysqlperformanceblog.com/2009/10/16/finding-your-mysql-high-availability-solution-%e2%80%93-the-questions/. I am…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 14 Comments
During preparation of Percona-XtraDB template to run in RightScale environment, I noticed that … get benefit from multi-threading IO in MySQL you need to use XtraDB or MySQL 5.4 ® However there may be small… may be tricky. But in this case you may consider LVM snapshots or XtraBackup
Comment: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
…I have an excellent backup solution that does not require LVM. It uses Maatkit for taking the backup quickly and …even a whole database. I will be releasing it at Percona‘s performance conference, but feel free to reach me … try this: http://jamescrisp.org/2007/12/09/automating-mysql-database-backups/
