… data in the each image is split into 20 “shards”. This blog post will refer to an EC2 instances as a node… using the AMI images You can easily test Shard-Query for yourself. Spin up the desired number of EC2 instances using on of the the AMI images. You should spin a number of…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
… MySQL solution From now, I’ll always assume the EC2_CERT and EC2_PRIVATE_KEY environment variables are setup in your shell… AMI seems ok. yves@yves-laptop:~$ ec2-describe-images ami-1cdf3775 IMAGE ami-1cdf3775 099720109477/ubuntu-images-testing/ubuntu-lucid-daily-i386-server-20100618… us-east-1c aki-aca44cc5 monitoring-disabled yves@yves-laptop:~$ ec2-describe-instances RESERVATION r-a29c31c9 834362721059 hamysql INSTANCE i-a23a21c9…
Post: XtraDB Amazon Image
October 25, 2009 By 9 Comments
… to use it. First make sure it is avaiable. $ ec2-describe-images ami-4701e22e IMAGE  ami-4701e22e   xtradb/centos…:06+0000 us-east-1c Wait till the instance starts $ ec2-describe-instances i-ecc74084 RESERVATION r-46b3432e 834362721059 default INSTANCE i-ecc74084 ami-4701e22e ec2-75-101-203-143.compute-1.amazonaws.com domU-12…
Post: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script
August 19, 2010 By 6 Comments
…’|’ -f3` if [ "$OLD_INSTANCE_ID" == "" ] then #no running instance : else ec2-terminate-instances -K $PK -C $CERT $OLD_INSTANCE_ID > /dev… instance” else done=”false” while [ $done == "false" ] do INSTANCE_INFO=`ec2-describe-instances -K $PK -C $CERT $NEW_INSTANCE_ID | /usr….d/ha.cf # to eventually be added to the ebs image sudo perl -pi -e ‘s/bind-address/#bind-address/g…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
…. I’ve had some clients hitting performance limitations on standard EC2 servers with EBS volumes (see SSD versus EBS death match… the general usage of AWS as you get on normal EC2 servers with EBS. I benchmarked the largest available RDS instance… the chart of rows inserted per minute (click on the image for a bigger view): We can deduce a few things…
