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

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.