Data Archives - Software Engineering Daily

Hyperscaling SQL with Sam Lambert

Jul 4, 2024

Sam Lambert, CEO of PlanetScale, delves into the intricate world of database scaling, sharing insights from his journey in creating a highly scalable MySQL platform. He discusses the origins of PlanetScale and Vitesse, emphasizing the importance of efficient data management. Topics include challenges with hyperscaling MySQL, particularly cross-shard transactions, and the advantages of TESS in enhancing MySQL's scalability. Lambert also compares MySQL with Postgres, offering valuable takeaways for startups on choosing the right database solutions.

00:00

Creator website

Episode guests

Sam Lambert

AI Summary

AI Chapters

Episode notes

Podcast summary created with Snipd AI

Quick takeaways

The reliability and performance of databases like PlanetScale are vital for delivering seamless user experiences across various online platforms.

PlanetScale utilizes Vitesse for efficient SQL sharding, enabling real-time schema updates and enhancing database scalability without compromising availability.

Deep dives

The Importance of Reliable Databases

Reliable databases are crucial for ensuring seamless user experiences across various online platforms. High-performance and availability are essential, especially for large brands that depend on consistent database functionality to personalize user interactions. Any downtime or latency in the database can lead to a diminished user experience, highlighting the need for highly dependable database solutions. This underscores the importance of companies like PlanetScale, which prioritize performance and reliability to support data-driven applications.

Intro

3min

The Birth and Growth of PlanetScale and Vitesse

2min

Understanding TESS: The Open Database for Scalable MySQL Systems

2min

Challenges and Solutions in Hyperscaling with MySQL

3min

Exploring Data Sharding and Vitesse

9min

VITES and PlanetScale: Ensuring Reliability in D2C

6min

Navigating Planet-Scale Databases

18min

Database Dilemmas: MySQL vs. Postgres

4min

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.

Lee is the host of his podcast, Modern Digital Business, an engaging and informative podcast produced for people looking to build and grow their digital business with the help of modern applications and processes developed for today’s fast-moving business environment. Listen at mdb.fm. Follow Lee at softwarearchitectureinsights.com, and see all his content at leeatchison.com.

Please click here to see the transcript of this episode.

Sponsorship inquiries: sponsor@softwareengineeringdaily.com

The post Hyperscaling SQL with Sam Lambert appeared first on Software Engineering Daily.