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.
Databases underpin almost every user experience on the web, but scaling a database is one of the most fundamental infrastructure challenges in software development. PlanetScale offers a MySQL platform that is managed and highly scaleable.
Sam Lambert is the CEO of PlanetScale and he joins the show to talk about why he started the platform, scaling databases, using Vitess for SQL shard orchestration, and more.
This episode is hosted by Lee Atchison. Lee Atchison is a software architect, author, and thought leader on cloud computing and application modernization. His best-selling book, Architecting for Scale (O’Reilly Media), is an essential resource for technical teams looking to maintain high availability and manage risk in their cloud environments.
The post Hyperscaling SQL with Sam Lambert appeared first on Software Engineering Daily.