Simon Willison’s Weblog

MySQL backups with EBS snapshots. Assaf Arkin’s 45 line ruby script shows how to lock tables / XFS freeze / create an EBS snapshot / unfreeze and unlock, with hourly snapshots preserved for the past 24 hours and daily snapshots for the past week. Is an EBS snapshot enough to restore your data to somewhere other than EC2 though?

Posted 13th October 2009 at 12:34 pm

Tagged assafarkin, backups, cloud, ebs, ec2, mysql, ruby

5 comments

1. Use snapshot to create a volume
2. Mount volume to new EC2 instance
3. Run a script to dump it elsewhere (mysqldump, scp, rsync etc)
4. Terminate instance
5. Discard volume

You pay for bandwidth and uptime (instance and volume). Starting an EC2 instance to run a task is second nature in AWS land where instances are plenty and disposable.

Assaf - 14th October 2009 01:21 - #
Just cause it's simple doesn't mean it's not super hlpeful.

Mahaley - 16th August 2011 03:40 - #
Normally I'm against killing but this article slauhgetred my ignorance.

Tike - 10th October 2011 05:06 - #
I will recommend my friends to read this. Bottes UGGI am quite sure they will UGG Pas Cher learn lots of new stuff here than anybody else!
ugg pas cher - 29th October 2011 02:56 - #
Excellent read, I just passed this onto a colleague who was doing a little research on that. And he actually bought me lunch because I found it for him smile So let me rephrase that: Thanks for lunch! Benches
Groundless - 1st November 2011 06:47 - #

Comments are closed.