DDL Schema Migrations: Navigating the High-Scale Seas
Presented by:
Saraj Munjal
Saraj Munjal is a Senior Software Engineer at Robinhood, where he is a part of the amazing Storage Platform team. He has been diving deep into the Postgres ecosystem and fighting schema migrations over the past 3+ years. Before joining Robinhood, he worked on Firebase Realtime Database at Google, helping power seamless, real-time data for millions of users. In a past life, he also built large-scale Android apps for the Indian market and worked as a backend engineer at a startup.
Outside of the tech world, Saraj is an ardent Arsenal fan and loves embracing the outdoors, whether hiking, paddleboarding, or taking in the beauty of the Pacific Northwest.
No video of the event yet, sorry!
Schema migrations (DDL statements) can be a rough journey, especially when dealing with high-scale, always-online microservices. In this talk, we will:
- Explore the common pitfalls and failure modes when modifying Postgres tables - locking and backwards-incompatibility
- Share real-world examples from large-scale systems with minimal downtime
- Dive into the strategies and solutions we’ve developed to sail smoothly through these challenges
Whether you've faced these exact issues or are simply curious about safe schema migrations, this talk will equip you with the knowledge to navigate these tricky waters.
- Date:
- 2024 November 6 15:00 PST
- Duration:
- 50 min
- Room:
- Dev: 422
- Conference:
- Seattle 2024
- Language:
- Track:
- Dev
- Difficulty:
- Medium