Distributed SQL: Why and How? (with PostgreSQL-compatible YugabyteDB)
Presented by:

Franck Pachot
Franck is a Developer Advocate at MongoDB, formerly at YugabyteDB (distributed PostgreSQL). With a long experience in database consulting for development and operations teams and a passion for enhancing developer experience, data modeling, and performance troubleshooting, Franck holds several certifications, including Oracle Certified Master and MongoDB Certified Associate Data Modeler, and he is recognized as an AWS Data Hero.
No video of the event yet, sorry!
In this training, you will learn the limitations of monolithic PostgreSQL for High Availability and get insights on the future of databases in a cloud-native environment with sharding, distribution, and replication. The training will cover:
Introduction and concepts
- High Availability with PostgreSQL (Streaming replication, Patroni)
- RPO, RTO, Split Brain, Data Loss beyond marketing slides
- The need to scale-out (AWS Aurora, CitusDB)
- Distributed SQL (Spanner, CockroachDB, YugabyteDB)
- Weaknesses of PostgreSQL storage layer (bloat, XID wraparound, MVCC, WAL)
An example with YugabyteDB
- A demo of High Availability and Elasticity
- What is the same and what is different with PostgreSQL
- Open Source model, how to contribute
- Why another database rather than an extension
- Considerations for geo-distribution (Latency, Leader/Follower placement)
Conclusions
- Do you need to scale-out?
- What means cloud-native? Serverless?
- Which database for which use-case?
- Date:
- 2023 February 22 - 09:00
- Duration:
- 3 h 30 min
- Room:
- Grand Victoria 2
- Conference:
- PGConf India, 2023
- Language:
- Track:
- Training
- Difficulty:
- Medium
- Building strategies for migrating different database systems to PostgreSQL
- Start Time:
- 2023 February 22 09:00
- Room:
- Robusta
- Real time Analytics with PostgreSQL
- Start Time:
- 2023 February 22 09:00
- Room:
- Arabica
- Mastering PostgreSQL Administration
- Start Time:
- 2023 February 22 09:00
- Room:
- Grand Victoria 1