Tricky Database Interview Question?
Database Design: Zero-Downtime Schema Migrations at Scale!
Zero-downtime schema migration on a 300 million row table, done while users read and write to it 24/7.
The obvious move is to add the column and update every row in one go. On a live table that locks huge numbers of rows, and suddenly every user request is stuck waiting on you. There's a staged way to do the exact same change without the database ever going offline, and it hinges on what you fix first.
We walk through it in under 3 minutes.
#SystemDesign #Databases #SoftwareArchitecture #DevOps #PostgreSQL #MySQL #BackendDevelopment #Scalability #TechTips #Coding
Zero-downtime schema migration on a 300 million row table, done while users read and write to it 24/7.
The obvious move is to add the column and update every row in one go. On a live table that locks huge numbers of rows, and suddenly every user request is stuck waiting on you. There's a staged way to do the exact same change without the database ever going offline, and it hinges on what you fix first.
We walk through it in under 3 minutes.
#SystemDesign #Databases #SoftwareArchitecture #DevOps #PostgreSQL #MySQL #BackendDevelopment #Scalability #TechTips #Coding
KodeKloud
...