PgEast Talk

 Uncategorized  Comments Off
Mar 152011
 

I’m giving a talk at the PgEast conference next week in NYC titled Migrating from MySQL to PostgreSQL.

This talk will cover how Braintree migrated our credit card payment gateway, a Ruby on Rails application with millions of rows of data, from MySQL to PostgreSQL. The talk will be in three main parts:

  1. Why we decided to switch and the benefits of PostgreSQL over MySQL
  2. The tools and process we used to cut over with only a couple of minutes of downtime
  3. The aftermath of the switch, rewriting parts of our code, and optimizing our application for PostgreSQL