This post originated from an RSS feed registered with Ruby Buzz by Paul Gross. Original Post: PgEast Talk Feed Title: Paul Gross's Blog - Home Feed URL: http://feeds.feedburner.com/pgrs Feed Description: Posts mainly about ruby on rails. Latest Ruby Buzz Posts Latest Ruby Buzz Posts by Paul Gross Latest Posts From Paul Gross's Blog - Home

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