… of Amazon EC2. Being able to launch new instances at will depending on the load, is almost too good to be true. Amazon has… on Ethernet broadcast or multicast cannot be used. That means, it is not easy to have a truly highly available solution for MySQL on EC2. If a MySQL… build a viable 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 6 - Publishing server location
February 16, 2011 By Leave a Comment
… MySQL service running on EC2. We now need to find a way to point the web servers or application servers 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: High availability for MySQL on Amazon EC2 – Part 5 - The instance monitoring script
February 15, 2011 By 3 Comments
… is the Pacemaker script that run on the MySQL instance. First, this script is optional…MySQL host, let’s take it. At minimum, let’s use mysqladmin to ping the database to see if it is available…bin/bash MYSQLUSER=monitor MYSQLPASS=apassword #Give time for MySQL to start if it need recovery sleep …
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
… the command line api tools, on Ubuntu, install “ec2-api-tools”. The use of …for HA MySQL solution’ GROUP hamysql nodes for HA MySQL solution From now, I’ll always assume the EC2_CERT and EC2…available public i386 machine aki-aca44cc5 instance-store So, lauching 2 of these, yves@yves-laptop:~$ ec2…
Post: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script
August 19, 2010 By 6 Comments
… 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 the new MySQL…” else sleep 5 fi done Reconfigure local heartbeat Now, Heartbeat, on the monitoring host, must be informed of the IP address…
Post: High availability for MySQL on Amazon EC2 – Part 3 – Configuring the HA resources
July 12, 2010 By 4 Comments
…, we now have two working EC2 instances that are EBS based. …for the resources scripts On each host: root@monitor:~# touch /usr/local/bin/mysql root@monitor:~# chmod u+x /usr/local/bin/mysql…on hamysql but, if hamysql is not available, will be able to run on monitor. That’s the basis we will expand on…
Post: High availability for MySQL on Amazon EC2 - Part 5 - The instance monitoring script
October 22, 2010 By Leave a Comment
… cover in this post is the monitoring script that run on the MySQL node. At its smallest expression, the instance monitoring script… | /bin/mail -s ” MySQL database down, forcing failover” $EMAIL /etc/init.d/heartbeat stop exit fi fi done For the ones that… setting the host affinity for the resource to INFINITY for the Monitor node. When the resource is moved, the MySQL node is restarted…
Comment: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script
August 19, 2010 By 6 Comments
If you look in the Pacemaker configuration here:http://www.mysqlperformanceblog.com/2010/07/12/high-availability-for-mysql-on-amazon-ec2-%E2%80%93-part-3-%E2%80%93-configuring-the-ha-resources/ You’ll see that you can define the path. The current config points to /usr/local/bin/mysql.
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
…for a customer benchmarking insert performance on Amazon EC2…MySQL. Now as far as the benchmark itself is concerned, I made no code changes to iiBench, and used the version available…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
Amazon‘s Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2…on normal EC2 servers with EBS. I benchmarked the largest available RDS instance, which is listed as “High…per minute (click on the image for a bigger view…
