Devconf.cz 2023

Let’s say you’re in a data-heavy business with a large SQL database. Like we are in Monitora, building a worldwide media monitoring service. You’re thinking about sharding your database. But what are the drawbacks and how will it actually work?

If you want to truly understand something, try to build a prototype. I'll guide you through distributed transactions and two-phase commits as you would implement them over plain PostgreSQL. We’ll see what happens when servers die or simply stop talking to each other and we’ll build our solution step by step.