Ian Kallen joins this MySQL/Ruby meetup to talk about table partitioning implemented in Rails.

Managing the size of fast-growing tables provides unique challenges. MySQL 5.1 supports table partitioning that works well with InnoDB but the limitations on primary keys and unique constraints can make it a showstopper. For instance, Ruby on Rails applications typically use integer primary keys which will often conflict with the desired partitioning criteria. This talk will cover the capabilities and limitations of MySQL's table partitioning and how time-oriented partitioning can be implemented for Rails models.

About Ian Kallen:
Ian Kallen is a software and systems architect from San Francisco. He has worked on a variety of web services and packaged software products at Technorati, Covalent Technologies, Salon.com and Gamespot. Most recently, he's been working as a consultant with early stage start-ups running Rails and MySQL on Amazon's cloud providing code development, integration, infrastructure and technology strategy.

Agenda:
6:30 - 7:00 -- Doors open/general socializing & food provided by Percona
7:00 - 7:15 -- Intro/announcements
7:15 - 8:00(ish) -- Main presentation by Ian Kallen
8:00 - 9:00 -- Main presentation Q&A
9:00 - 10:00 -- General discussion/Q&A/networking/etc.
10:00ish -- post-event socializing... aka beers someplace nearby