First Enterprise Application to Prove MySQL Supports Immense Scale

JAVAONE?San Francisco, Calif. - News Release:

• Today at JavaOne, Hyperic (Booth #1028), announced the results of a large scale performance study on Hyperic using Sun Microsystems? MySQL database as a backend.
• Results showed Hyperic monitoring upwards of 2.3 million metric transactions per minute.
• These results definitively prove that MySQL and Hyperic can be a compelling option for even the most demanding enterprise and web applications.
• Hyperic customer CNET was part of large-scale beta testing of MySQL on Hyperic.

About the tests:

• The tests simulated a large-scale deployment monitoring 32,000 services across 675 discreet managed platforms.
• There were two primary tests?designed to determine the actual and maximum loads amount of metrics per minute that Hyperic is capable of running on MySQL.
  • In the Actual Load test, Hyperic HQ averaged 220,000 metrics per minute, with minimal server load for either Hyperic HQ or MySQL.
  • In the Maximum Load test, Hyperic HQ achieved a record 2.3 million metrics per minute, with constraints on the Hyperic Server and only moderate load on MySQL.

• The test setup used standard hardware that would typically be used to run Hyperic HQ with MySQL
  • The Hyperic HQ Server ran on a 2 Quad Core, 2GHz machine with 16 GB of RAM, 4 GB of Heap and a NIC with a 1 GB interconnect between HQ and MySQL
  • The MySQL Database Server ran on a 2 Quad Core, 1596 MHz machine with 8 GB of RAM, 4.5 GB InnoDB buffer pool, 16 thread concurrency, O_DSYNC flush method, and RAID-1 146G SAS 3G HardDrives

Supporting Quotes:

“For growing web-driven companies, scaling their web applications is critical to their business. Traffic is unpredictable and can grow exponentially. Operations teams must not only monitor every component of their application stack, but quickly respond if things go wrong. These performance results prove that the combination of Hyperic and MySQL is a good fit for companies that need a massively scalable web infrastructure.? — Paul Melmon, senior vice president of engineering at Hyperic

?MySQL has been designed and optimized to handle the fast-growth and high-traffic requirements of today?s modern online applications. As Hyperic is also targeting this same Web audience, there is a natural synergy between our products. MySQL and Hyperic address enterprise-level needs for performance, scalability, availability and reliability.? –Zack Urlocker, vice president of products, Sun Microsystems Database Group

“Support for MySQL has proven to be a major win for Hyperic customers by offering a scalable, enterprise class data store with the array of features they demand to handle reliable backup, archive, and disaster recovery of the highly valuable data Hyperic HQ captures. Since the official release in late January, we’ve had about a quarter of our Enterprise customers either migrate or express interest in migrating to MySQL as a database backend.” –Marty Messer, director of customer success at Hyperic

Supporting resources:

MySQL Performance study

More about Hyperic HQMore on MySQL?s new 5.1 version

More about JavaOne

Hyperic?s History with MySQL

I’m going to be at beCamp 2008, the followup to the first beCamp, which I sadly missed.

beCamp is a BarCamp un-conference. Tonight was about meeting, greeting, and throwing ideas at the wall to see which ones stick. Literally. We stuck pieces of paper on the wall with our ideas — things we can either talk about or want to hear about — and then scratched our votes on them to see which are popular.

I live and breathe MySQL for a decent part of the day, so I hesitated, but then stuck “MySQL Performance” on the wall. It got quite a few votes, so I assume will be giving a talk on MySQL performance basics at some point during the conference. (The exact schedule is probably being determined right now, in my absence, but I’m so tired right now that I’ll just take my chances on it not being at 8:00 AM tomorrow.) [edit: I just checked the website and there won’t be anything before 9:00, and the schedule is determined tomorrow. I did say I’m tired, right?]

See you there!

PS: if you want to meet some of my colleagues from my former employer, the Rimm-Kaufman Group, they’ll be there too, wearing the “We’re Hiring” t-shirts. They’re hiring, by the way.

Steve Souders has some more rules for us, as he announces a new book that he is working on. His preliminary view of the chapters are:

1. Split the initial payload
2. Load scripts without blocking
3. Don’t scatter scripts
4. Split dominant content domains
5. Make static content cookie-free
6. Reduce cookie weight
7. Minify CSS
8. Optimize images
9. Use iframes sparingly
10. To www or not to www

Steve has a call out to the community on thoughts for rules that you would like to see him cover:

The book should be out in early 2009. As I continue my research on web performance here at Google I’ll come up with another 5-10 rules to include. But I also wanted to ask you for suggested rules. What do you think is the performance killer for your web app? Better yet, what performance best practices have you discovered? For example, I think 3rd party rich media (Flash and JavaScript) ads are the long pole in the tent for many sites, and knowing the best way to embed widgets is growing more and more important.

I got to sit down with Steve to discuss the Cuzillion tool that we posted on last week. Steve talks about the project, and then walks us through a screencast showing how he found a problem with Orkut, and solved it.

At the 2008 MySQL User Conference and Expo, Phil Hildebrand spoke on "Applied Partitioning and Scaling Your Database System". Download the slides, see people's notes, and more on the MySQL Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008WednesdayNotes#Applied_Partitioning_and_Scaling_Your_Database_System.

At the 2008 MySQL User Conference and Expo, Farhan Mashraqi spoke about "Optimizing MySQL and InnoDB on Solaris 10 for World's Largest Photo Blogging Community". Download the slides, see people's notes, and more on the MySQL Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008ThursdayNotes#Optimizing_MySQL_and_InnoDB_on_Solaris_10_for_World.27s_Largest_Photo_Blogging_Community

At the 2008 MySQL User Conference and Expo, Robert Hodges spoke on "Portable Scale-out Benchmarks for MySQL". Download slides and see links to blog postings at the MySQL Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008WednesdayNotes#Portable_Scale-out_Benchmarks_for_MySQL

At the 2008 MySQL User Conference and Expo, Domas Mituzas gave a workshop on "Practical MySQL for Web Applications".

At the 2008 MySQL Users Conference and Expo, Lars Thalmann and Mats Kindahl gave a tutorial on replication. Download the slides and see blog posts others have written about the tutorial from the Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008MondayNotes#MySQL_Replication_Tutorial.

If you'd like to download the WMV video file in parts, here's a link to:
Part 1, 175.27 Mb
and

read more