> The LVM Backup or other snapshot suggested is to ensure the state of files is atomic. Yep, that’s exactly what I meant. So the tool would have to work with LVM snapshots, correct? Just wondering.
Comment: Living with backups
November 6, 2008 By 28 Comments
…’re using LVM for your backups though you need to issue: FLUSH TABLES WITH READLOCK prior to taking the snapshot. That operation… for a 60 second outage every time we do an LVM snapshot.
Comment: Estimating Undo Space needed for LVM Snapshot
June 11, 2008 By 5 Comments
… look for more table storage) but it definitely allows mysql snapshots to be a lot smaller. “”" When I was running important… space. We were also doing LVM snapshots to back up our dbs, but we were using LVM 1, and wrote our own script…
Comment: Using LVM for MySQL Backup and Replication Setup
September 14, 2007 By 53 Comments
I’ve tried to backup my database with LVM Snapshot, but some terrible problems came to me~~~ 
Here is my … /mnt/data ~~copy some data to /mnt/data modprobe dm-snapshot lvcreate -L30M -s -ndbsnap /dev/dbvolgrp/dbvol ~~write some data… /mnt/data ~~copy some data to /mnt/data modprobe dm-snapshot lvcreate -L10G -s -ndbsnap /dev/dbvolgrp/dbvol ~~write some data…
Comment: An argument for not using mysqldump
November 18, 2010 By 26 Comments
Andy, other challenge I’ve run into with LVM snapshots is that they really load up the disk subsystem. While … that SAN snaps work great (very low cost), but that LVM snaps are too intrusive on the production servers for regular… the slaves nightly and the masters weekly since doing an LVM snap on a busy database will grind it down too…
Comment: Using LVM for MySQL Backup and Replication Setup
August 31, 2007 By 53 Comments
[...] google LVM if it’s new to you, then check out the following: MySQL Performance Blog – Using LVM for MySQL Backup and Replication setup Mike Krukenberg’s blog – MySQL Backups using LVM Snapshots nixcraft – Consistent backup with [...]
Comment: Using LVM for MySQL Backup and Replication Setup
August 27, 2007 By 53 Comments
[...] google LVM if it’s new to you, then check out the following: MySQL Performance Blog – Using LVM for MySQL Backup and Replication setup Mike Krukenberg’s blog – MySQL Backups using LVM Snapshots nixcraft – Consistent backup with [...]
Comment: Disaster: LVM Performance in Snapshot Mode
February 24, 2011 By 55 Comments
… mysql database with around 150G of data. After some reading LVM snapshots was my first choice as I can’t afford longer… thread, so for now I’m quite sceptic. Once the snapshot would be taken, the DB would need to go right… afford any performance loss while taking the backup of the snapshot. So I guess the only thing helping me out would…
Comment: Why you can't rely on a replica for disaster recovery
August 5, 2010 By 25 Comments
… low-level replication schemes. I second that backing up by “snapshotting” a hot innodb db works. You just let the copy… of your database. I don’t use “snapshots” per se. My experience with LVM snapshots has been disappointing in terms of performance. I…
Comment: Disaster: LVM Performance in Snapshot Mode
February 6, 2009 By 55 Comments
… multiple snapshots are active at the same time? I wonder why the Linux LVM snapshot implementation performs so badly in comparison to ZFS snapshots…
