TLDR Web Dev · ARTICLES & TUTORIALS
MIGRATING IN-PLACE FROM POSTGRESQL TO MYSQL
Summary from the TLDR Web Dev newsletter
Yelp Reservations, acquired in 2013, was originally built with a PostgreSQL database. Recently, the service was migrated in-place to a Yelp-standard MySQL database. This involved overcoming challenges like data consistency, handling PostgreSQL-specific features, and managing the release process with minimal service disruption.