… overview of these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn’t… performance improvements I saw versus stock MySQL 5.1. This leads me to a second unverifiable speculation, that Amazon RDS‘s version of MySQL… line is that there is not a huge performance difference between EC2+EBS+MySQL versus RDS, in most cases, unless you use Percona…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
… output of iostat.) I would characterize this as very good performance. Sub-millisecond latencies to disk, pretty much consistently, for reads…’s look at the performance of sdj1 over the entire sample period: #ts device rd_mb_s rd_cnc rd_rt wr_mb_s… a quarter of a second sometimes. This is causing acute performance problems for the database, manifested as epic stalls and server…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
…’s Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers… is not very revealing. To understand the sustained write performance of an RDS instance, we need a multi-threaded long-term insert… post in this series, we will see how the Amazon RDS instance performed at various thread counts on the OLTP benchmark. Update…
Post: Percona Welcomes MySQL 5.6!
February 25, 2013 By Leave a Comment
…RDS for MySQL, Drizzle, and Oracle MySQL, MySQL 5.6 is fully supported by our MySQL Consulting, MySQL Support, MySQL Server Development, and MySQL Remote DBA teams: Our MySQL…customers’ MySQL 5.6 test and production environments, and address any performance issues that might arise. Our MySQL …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… goal was to compare performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings… cache enabled, single thread performance improvement is marginal however WB cache brings single thread random write performance close to what 8 threads… running side by side: Aligned: #ts device rd_s rd_avkb rd_mb_s rd_mrg rd_cnc rd_rt wr_s wr_avkb wr_mb…
Post: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… a continuation of my series of benchmark posts comparing Amazon RDS to a server running on Amazon EC2. Upcoming posts (probably… long-term benchmark and see how the instance performed over time. Can it sustain performance over a several-day period of intense… ran. While running the benchmarks, I gathered many gigabytes of performance and diagnostic metrics, and ensuring that it is ready to…
Post: Percona and the MariaDB Foundation
December 19, 2012 By 3 Comments
…. We support all variants and flavors of “MySQL” – Oracle MySQL, MariaDB, Drizzle, Percona Server, Amazon RDS – helping our customers to be successful with… users to get the best performance and lowest downtime possible. We focus on compatibility with Oracle MySQL, High Quality, and small but…
Comment: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… the EC2 High Performance Cluster Compute instance type? http://aws.amazon.com/ec2/hpc-applications/ Not available for RDS (yet) but this would look to be a good path to optimize MySQL performance for in the amazon…
Comment: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… the EC2 High Performance Cluster Compute instance type? http://aws.amazon.com/ec2/hpc-applications/ Not available for RDS (yet) but this would look to be a good path to optimize MySQL performance for in the amazon…
Comment: Death match! EBS versus SSD price, performance, and QoS
February 22, 2011 By 55 Comments
We were seeing similar things and then just for fun tried out Amazon RDS. You don’t get access to the disks but we saw MySQL performance go up by about 10x on a simple large import (Went from ~3hrs to ~14 minutes).
