… 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…
Comment: How to calculate a good InnoDB log file size
April 24, 2012 By 33 Comments
What if the calculation above shows that I should have an innodb log file size of 1-2 MB? I’m running Percona server on an ec2 small instance with the XFS filesystem for the mysql data directory.
Comment: Percona XtraDB Cluster Feature 1: High Availability
April 15, 2012 By 18 Comments
In EC2 environment, a new node can be started from the EBS snapshot within 5-15 minutes. What needs to be done on that node to prepare it to join the cluster?
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 15, 2012 By 10 Comments
… some idea on what throughput increase we can expect considering EC2 and EBS constraints. Our company is working on adding NoSQL…
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 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 10 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: 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…
