… just too useful for backups (most apply also for btrfs). Let’s review them. Snapshots ZFS does snapshot, like LVM but… since it is a copy on write filesystem, the snapshots are free, no performance… hundreds of snapshots. With LVM, your IO performance drops to 33% after the first snapshot so keeping a large number of snapshots running is…
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… undo location. The LVM Snapshots versioning is however different from database Multi Versioning because only one old version per snapshot is needed while…
Post: Disaster: LVM Performance in Snapshot Mode
February 5, 2009 By 55 Comments
… The performance without LVM snapshot was 159 io/sec which is quite expected for single thread and no BBU. With LVM snapshot enabled the… this run I got approximately 200 ios/sec without LVM snapshot enabled while with snapshot I got: 33.20 Requests/sec executed 46…. Because of this behavior you may consider not starting backups instantly after LVM snapshot is creating but allowing it to settle a bit…
Post: LVM Configuration mistake to Avoid
July 9, 2008 By 10 Comments
… would make sense to have 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 with 100G…”. Volume groups in LVM live completely isolated life and you can’t use space from one volume group for snapshot for another…
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 performance research which showed horrible results forcing us to look at more performing alternatives. Innodb Hot Backup is a…
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…’d loose the ability to do “online schema change” or LVM snapshot backup. And finally we were not able to get a descent…
Comment: Disaster: LVM Performance in Snapshot Mode
February 24, 2011 By 55 Comments
Thank you LenZ. That’s what I have already in place. I kust wanted to confirm LVM snapshot backup is still the way to go for large scale mysql databases.
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… snapshot based MySQL backups are great ? There are number of reasons: Almost Hot backup In most cases you can perform this type of backup… be able to do atomic snapshot of many volumes. Lets speak a bit about how LVM and snapshotting in general works. Really there… and skip binary logs in your backup process. 7) Unmount filesystem umount /mnt/backup 8) Remove snapshot: lvremove -f /dev/Main/dbbackup If…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
LVM snapshots is one powerful way of taking a consistent backup of your MySQL databases – but did you know that you … above. If you use my LVM snapshot script*, it also saves the binary log coordinates when the snapshot was taken and saves it… 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… TB , one way to use this snapshot is to mount the snapshot and take a backup of 1tb data say tar which again…
