… of Amazon EC2. Being able to launch new instances at will depending on the load, is almost too good to be true. Amazon has… easy to have a truly highly available solution for MySQL on EC2. If a MySQL instance fails, here are some challenges that we face… me if I could build a viable HA solution for MySQL on EC2. The goal is to have a cheap small instance monitor…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
I have been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting results that I wanted to… software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for… by query cache on write heavy workload. OK, so that was all about the configuration of the EC2 instance and MySQL. Now as…
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 servers… shared with the general usage of AWS as you get on normal EC2 servers with EBS. I benchmarked the largest available RDS… this series, we will see how the Amazon RDS instance performed at various thread counts on the OLTP benchmark. Update Vadim and…
Post: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… continuation of my series of benchmark posts comparing Amazon RDS to a server running on Amazon EC2. Upcoming posts (probably 6 or 8 in total) will extend the scope of the benchmark to include data on our… note that these are the results I achieved on this RDS server, from this EC2 “driver” machine, at this specific point in…
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 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…” 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 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
… assume you are using the command line api tools, on Ubuntu, install “ec2-api-tools”. The use of these tools simplifies the… 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…
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… the clients Give away the resources On hamysql Run MySQL Monitor MySQL Get out of way if MySQL is not running From the above… resources scripts On each host: root@monitor:~# touch /usr/local/bin/mysql root@monitor:~# chmod u+x /usr/local/bin/mysql We will…
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… copy of the cluster configuration on the Monitor node will be pulled back by the MySQL node and since this copy has… restart of the MySQL node, the instance restart script on the Monitor node will loop and restart again the MySQL node. Stopping the…
Post: Clarification on MySQL security vulnerability
June 19, 2012 By 2 Comments
…XtraDB Cluster binaries, similar to other MySQL variants, are susceptible to the security vulnerability in MySQL/MariaDB sql/password.c: 64bit … binaries are vulnerable in Percona Server ONLY on some hardware/virtualization platforms (confirmed on Amazon EC2 but not on HP Cloud). Neither older nor …
