… memory available, and memory is what really really matters. High-Memory Quadruple Extra Large Instance 68.4 GB of memory 26 EC2 Compute…, so that was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I made no code changes to iiBench, and used the version available…
Post: High availability for MySQL on Amazon EC2 - Part 1 - Intro
June 17, 2010 By 8 Comments
…, it is not easy to have a truly highly available solution for MySQL on EC2. If a MySQL instance fails, here are some challenges that… viable HA solution for MySQL on EC2. The goal is to have a cheap small instance monitor the availability of a large (any size) and taking measures to keep MySQL available. A few weeks later, I…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
…very well when you don’t need high concurrency from your MySQL database. When you do, the …the versions of MySQL that Amazon runs on RDS may not be the most advanced available. My benchmarks generally…there is not a huge performance difference between EC2+EBS+MySQL versus RDS, in most cases, unless …
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… propagate nodes. Why MySQL/MariaDB + Galera 0.8 is interesting? It allows to solve following problems: A Real High Availability solution for systems… provides a HA solution for MySQL setups in the Cloud. E.g. with current state of MySQL EC2 setups suffer from lacking a good HA schema. With Galera, we can setup replication with the same availability and…
Post: High availability for MySQL on Amazon EC2 - Part 6 - Publishing server location
February 16, 2011 By Leave a Comment
… posts of this series, we now have an HA MySQL service running on EC2. We now need to find a way to… to the HA MySQL service. Normally, in an HA setup, this is achieved using virtual IP addresses but EC2 does not support…) that publishes the IP address of a newly created MySQL server. MYSQL_IP=`ec2-describe-instances -K $PK -C $CERT $NEW_INSTANCE_ID…
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… the hostname like: [NDBD DEFAULT] NoOfReplicas=2 Datadir=/var/lib/mysql-cluster/ DataMemory=1G IndexMemory=100M [NDB_MGMD] Id=1 Hostname…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
… yves@yves-laptop:~$ ec2-add-group hamysql -d ‘nodes for HA MySQL solution’ GROUP hamysql nodes for HA MySQL solution From now, I’ll always assume the EC2_CERT and EC2_PRIVATE_KEY…-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
… the MySQL EC2 instance if running Make sure the MySQL EC2 instance is stopped Prepare the user-data script for the new MySQL EC2 instance Launch… Broadcast the new MySQL instance IP to the application servers Kill the MySQL EC2 instance In order to kill the existing MySQL EC2 instance, we…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
…) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers with EBS volumes (see… you get on normal EC2 servers with EBS. I benchmarked the largest available RDS instance, which is listed as “High-Memory Quadruple Extra… virtual cores with 3.25 ECUs each), 64-bit platform, High I/O Capacity.” I used sysbench’s oltp benchmark, with…
Post: High availability for MySQL on Amazon EC2 – Part 3 – Configuring the HA resources
July 12, 2010 By 4 Comments
… of this series, we now have two working EC2 instances that are EBS based. The first instance …away the resources On hamysql Run MySQL Monitor MySQL Get out of way if MySQL is not running From the …preferably run on hamysql but, if hamysql is not available, will be able to run on monitor. That’…
