… 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: 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: 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: 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: 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
Comment: Death match! EBS versus SSD price, performance, and QoS
February 22, 2011 By 54 Comments
… “I can only think of two options for you: leave EC2, or shard your database.” I don’t like either one… think they can stay on a single EC2 server for the database, and adding EBS volumes isn’t going to solve the… earlier comments, I need to evaluate RDS seriously. So perhaps EBS/EC2 isn’t the right option for them, but there is…
