… for the duration of operation. You can also use Percona Xtrabackup, LVM or other database backup approach which does not relay on…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… only…. When we speak about Innodb tables and backup with Xtrabackup or LVM we do not really need it. What we need…
Post: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
February 24, 2009 By 20 Comments
…. Performance concerns from performance critical envinronment caused us to do LVM performance research which showed horrible results forcing us to look… copying. Source code will be posted to Xtrabackup Launchpad project (https://launchpad.net/percona-xtrabackup/) We call for more ideas you would…
Comment: Verifying backup integrity with CHECK TABLES
February 1, 2012 By 4 Comments
… even LVM can introduce problems.. though it is unlikely of course. In reality I believe checking backups taken with Percona Xtrabackup is… used region it would be unlikely to be repaired by Xtrabackup backup process.
Post: Improving InnoDB recovery time
July 7, 2009 By 12 Comments
… time to start. Also it affects restoring from backup (both LVM and xtrabackup / innobackup) In this is simple test, I do crash…! If it is stable it will go to XtraDB and XtraBackup.
Comment: Verifying backup integrity with CHECK TABLES
February 1, 2012 By 4 Comments
… is a file system snapshot (e.g. with LVM). The use of Xtrabackup or InnoDB Hot Backup is based on software which…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… take many forms. It can be you running backup through xtrabackup or LVM snapshot, RAID controller doing RAID validation, some centrally kicked…
Comment: Disaster: LVM Performance in Snapshot Mode
February 24, 2011 By 55 Comments
Hi Peter, the mk-table-checksum tool is something I already have in place in my replication concept. So good to see I’m on the right way there. I will take a look on xtrabackup as well and will compare it to the LVM solution. Restore time is the most important thing so far. Thank you all!
Comment: Disaster: LVM Performance in Snapshot Mode
February 24, 2011 By 55 Comments
… you’re using Innodb also check out xtrabackup it has lower overhead than LVM and it also has throttling you can use…
Post: An argument for not using mysqldump
November 8, 2010 By 24 Comments
… time to restore. If I restore from a raw backup (LVM snapshot, xtrabackup, innodb hot backup), it is very easy to model…
