… for backups or required space is very small – created without good understanding on how much space do you need for undo. LVM Snapshot… undo location. The LVM Snapshots versioning is however different from database Multi Versioning because only one old version per snapshot is needed while… back to our question of space requirements for MySQL Backups using LVM. As you can see from the description above in theory this…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… No extra commercial tools as Innodb Hot Backup are required to perform backup. Are there any downsides ? Need to have snapshot campatibility – this is… be able to do atomic snapshot of many volumes. Lets speak a bit about how LVM and snapshotting in general works. Really there… to restore slaves as well and skip binary logs in your backup process. 7) Unmount filesystem umount /mnt/backup 
Remove snapshot: lvremove -f…
Post: Disaster: LVM Performance in Snapshot Mode
February 5, 2009 By 55 Comments
… experience the “performance shock” when LVM snapshot is created with greatly reduced capacity which when will improve as smaller number of pages actually…. Because of this behavior you may consider not starting backups instantly after LVM snapshot is creating but allowing it to settle a bit…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… this functionality is currently broken other somewhat similar functionality works as expected. Innodb during recovery also prints position in the MySQL… in other cases – for example when you’re taking LVM snapshot (for backup or to clone slave from the master) and can’t… stall if this lock is used. You can just take LVM Snapshot (assuming you’re only using Innodb tables and not touching…
Post: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
February 24, 2009 By 20 Comments
… as main backup solution for MySQL on Linux we have been using LVM snapshots. Performance concerns from performance critical envinronment caused us to do LVM performance research which showed horrible results forcing us to look at more performing alternatives. Innodb Hot Backup is a…
Comment: Disaster: LVM Performance in Snapshot Mode
February 6, 2009 By 55 Comments
LVM is not bad as what you thought. So as RAID 5. It is not a surprise to see the … files (<16k) creation, no much difference; For large files creation, LVM causes the speed drops from 1300000 to 900000. Random Read…. LVM‘s overhead doesn’t bother me too much and I use LVM snapshot to backup 200G databases. In the production, RAID 5 + LVM (IBM…
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 … my LVM snapshot script*, it also saves the binary log coordinates when the snapshot was taken and saves it into a file specified as… an advisable backup solution. If your server somehow blew up in flames, hardware problems or encounter and LVM bug, your snapshots are useless…
Comment: Using LVM for MySQL Backup and Replication Setup
August 18, 2011 By 53 Comments
… to pursue other avenues like lvm snapshot . So i can easily lock the mysql tables and take a lvm snapshot with lvcreate in a quick seconds and then release the mysql lock . Now that I have the snapshot of… and have analytics team to use it as long as they issues queries on tar backup on another volume it wont impact our…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…full LVM snapshots. LVM backup strategies can fail to delete snapshots after finishing, sometimes due to the backup script failing before completion. Additionally, LVM snapshots …stopped. Our plugins are structured to monitor as few things as possible, but as many as needed. Replication is one thing …
Post: LVM Configuration mistake to Avoid
July 9, 2008 By 10 Comments
… LVM undo space located on the internal drives so LVM and backup has less backup on the running system. As the system was configured creating snapshot…”. Volume groups in LVM live completely isolated life and you can’t use space from one volume group for snapshot for another. What should have done instead is creating single volume group and having RAID volumes as physical volumes…
