… EC2 instance type that I used. EC2 Configuration I chose m2.4xlarge instance as that’s the instance type with highest memory available, and memory is what really really matters. High-Memory Quadruple Extra Large Instance 68.4 GB of memory 26 EC2 Compute Units (8 virtual cores with 3.25 EC2 Compute…
Post: High availability for MySQL on Amazon EC2 - Part 1 - Intro
June 17, 2010 By 8 Comments
… too good to be true. Amazon has also some drawbacks, availability is not guaranteed and discovery protocols relying on Ethernet broadcast…, it is not easy to have a truly highly available solution for MySQL on EC2. If a MySQL instance fails, here are some… HA solution for MySQL on EC2. The goal is to have a cheap small instance monitor the availability of a large (any…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…-laptop:~$ ec2-describe-images ami-1cdf3775 IMAGE ami-1cdf3775 099720109477/ubuntu-images-testing/ubuntu-lucid-daily-i386-server-20100618 099720109477 available public i386 machine aki-aca44cc5 instance-store So, lauching 2 of these, yves@yves-laptop:~$ ec2-run-instances…
Post: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script
August 19, 2010 By 6 Comments
… 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 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: How to replace a NDB node on EC2
June 9, 2011 By 10 Comments
… solution in term of high availability since there are no single point of failure. In an environment like EC2, where a node can… main issue we faced is that IPs are dynamic in EC2 so when an instance restarts, it gets a new IP…
Post: High availability for MySQL on Amazon EC2 – Part 3 – Configuring the HA resources
July 12, 2010 By 4 Comments
… the previous of this series, we now have two working EC2 instances that are EBS based. The first instance is the… will preferably run on hamysql but, if hamysql is not available, will be able to run on monitor. That’s the…
Post: High availability for MySQL on Amazon EC2 – Part 5 - The instance monitoring script
February 15, 2011 By 3 Comments
… mysqladmin to ping the database to see if it is available. If not, the recommended action is to stop the heartbeat…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… work very well when you don’t need high concurrency from your MySQL database. When you do, … for the money compared to building servers with EC2 and EBS. However, sometimes you might like more … your business needs, considering factors such as the availability of staff to manage the machines. On the …
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… is interesting? It allows to solve following problems: A Real High Availability solution for systems based on InnoDB/XtraDB. The recommended setup… of MySQL EC2 setups suffer from lacking a good HA schema. With Galera, we can setup replication with the same availability and in different zones. Remember the recent and famous EC2 outage? Having masters in USA…
