Tag Archives: MySQL

Amazon takes EC2 to the next level with persistent storage volumes

The Amazon folks have gone public today with the next EC2 feature: persistent storage. The official information is found in Jeff Barr’s blog entry and in Matt’s forum post. Calling the persistent storage a “feature” is actually quite an understatement, … Continue reading

Posted in AWS, Cloud Computing, EC2, MySQL | Tagged , , , | 34 Comments

MySQL performance on Amazon EC2

Spurred by Morgan Tocker I ran some sysbench MySQL performance benchmarks on EC2 instances. This is just the first round, more to follow… The set-up On a small instance, I reformatted /mnt with LVM2 and creates a 140GB xfs filesystem. … Continue reading

Posted in AWS, EC2 | Tagged , , , | 11 Comments

Deploying many Rails sites onto Amazon EC2

One of our customers is deploying many Rails sites onto EC2, more precisely, many instances of virtually the same site. Basically they have a Rails application and they tweak it for each individual site they set-up. EC2 is a wonderful … Continue reading

Posted in AWS, EC2 | Tagged , , , , | 1 Comment

Setting up site on EC2 with RightScale

The key to a successful site setup on Amazon EC2 is scalability and redundancy. RightScale makes this easy by providing server templates and multi-server deployments. To get started, let’s take the simplest case: a single server set-up. We have a … Continue reading

Posted in AWS, EC2 | Tagged , , , , | 2 Comments

Setting up MySQL with the RightScale MySQL Manager — part 1

Setting up a redundant MySQL master/slave database using RightScale has become rather easy using our recently introduced Manager for MySQL. Let’s start by setting up the master. For this we define a “MySQL master” server template. A server template is … Continue reading

Posted in MySQL | Tagged , , , | 1 Comment

Amazon EC2 changes how MySQL is used

Amazon EC2 will change the way MySQL is used: it suddenly opens a whole slew of new possibilities. What’s really exciting is that it can also simplify the management of MySQL which enables powerful automation as provided in the [RightScale … Continue reading

Posted in EC2, MySQL | Tagged , ,

Surviving a MySQL master DB crash

Nothing is more heart-arresting than to find out that your database machine has died. Site down. Data gone. Life s… That’s what happened to one of our customers yesterday morning, right when they were featured on some prominent sites. The … Continue reading

Posted in EC2, MySQL | Tagged , , | 2 Comments

Redundant MySQL set-up for Amazon EC2

In order to deploy web sites/services onto Amazon EC2 everyone needs the same components, and so we’re building them! One of the most requested and most critical pieces is a good database set-up, and mysql is clearly the highest in … Continue reading

Posted in AWS, EC2 | Tagged , , , , | 10 Comments