Hefta-Gaub Development Blog

April 10, 2008

example master/slave on Ec2/S3

Filed under: Uncategorized — zappoman @ 9:18 pm

Great article from RightScale on an implementation of master/slave replication using Ec2/S3.

Not a lot of details, but a great high level explanation of what you want to accomplish.

Redundant MySQL set-up for Amazon EC2

What we’ve built is a mysql master/slave set-up with backup to Amazon S3. The set-up consists of one mysql master server which is the primary database server used by the application. We assume it runs on its own EC2 instance but it could probably share the instance with the application. We install LVM (linux volume manager) on the /mnt partition and place the database files there. We use LVM snapshots to back up the database to S3, this means that we get a consistent backup of the database files with only a sub-second hiccup to the database.



  1. Thanks for commenting on my blog entry on the Manager for MySQL. Amazon just announced storage volumes for EC2 which makes MySQL even more interesting on EC2. I wrote about how it changes the game at http://blog.rightscale.com/2008/04/13/
    The Amazon folks are on a roll!

    With the addition of the storage volumes there’s no doubt in my mind anymore: the cloud adopters will have much more computing horsepower and flexibility at their fingertips than those who are still racking their own machines. Cloud computing is going to be as significant for deployment as agile is for software development. You either compute in the cloud or you’ll be left behind by your competitors because they can deploy faster, better, and cheaper than you can.

    Comment by TvE — April 14, 2008 @ 7:28 am

  2. Hi, on occasion I see a 404 website message when I browse your website. Just a heads up, best wishes

    Comment by Lerv — May 10, 2017 @ 12:50 pm

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: