I have been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting results that I wanted… cores with 3.25 EC2 Compute Units each) 1690 GB of instance storage 64-bit platform I/O Performance: High API name…, so that was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… of these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn’t always great… performance with the combination of stock MySQL 5.1, EC2, and a 10-volume EBS RAID. However, I was able to get better performance… bottom line is that there is not a huge performance difference between EC2+EBS+MySQL versus RDS, in most cases, unless you use…
Post: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script
August 19, 2010 By 6 Comments
… script has to perform (the full script is given below). Kill 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…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… or database About the cluster For best performance, there should be an even data distribution … data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’… hosts file: sudo su – # cat hosts.internal | ~ec2-user/tools/mkhosts >> /etc/hosts # ping shard20 …
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… provides a HA solution for MySQL setups in the Cloud. E.g. with current state of MySQL EC2 setups suffer from lacking a… much more complex than an average MySQL master-slave setup. Potential performance penalty: Although to have performance numbers I am going to run… is seriously behind InnoDB-plugin in terms of features and performance. Update (6-Jun-2011): It was my misunderstanding: Galera does…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers with EBS volumes (see… workload is not very revealing. To understand the sustained write performance of an RDS instance, we need a multi-threaded long… this series, we will see how the Amazon RDS instance performed at various thread counts on the OLTP benchmark. Update Vadim…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
… output of iostat.) I would characterize this as very good performance. Sub-millisecond latencies to disk, pretty much consistently, for reads… in the Amazon cloud. It’s a quadruple extra large EC2 server (currently priced at $2/hour for a non-reserved… a quarter of a second sometimes. This is causing acute performance problems for the database, manifested as epic stalls and server…
Post: How to replace a NDB node on EC2
June 9, 2011 By 10 Comments
…single point of failure. In an environment like EC2, where a node can disappear almost without notice… change the IP in the cluster config and perform an rolling restart! no? In fact this …like: [NDBD DEFAULT] NoOfReplicas=2 Datadir=/var/lib/mysql-cluster/ DataMemory=1G IndexMemory=100M [NDB_MGMD] …
Post: Distributed set processing performance analysis with ICE 3.5.2pl1 at 20 nodes.
May 14, 2011 By Leave a Comment
… to at least 20 nodes This post is a detailed performance analysis of what I’ve coined “distributed set processing”. Please… world environment. There is a slight performance oddity at 16 nodes. I suspect the EC2 environment is the reason for this, but it requires further investigation. Next I compared the performance of 20 m1…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… with different result and performance regressions when performance (in a broad sense) is negatively affected. In general even minor MySQL version upgrade can… quickly. This especially makes sense for cloud environments as Amazon EC2 where it is easy and inexpensive to temporary get extra…
