Distributed SQL Transactions

Explore the intricacies of distributed SQL transactions and two-phase commits in this 37-minute conference talk from DevConf.CZ 2023. Join speaker Filip Sedlak as he guides you through the process of implementing distributed transactions over plain PostgreSQL, using a real-world example from Monitora, a worldwide media monitoring service. Gain insights into the challenges and solutions of sharding large SQL databases, and learn how to handle server failures and communication breakdowns. Discover the step-by-step approach to building a robust distributed transaction system, providing you with a deeper understanding of this complex topic through practical implementation.