… 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… As for the IO configuration I chose 8 x 200G EBS volumes in software RAID 10. Now let’s come to…
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 (AWS…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn’t always great in comparison to what you can… bad value for the money compared to building servers with EC2 and EBS. However, sometimes you might like more control over it… is that there is not a huge performance difference between EC2+EBS+MySQL versus RDS, in most cases, unless you use Percona…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 13 Comments
… in RightScale environment, I noticed that IO performance on EBS volume in EC2 cloud is not quite perfect. So I have spent some time benchmarking volumes. Interesting part with EBS volumes is that… is that if you are looking for IO performance in EC2/EBS environment it’s definitely worth to consider some RAID setup…
Post: Dissection of EC2 / EBS volume
August 7, 2009 By 4 Comments
… preparation of XtraDB template for EC2 I wanted to understand what IO characteristics we can expect from EBS volume ( I am speaking… on interesting behavior, there seems several level of caching on EBS volume. Let me show you. I did sysbench random read… you may consider some RAID setup, see my previous post EC2/EBS single and RAID volumes IO benchmark
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… us-east-1c aki-aca44cc5 monitoring-disabled yves@yves-laptop:~$ ec2-describe-instances RESERVATION r-a29c31c9 834362721059 hamysql INSTANCE i-a23a21c9… followed this one: http://www.capsunlock.net/2009/12/create-ebs-boot-ami.html Upcoming in part 3, the configuration of…
Post: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script
August 19, 2010 By 6 Comments
…/local/bin/update_client.sh AMI_HA_MYSQL=ami-84a74fed EBS_DATA_VOL=vol-aefawf USER_DATA_SCRIPT=/usr/local/bin…’|’ -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: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
… extra large EC2 server (currently priced at $2/hour for a non-reserved instance) with a software RAID10 array of EBS volumes…’ll show are from an array of 10 x 100GB EBS volumes. EBS currently lists at $0.10 per GB-month of… up as sky-high latency spikes in New Relic. Suddenly EC2 doesn’t seem like such a good deal for this…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… greater. snap-073b6e68 shard-query-demo-data-flatfiles 30GB ext3 EBS This is an ext3 volume which contains the flat files… 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…
