How One Engineer Migrated 50 Million Users Without Downtime
from The Software Engineering Podcast with Fexingo: Code, Architecture, and Engineering Best Practices Hosted by Fexingo
In this episode of The Software Engineering Podcast, Lucas and Luna dive into the story of a senior engineer at a major social platform who orchestrated a database migration of 50 million user accounts from a legacy sharded MySQL setup to a distributed NewSQL system — all while maintaining 99.99 percent uptime. The migration, code-named 'Project Sequoia,' took 18 months of planning, involved a custom dual-write proxy layer, and required coordinating over 200 microservices. Lucas breaks down the key architectural decisions: why they chose a gradual 'shadow read' phase, how they handled data consistency conflicts, and the rollback strategy that saved them during a near-catastrophe on migration night. Luna asks the tough questions about engineering culture, testing at scale, and what the team learned about human error in distributed systems. If you're a software engineer or architect thinking about your next big migration, this episode delivers real-world lessons from a battle-tested team. #DatabaseMigration #SoftwareEngineering #DistributedSystems #NewSQL #MySQL #EngineeringCulture #SiteReliabilityEngineering #MigrationStrategy #Scalability #Uptime #TechPodcast #EngineeringPodcast #Technology #SoftwareDevelopment #ProductionEngineering #FexingoBusiness #BusinessPodcast #Podcast Keep every episode free: buymeacoffee.com/fexingo
Embed this episode
No transcript yet.