AI-powered
podcast player
Listen to all your favourite podcasts with AI-powered features
18min chapter
Hyperscaling SQL with Sam Lambert
Software Engineering Daily
Scaling Databases and Managing Schema Changes
The chapter delves into the importance of sharding in scaling SQL databases for different use cases like ecommerce stores and analytics companies. It discusses the challenges faced in sharding due to varying read-to-write ratios in applications, emphasizing the efficiency of sharding for workloads with higher write operations and how it enables scaling by distributing write operations across multiple nodes. The conversation also explores the challenges of making schema changes in databases at a large scale and introduces a tool called Ghost for deploying schema changes online without downtime.
00:00
Transcript
Episode notes
Get the Snipd
podcast app
Unlock the knowledge in podcasts with the podcast player of the future.
AI-powered
Discover
highlights
Listen to the best highlights from the podcasts you love and dive into the full episode
Save any
moment
Hear something you like? Tap your headphones to save it with AI-generated key takeaways
Share
& Export
Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more
AI-powered
podcast player
Listen to all your favourite podcasts with AI-powered features
Discover
highlights
Listen to the best highlights from the podcasts you love and dive into the full episode