Combined SF MySQL & Ruby Meetup

This is a combined event with SF MySQL Meetup at CBS Interactive (formerly known as CNET). Thanks to Sarah Mei for hooking us up with Erin O'Neill of SF MySQL.

Agenda

6:30-7:00pm pizza, meet & greet
7:00pm announcements from organizers & audience
7:15pm Ian Kallen's talk


Scaling Rails with MySQL table partitioning by Ian Kallen

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.

Brief Bio:

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.