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

Presented by:

2b60c925f64f0d73bf3f1c99ed8b4b84

Franck Pachot

from MongoDB

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

Happening at the same time:

  1. Building strategies for migrating different database systems to PostgreSQL
    2. Start Time:
    2023 February 22 09:00

    Room:
    Robusta

  2. Real time Analytics with PostgreSQL
    3. Start Time:
    2023 February 22 09:00

    Room:
    Arabica

  3. Mastering PostgreSQL Administration
    4. Start Time:
    2023 February 22 09:00

    Room:
    Grand Victoria 1