…two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and… performance improvements I got with Percona Server were similar to the performance improvements I saw versus stock MySQL …write activity, you need to plan to shard from the beginning. That’s just …
Post: Friends of Percona Get 20% Off at the MySQL Conference!
February 24, 2011 By 5 Comments
…MySQL Performance Problems (Monday Tutorial) Percona Server: secret features MySQL and SSD: Usage Patterns Achieving PCI Compliance with MySQL The Aspersa System Administrator’s Toolkit Percona…
Post: Percona's Sessions at the O'Reilly MySQL Conference and Expo
April 7, 2011 By Leave a Comment
…MySQL Performance Problems (Monday Tutorial) Percona Server: secret features MySQL and SSD: Usage Patterns Achieving PCI Compliance with MySQL The Aspersa System Administrator’s Toolkit Percona…
Post: Distributed set processing performance analysis with ICE 3.5.2pl1 at 20 nodes.
May 14, 2011 By Leave a Comment
… set processing performance Shard-Query + ICE scales very well up to at least 20 nodes This post is a detailed performance analysis of…” which describes the distributed set processing technique. Also, remember that Percona can help you get up and running using these tools… this, but it requires further investigation. Next I compared the performance of 20 m1.large machines cold, versus hot. I did…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…shard-query-innodb-demo-64bit x86_64 Percona Server 5.5.11 with XtraDB. Requires m1.large or larger. ami-f65ea19f shard… to 2010′; mysql> use ontime1; Database changed mysql> show table status …shards (adjust to your number of nodes) php genconfig 20 > shards.ini Running the test For best performance…
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
Preparing Choosing Storage Systems for MySQL talk for Percona Live in Washington,DC I ran into great paper called … lot better performance with multiple MySQL instances on powerful storage. When you move to multiple instances and you have to “shard” your data… between MySQL and Oracle deployments, yet as MySQL is getting better and better handling large scale systems (both in terms of performance and…
Post: Percona Server Scales Vertically with Virident tachIOn Drives
February 28, 2011 By Leave a Comment
… reference architecture: buy flash storage first, shard as a last resort. From the summary: The sharding approach that has been advocated for… I/O performance, exemplified by the Virident tachIOn drive. “Scaling up” is once again a viable and economical strategy for MySQL, and…
Post: Presentations Announcement: 2010 O'Reilly MySQL Conference & Expo
April 29, 2010 By 4 Comments
…MySQL Author: Peter Zaitsev Diagnosing and Fixing MySQL Performance Problems Author: Baron Schwartz, Morgan Tocker EXPLAIN Demystified Author: Baron Schwartz HA Solutions for MySQL…MySQL Graphing and Trending with Cacti Author: Baron Schwartz Percona‘s Performance and Feature Enhancements to MySQL…
Post: Percona sessions at the MySQL conference
March 15, 2010 By 6 Comments
Many Percona employees will be at the 2010 MySQL conference. We’ll be giving a lot of informative technical … Tocker, Baron Schwartz: Diagnosing and Fixing MySQL Performance Problems Peter Zaitsev: Scaling Applications with Caching, Sharding and Replication Baron Schwartz: EXPLAIN Demystified Vadim…
Post: Finding an optimal balance of I/O, CPU, and RAM for MySQL
May 16, 2011 By 4 Comments
…, to decrease the price-to-performance ratio and increase the utilization of the tachIOn drive, Vadim sharded the database into smaller instances…. You can read the full details in our Scaling MySQL With Virident Flash Drives and Multiple Instances of Percona Server white paper.
