I have been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting results that I wanted… for benchmark purposes. OK, let’s start off with the configuration details. Configuration First of all let me describe the EC2 instance… all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I made no…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… while ago I started a series of posts showing benchmark results on Amazon EC2 servers with RAID’ed EBS volumes and MySQL… on RDS may not be the most advanced available. My benchmarks generally showed that I was not able to outstrip RDS… it is to Percona Server. I haven’t run extensive benchmarks against RDS 5.5, Percona Server 5.5, and MySQL…
Post: Dissection of EC2 / EBS volume
August 7, 2009 By 4 Comments
…, not RAID as in my previous post). Yasufumi did some benchmarks and pointed me on interesting behavior, there seems several level…. Let me show you. I did sysbench random read IO benchmark on files with size from 256M to 5GB with step… you may consider some RAID setup, see my previous post EC2/EBS single and RAID volumes IO benchmark
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 14 Comments
… performance on EBS volume in EC2 cloud is not quite perfect. So I have spent some time benchmarking volumes. Interesting part with… used xfs filesystem mounted with noatime,nobarrier options and for benchmark I used sysbench fileio modes on 16GB file with next… is that if you are looking for IO performance in EC2/EBS environment it’s definitely worth to consider some RAID…
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… not prepare publishable reports on all of the benchmarks I ran. While running the benchmarks, I gathered many gigabytes of performance and…
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… more semicolon terminated SQL statements. The queries for the benchmark are in ~ec2-user/shard-query/queries.sql. I have also provided…
Post: Sharing an auto_increment value across multiple MySQL tables (revisited)
October 26, 2010 By 7 Comments
… this. I just got around to benchmarking those alternatives today across two large EC2 machines: (Measured in transactions/second – higher is…, but with a MyISAM table — it suffers a little because EC2 can be a little high for latency, and there’s…
Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
… against each other. Test Environment The test environment included AWS EC2 nodes in US-East and US-West (Oregon). The ping… may be improvable by some Galera tuning. UPDATE: latency between EC2 nodes, even within the same availability zone seems to average…
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… in memory. Here is a graph for the tpcc-mysql benchmark (100W ~ 10GB of data, 12G innodb_buffer_pool_size, 1G… systems where I/O capacity may vary a lot, like EC2 systems, or is affected by periodic tasks like backup or…
Post: Sharing an auto_increment value across multiple MySQL tables
October 4, 2010 By 9 Comments
… second). To start with a naive test, I booted two EC2 small instances in the same availability zone. Ping times are…
