As a follow up to my previous post celebrating World Backup Day, I give you my MySQL LVM Snapshot script.
You can read more about the idea and its pluses and minuses here.
At each of our datacenters we have a MySQL slave dedicated to being a backup node.
It doesn’t take reads from applications servers, it just gets updates from it’s local master then makes a nightly LVM snapshot using a version of the script below.
(It is also running a second instance to backup our MogileFS MySQL instance using a modified version of the script too)
