PGConf NYC 2021 - Chasing unicorns : 0 dataloss and 99.999% availability by Laetitia Avrot

Channel:
United States Confreaks
Subscribers:
42,400
Published on ● Video Link: https://www.youtube.com/watch?v=5we6o5DZkNg


Duration: 44:49
15 views
0

Chasing unicorns : 0 dataloss and 99.999% availability by Laetitia Avrot

If you're a database architect, you've already encountered the situation when you ask for RTO and RPO and people answer they don't want any data loss and downtime is not an option either.

If you discuss with people aware of the CAP theorem, they will temper their demands by asking for 99.999% availability, emphasizing they didn't ask for the impossible 100%...

In this conf talk, we'll explore the CAP and PACELC theorems, what they mean for RDBMS and what tradeoffs need to be made. Then we'll explore several practical use cases and we'll try to classify their data loss and availability.



Other Videos By Confreaks


2022-10-12PGConf NYC 2021 - Speaking and Community Involvement for the Introvert by Pat Wright
2022-10-12PGConf NYC 2021 - Get Your Insecure PostgreSQL Passwords to SCRAM! by Jonathan S. Katz
2022-10-12PGConf NYC 2021 - NORM: No ORM Framework by Henrietta Dombrovskaya
2022-10-12PGConf NYC 2021 - Navigate Postgres Cloud Paths: Kubernetes, IaaS, or DbaaS by Marc Linster
2022-10-12PGConf NYC 2021 - How we made PG Fitter, Happier, More Productive by Andrew Atkinson
2022-10-12PGConf NYC 2021 - War Stories: Fighting the PostreSQL Support Trenches by Hans Jurgen
2022-10-12PGConf NYC 2021 - Flexible Indexing with Postgres by Bruce Momjian
2022-10-12PGConf NYC 2021 - How PostgreSQL aggregates work and how to create and use custom... by David Kohn
2022-10-12PGConf NYC 2021 - A Deep Dive into PostgreSQL Indexing by Ibrar Ahmed
2022-10-12PGConf NYC 2021 - PostgreSQL sharding, state of the art by Julien Tachoires
2022-10-12PGConf NYC 2021 - Chasing unicorns : 0 dataloss and 99.999% availability by Laetitia Avrot
2022-10-12PGConf NYC 2021 - Evolution Of PostgreSQL Replication and High Availability... by Stacy Scoggins
2022-10-12PGConf NYC 2021 - Pglog: a flexible log analyser by Laetitia Avrot
2022-10-12PGConf NYC 2021 - When it all GOes right by Pavlo Golub
2022-10-12PGConf NYC 2021 - Data Security using Roles, Privileges and Row Level Security by Abbas Butt
2022-10-12PGConf NYC 2021 - Postgres and Json - How to get the best of them? by Charly Batista
2022-10-04EmberConf 2021 - Fun Fast Tools for Serious Work by Ed Faulkner
2022-10-04EmberConf 2021 - Fast-Track Ember with Fastboot + Embroider by Suchita Doshi and Thomas Wang
2022-10-04EmberConf 2021 - Modernizing a Massive Monolith by Aubrey Knudson
2022-10-04EmberConf 2021 - Ending the Plague of Memory Leaks by Steve Szczecina
2022-10-04EmberConf 2021 - Please wait… Oh, It Didn't Work! by Tobias Bieniek


Tags:
PostgreSQL
PGConf
Postgres