Software Engineering Radio - the podcast for professional software developers SE Radio 560: Sugu Sougoumarane on Distributed SQL with Vitess
15 snips
Apr 19, 2023 Sugu Sougoumarane, co-creator of Vitess and CEO of PlanetScale, shares insights from his experience scaling MySQL at YouTube. He tackles the challenges of distributed SQL, explaining the importance of connection pooling and smart query parsing. Sugu dives into horizontal sharding and the complexities of topology management while detailing the innovative features of Vitess that simplify these processes. He also highlights the significance of durable consensus models, automated failover strategies, and PlanetScale's developer-friendly tools.
AI Snips
Chapters
Transcript
Episode notes
Connection Pooling Saved YouTube
- YouTube faced daily outages from uncontrolled DB connections and pooling solved it.
- Sugu and Solomon built Vitess as a middle layer to pool connections and reduce failover storms.
Build A Query Parser Early
- Write a SQL parser if you plan to mediate or rewrite queries in a proxy layer.
- Sugu credits building a parser as the decision that enabled Vitess to become a full distributed database.
Query Deduping Reduces Load
- Query deduping prevents identical heavy queries from causing repeated load.
- Vitess makes subsequent identical queries wait and share results instead of re-executing them.