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)
As you may have seen from previous posts, my wife has a book out and as a loving husband and obsessive computer nerd I wrote a script to aggregate and graph The Boneshaker’s Amazon Bestsellers Rank.
Sure, it needs more work and the Amazon Rank doesn’t take into account sales at other outlets… but, what can you do?