PostgreSQL HA With Patroni: Looking at Failure Scenarios and How the Cluster Recovers From Them

Fernando Laudares Camargos, and Jobin Augustine, presents "#PostgreSQL HA With Patroni: Looking at Failure Scenarios and How the Cluster Recovers From Them".

Over the last few years, Patroni has established itself as the main reference for #PostgreSQL High Availability and we are witnessing its adoption increase among our customers following this trend in popularity. It has not been, however, a straightforward journey for many of them: the robustness of the Patroni project was built on top of solid layers provided by different components and it is necessary to understand how they connect with each other and what happens when one of them "breaks".

Comment 💬, Share 🔗, Like 👍, and Subscribe ✅ to our channel 📺, and turn on the 🔔 to be alerted to new videos about #OpenSource #Databases... and many other things!

In this talk, we are going to review the most common failure scenarios and how Patroni recovers the PostgreSQL cluster in each of these cases. We'll also discuss the most common mistakes we have observed and how you can avoid these.

You can find more information about #PostgreSQL #Databases and Percona Database Events in these links 👇👇👇

Connect With us on our Social Networks 👇👇👇

[martingoodson]

This was a very interesting video and a very concise intro to Patroni. Thank you very much for publishing it.

[phreshprince]

This is great. Can you show what happens when a System ID mismatch occurs? I'm struggling to fix that.

[kombergman]

Very interesting video, well done. However, could you upload a version without the top bar which forces the presentation to not use all of the screen?

[malymohsem]

Hello, I am using ubuntu 20.04 LTS. Do I need to change the ownership of `/etc/patroni/config.yml` file from root user to postgres user ? Cause I am getting some sort of errors

[poojamayekar]

This video helps me to understand basics of patroni, However I am struggling with configuring logical replication with patroni. Can you redirect me for such live presentation on logical replication setup with patroni?

[deepaks]

Is watchdog installation is mandatory in patroni setup ?, also can we use anyother alternative tool for haproxy which support the same functionality

[cololabs]

Hey folks, I'm interested in reproducing this on my own, do you have the files in any public repo? Thanks!

[DipsaDishNDiaries]

how to setup the configuration in a way where,
if leader site crashes - (network / server restart) Leader should wait for x seconds before electing a new leader.

Where and which parameter is to configured ?

tried tweaking ttl in yml file but no luck so far,
it immediately switches over to another site

[rishidibban]

Hi,
I m facing below error. i tried all possibilities but no luck. i can able to etcd and even i can start patroni without error. but when i m trying to check patroni status it is throwing below error.

info = self._run_cycle()
File "/usr/lib/python3/dist-packages/patroni/ha.py", line 1266, in _run_cycle
return self.post_bootstrap()
File "/usr/lib/python3/dist-packages/patroni/ha.py", line 1163, in post_bootstrap
self.cancel_initialization()
File "/usr/lib/python3/dist-packages/patroni/ha.py", line 1158, in cancel_initialization
raise PatroniException('Failed to bootstrap cluster')
'Failed to bootstrap cluster'
patroni.service: Main process exited, code=exited, status=1/FAILURE
patroni.service: Failed with result 'exit-code'.