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:
- Why we decided to switch and the benefits of PostgreSQL over MySQL
- The tools and process we used to cut over with only a couple of minutes of downtime
- The aftermath of the switch, rewriting parts of our code, and optimizing our application for PostgreSQL