Beyond 'gem install MySQL' in Ruby VMs: Alternative Drivers & Architecture

Ilya Grigorik (igvita.com)
Ruby and MySQL
Location: Ballroom E

There is much more to MySQL performance in Ruby than ‘gem install mysql’ and syntactic optimizations. Whether you are running Ruby MRI (C version), or JRuby (JVM), or any other Ruby VM, and are looking to optimize your performance architecture (response times or throughput), the architecture and the MySQL driver you choose (yes, there is more than one!) have significant influence on the outcome. Different VM’s expose different behaviors: native threads vs. green threads, a global interpreter lock (GIL) vs. no lock, and result in dramatically different behaviors under load.

In this talk we will look under the hood of the most popular Ruby VM’s and evaluate a number of alternative drivers (mysql gem, mysqlplus, evented-mysql, and others), which can help you significantly improve the performance and throughput of your Ruby+MySQL application.

This talk will assume basic knowledge of Ruby and MySQL, and will cover:

  • High-level architecture of the Ruby VM’s and performance impacts on MySQL
  • Analysis of the MySQL gem and its performance implications
  • Discussion on architecture implications in different popular Ruby VM’s
  • Evaluating alternative drivers: MySQLplus and event-driven MySQL
  • Hands on examples & code
Photo of Ilya Grigorik

Ilya Grigorik

igvita.com

Ilya Grigorik is the founder and CTO of PostRank, a real-time social engagement monitoring and analytics platform. He is an avid Ruby and web architecture blogger (www.igvita.com, twitter: @igrigorik), speaker, and a community evangelist.

  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Download the O'Reilly MySQL Conference & Expo Sponsor/ Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.