…) the existing production load can affect your results. Testing on EC2 (+EBS) is no exception, although you can easily spin up…. Lastly, although if you are upgrading your hardware alongside your MySQL version, you should also consider running these tests on similar… 10% variation is tolerable and can be accounted for other MySQL overhead like network latency. pt-upgrade provides valuable insight on…
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 15, 2012 By 11 Comments
… some idea on what throughput increase we can expect considering EC2 and EBS constraints. Our company is working on adding NoSQL… is now exclusively based on Percona’s MySQL server. The more we can extract from MySQL without relegating to the extremely limiting…
Comment: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script
August 19, 2010 By 6 Comments
If you look in the Pacemaker configuration here:http://www.mysqlperformanceblog.com/2010/07/12/high-availability-for-mysql-on-amazon-ec2-%E2%80%93-part-3-%E2%80%93-configuring-the-ha-resources/ You’ll see that you can define the path. The current config points to /usr/local/bin/mysql.
Comment: Caching could be the last thing you want to do
July 24, 2010 By 14 Comments
… out of the box was doing 300+ queries to MySQL. On EC2 each query was taking up to a few ms, and… total pages in ~50ms. I told them me helping tune MySQL queries was like asking “how do I make the speed…
Comment: How to calculate a good InnoDB log file size
April 24, 2012 By 38 Comments
What if the calculation above shows that I should have an innodb log file size of 1-2 MB? I’m running Percona server on an ec2 small instance with the XFS filesystem for the mysql data directory.
Comment: EC2/EBS single and RAID volumes IO benchmark
July 24, 2011 By 14 Comments
… snapshot. ec2-consistent-snapshot from Alestic supports the XFS freeze/unfreeze methodology with a FLUSH TABLES WITH READ LOCK or MySQL shutdown.
Comment: Death match! EBS versus SSD price, performance, and QoS
February 22, 2011 By 55 Comments
… tearing down web servers relevant in determining whether to use EC2 for database servers? With respect to setting up and tearing… get a few tens of slaves to replicate from a MySQL master. And EBS snapshots are probably a great way to…
Post: Announcing Training for Operations Teams
August 18, 2010 By 3 Comments
… InnoDB topics. A new Operations Day – covering how to maintain MySQL in production. Our developer course has also undergone revision, and… teams, and given a series of challenges to complete on EC2 machines. As part of the development of this course…
