… MySQL, Pacemaker invokes a script to start (or restart) the EC2 instance running MySQL. This blog post describes the instance restart…’|’ -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…
Post: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script
August 19, 2010 By 6 Comments
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… wrote this, the following AMI seems ok. yves@yves-laptop:~$ ec2-describe-images ami-1cdf3775 IMAGE ami-1cdf3775 099720109477/ubuntu-images… us-east-1c aki-aca44cc5 monitoring-disabled yves@yves-laptop:~$ ec2-describe-instances RESERVATION r-a29c31c9 834362721059 hamysql INSTANCE i-a23a21c9…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… started a series of posts showing benchmark results on Amazon EC2 servers with RAID’ed EBS volumes and MySQL, versus RDS… to 12 is your effective ceiling in today’s largest EC2 instances. That is concurrency inside the database, not at the… bad value for the money compared to building servers with EC2 and EBS. However, sometimes you might like more control over…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
… been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting results that I wanted to… First of all let me describe the EC2 instance type that I used. EC2 Configuration I chose m2.4xlarge instance as that…. OK, so that was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… Shard-Query for yourself. Spin up the desired number of EC2 instances using on of the the AMI images. You should… set up the hosts file: sudo su – # cat hosts.internal | ~ec2-user/tools/mkhosts >> /etc/hosts # ping shard20 PING shard20 (10… terminated SQL statements. The queries for the benchmark are in ~ec2-user/shard-query/queries.sql. I have also provided a…
Post: High availability for MySQL on Amazon EC2 - Part 6 - Publishing server location
February 16, 2011 By Leave a Comment
… HA setup, this is achieved using virtual IP addresses but EC2 does not support virtual IPs. In addition, we can use… IP address of a newly created MySQL server. MYSQL_IP=`ec2-describe-instances -K $PK -C $CERT $NEW_INSTANCE_ID | /usr/local/bin/filtre_instances.pl | cut -d’|’ -f2` TMPFILE=`mktemp` ec2-describe-instances -K $PK -C $CERT | /usr/local/bin/filtre…
Post: High availability for MySQL on Amazon EC2 - Part 1 - Intro
June 17, 2010 By 8 Comments
… have been seduced by the power and flexibility of Amazon EC2. Being able to launch new instances at will depending on… to have a truly highly available solution for MySQL on EC2. If a MySQL instance fails, here are some challenges that… Heartbeat. The setup is fairly complex, being in the Amazon EC2 virtual world is not a simplification, far from. Because of…
Post: How to replace a NDB node on EC2
June 9, 2011 By 10 Comments
… are no single point of failure. In an environment like EC2, where a node can disappear almost without notice, one would… main issue we faced is that IPs are dynamic in EC2 so when an instance restarts, it gets a new IP…
Post: Dissection of EC2 / EBS volume
August 7, 2009 By 4 Comments
So during preparation of XtraDB template for EC2 I wanted to understand what IO characteristics we can expect … you may consider some RAID setup, see my previous post EC2/EBS single and RAID volumes IO benchmark
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 14 Comments
… environment, I noticed that IO performance on EBS volume in EC2 cloud is not quite perfect. So I have spent some… is that if you are looking for IO performance in EC2/EBS environment it’s definitely worth to consider some RAID…
