Back to Browse

Exploring the Consistency-Availability-Partition (CAP) Theorem

412 views
May 27, 2023
51:29

If you're a Postgres expert, you've surely been asked to reach some objectives like Recovery Time Objective (how much disruption you can afford) and Recovery Point Objective (how much data you can lose). You might have also found yourself in the difficult situation of explaining to your boss that, even though you can reduce the risk of data loss or service disruption, there is no such thing as zero risk. On top of that, thanks to the Consistency-Availability-Partitioning (CAP) theorem and the PACELC (Partitioning-Availability-Consistency-Else-Latency-Consistency) theorem, reducing the risk of service disruption will imply a more complex architecture that can induce more latency and perhaps more data loss and vice versa. In this webinar, we explore the trade-offs that you need to make when drawing an architecture for a Relational Database Management System like PostgreSQL. We also conclude with some practical use cases, explaining the constraints, the problems and how we solve them. ---- For more #webinars​​​​​, visit https://okt.to/Oqwy0R Download #PostgreSQL​​​​​ whitepapers: https://okt.to/h4kdc6 Read our #Postgres​​​​​ Blog https://okt.to/W1aUlw Follow us on Facebook at https://okt.to/DGdKk8 Follow us on Twitter at https://okt.to/WESUi4 Follow us on LinkedIn at https://okt.to/3FEDYv Contact us via email at [email protected] #postgresql #database #opensource #dbms

Download

1 formats

Video Formats

360pmp467.6 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

Exploring the Consistency-Availability-Partition (CAP) Theorem | NatokHD