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

Presented by:

2b60c925f64f0d73bf3f1c99ed8b4b84

Franck Pachot

from Yugabyte

Developer Advocate for YugabyteDB, distributed SQL database using PostgreSQL for the query layer. Franck has a passion for learning and sharing in blog posts (blog.pachot.net), articles, conferences and tech communities (AWS Data Hero and Oracle ACE Director)

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