Sharding and Scalability with TESS and MySQL

2min Snip

00:00

Play full episode

Summary

Transcript

Episode notes

TESS is an open-source backend that acts as a proxy and cluster manager for MySQL, enabling sharding of databases across thousands of servers for increased data storage, availability, and compute power. Sharding is a proven pattern for scaling large systems, making it easier to manage large database workloads. TESS is a layer of abstraction on top of standard MySQL, providing shard orchestration while maintaining mostly compatibility with MySQL, removing non-scalable features and introducing enhancements for scalability in the future.

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.