… The performance without LVM snapshot was 159 io/sec which is quite expected for single thread and no BBU. With LVM snapshot enabled the… still astonishing. The final run I did is emulating how Innodb would do buffer pool flushes – calling fsync every 100 writes…. Because of this behavior you may consider not starting backups instantly after LVM snapshot is creating but allowing it to settle a bit…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… for backups or required space is very small – created without good understanding on how much space do you need for undo. LVM Snapshot works kind of like Multi Versioning in Innodb – when you write the new data… anyway. However DO place Innodb Log Files on the same LVM volume as you need them to be snapshoted at the same time…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… extra commercial tools as Innodb Hot Backup are required to perform backup. Are there any downsides ? Need to have snapshot campatibility – this is obvious… be able to do atomic snapshot of many volumes. Lets speak a bit about how LVM and snapshotting in general works. Really there…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
LVM snapshots is one powerful way of taking a consistent backup of your MySQL databases – but did you know that you … repositories i.e. updates on CentOS. If you are using InnoDB, it is also important that your transaction logs (ib_logfile… above. If you use my LVM snapshot script*, it also saves the binary log coordinates when the snapshot was taken and saves it…
Post: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
February 24, 2009 By 20 Comments
… main backup solution for MySQL on Linux we have been using LVM snapshots. Performance concerns from performance critical envinronment caused us to do LVM… tool, which will use same backup approach as InnoDB Hot Backup, that is taking online copy of InnoDB table files and transactional logs. This…
Post: Thoughs on Innodb Incremental Backups
November 10, 2008 By 8 Comments
For normal Innodb “hot” backups we use LVM or other snapshot based technologies with pretty good success. However having incremental backups remain the problem. First… do much better with Innodb in Particular. The Innodb pages have great deal of information helpful for their incremental backup in their internal…
Post: An argument for not using mysqldump
November 8, 2010 By 24 Comments
… a 5G mysqldump which takes 30 minutes to restore from backup. That means that when the database reaches 50G, it… from a raw backup (LVM snapshot, xtrabackup, innodb hot backup), it is very easy to model how much longer recovery time will take: Backup is 80G…
Comment: MySQL Replication vs DRBD Battles
April 29, 2008 By 12 Comments
… up all pros and cons. I would add another point: Backup from slave / secondary. With DRBD this is hard / impossible in… lag, 100% sure all transactions are there, no need to backup this database). The main database is configured in Master-Master… do “online schema change” or LVM snapshot backup. And finally we were not able to get a descent InnoDB recovery time (26G buffer pool…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… LVM snapshots. LVM backup strategies can fail to delete snapshots after finishing, sometimes due to the backup script failing before completion. Additionally, LVM snapshots …The pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such as contention …
Comment: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
… OK: LVM, XFS filesystem with InnoDB. We simply create an LVM snapshot and then do a file copy. Sure, it means that InnoDB has to recover itself from a half-way state if the backup is restored, but it’s… question if anyone has any insight please: LVM snapshots have been indicated as severely affecting InnoDB performance – however someone on a thread in…
