Migrating Yelp Reservations from PostgreSQL to MySQL

https://is1-ssl.mzstatic.com/image/thumb/Podcasts211/v4/67/c8/43/67c8430f-7e3e-bcba-4469-54787206cb90/mza_12433984773424099588.jpg/600x600bb.jpg

Code Impact

Sanket Makhija

72 episodes

5 days ago

Welcome to "Code Impact," the podcast where we explore code that has an impact. Each episode dives deep into real-world stories, practical case studies, and expert insights, showcasing the powerful impact of code on performance, accessibility, and user experience. Whether you're a seasoned developer or just starting your journey, "Code Impact" delivers the tools, tips, and inspiration you need to create meaningful and high-performing products. Join us as we uncover the ways coding is transforming industries and making a difference—one line at a time. NotebookLM creates all episodes.

Education

RSS

All content for Code Impact is the property of Sanket Makhija and is served directly from their servers with no modification, redirects, or rehosting. The podcast is not affiliated with or endorsed by Podjoint in any way.

Education

https://d3t3ozftmdmh3i.cloudfront.net/staging/podcast_uploaded_nologo/42227160/42227160-1728916697741-cd37329d2cc32.jpg

Migrating Yelp Reservations from PostgreSQL to MySQL

Code Impact

17 minutes 41 seconds

10 months ago

Migrating Yelp Reservations from PostgreSQL to MySQL

This blog post details Yelp's in-place migration of their Yelp Reservations service database from PostgreSQL to MySQL. The migration, necessitated by maintenance and expertise limitations with PostgreSQL, involved significant code refactoring to address unsupported features and ensure data consistency. A gradual rollout strategy, employing multi-DB support and careful synchronisation, was implemented to minimise disruption. The process revealed several unexpected challenges, including issues with auto-incrementing keys and ProxySQL memory usage, highlighting the complexities of such large-scale database migrations. Ultimately, the switch to the company standard MySQL improved performance and maintainability.