Migrating from MySQL to PostgreSQL

Talk Type: 
45 Minute Talk
Track: 
Migration
Technical Level: 
Beginner
License: 
BSD

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

Slides - http://www.pgrs.net/migrating_from_mysql_to_postgresql/index.html#1