Results Shatter Ruby on Rails Perceived Scalability Limitations on MySQL – Blue Box Launches Scalable Ruby on Rails Service Powered by Clustrix
SAN FRANCISCO, CA and NEW YORK, NY – Oct 2, 2012 – Clustrix, the scale out database for Big Data applications, and Blue Box, the leading provider of hosting services for Ruby on Rails applications, today announced a strategic partnership at Percona Live in New York. In conjunction, Clustrix and Blue Box also made public today the results of the first-ever comprehensive benchmark of Ruby on Rails implementations on MySQL and MySQL-compatible databases. The exciting benchmark results were delivered by Clustrix software development and test engineers Clayton Cole and Neil Harkins during their keynote presentation at Percona Live.
“This industry first benchmark demonstrates to developers that they can scale Rails 10X the expected limitations without pain using the scale-out database from Clustrix,” said Robin Purohit, CEO, Clustrix. “We are excited to partner with Blue Box to make it easy for Ruby on Rails developers to design or migrate their applications onto our database-as-a-service.”
Added Jesse Proudman, Blue Box CEO, “Not only were we able to achieve performance and scalability that is off the charts for the Ruby on Rails market, but this benchmark demonstrates that Rails is ideal for building the next generation of Web and mobile applications. And with Clustrix under the hood as our scale-out database, our customers have no worries about scale, performance and availability.”
About the Ruby on Rails Benchmark
Tacit Knowledge, a software engineering firm, along with Clustrix, designed and coded the benchmark’s application, which simulated an auction website with social media components. They implemented the schema within the Rails framework, then crafted 13 scenarios to demonstrate user interactions that would cause database operations—from simple INSERTs to multiple UPDATEs inside a transaction and JOINs.
Blue Box hosted the testing environment and supplied the MySQL server and client servers for the benchmark, and Percona, the largest independent MySQL support and consulting company, validated the MySQL server configuration used in the benchmark.
The initial data set size was 475 GB, to emulate a real-world production environment and to ensure the data set significantly exceeded total memory sizes. The benchmark used a mix of the different workload scenarios in a ratio of 52% reads to 48% writes, run at random with an equal probability of executing each scenario. Numbers of concurrent users (threads) were ramped up from one to well past 10,000.
Benchmark test results were captured in terms of Transactions Per Second (TPS) and in average scenario execution time (in whole seconds) for each of the three database setups observed (MySQL, three-node Clustrix, and six-node Clustrix). The application and test configuration parameters were unchanged from the MySQL setup to Clustrix’s MySQL drop-in replacement database.
At 1,024 concurrent users – around the point where an application or website is gaining popularity – the Rails application powered by a three-node Clustrix cluster executed 8X the observed TPS of standard MySQL, while the six-node cluster executed 15X MySQL’s observed TPS. (Actual TPS: 3,500 for MySQL, 29,000 for three-node cluster and 53,000 for a six-node cluster.) In addition, at 1024 concurrent users, transaction response times were 25X faster on the Clustrix configuration, averaging around 100 milliseconds compared to ~2.5 seconds on the MySQL setup.
About the Blue Box/Clustrix Partnership
The partnership between Clustrix and Blue Box includes the integration of the Clustrix Database-as-a-Service solution into Blue Box’s service using Ruby on Rails. The Blue Box scale-out Rails service, powered by the Clustrix Database-as-a-Service, is available now.
For more information on the scale-out Rails solution, please contact Blue Box at firstname.lastname@example.org or Clustrix at email@example.com.
In July, Clustrix released its high-performance SQL Database-as-a-Service (DBaaS), extending Clustrix’s scalability, performance and availability to the cloud. The Clustrix DBaaS introduces simple, transparent pricing with no meters or limits on transactions, data size or number of users.
About Blue Box
Blue Box, founded in 2003, is a leading provider of managed application hosting for platform and infrastructure solutions. Our clients receive white- glove 24/7 support through our industry-leading technical implementation and management expertise. With ownership and control of the infrastructure and full data location transparency, Blue Box delivers comprehensive hosting solutions with game-changing uptime to enterprises and applications of any size. To learn more about Blue Box, visit www.bluebox.net.