PGConfRu2019 Alexander Kukushkin - «How not to screw up when building HA cluster»

PGConfRu2019 Alexander Kukushkin - «How not to screw up when building HA cluster»
You just set up your first PostgreSQL cluster, created a database schema, loaded some data, did some fine tuning of configuration. Now you want to make your cluster highly available. Unfortunately, PostgreSQL doesn't offer built-in automatic failover, but luckily for us, there are plenty of external tools for that. As a next logical step you start choosing a tool, and... you already doing it wrong, because first you have to define SLA, RTO, and RPO. In this talk I am going to cover most of the common mistakes people do when setting up a highly available cluster.
Alexander Kukushkin, Zalando SE, Database Engineer
Talk page: pgconf.ru/en/2019/242294
#PGConfRu #PostgreSQL #Postgres #DBMS