How Patroni works - With Animations and Failure scenarios ?

[@Taraval68]

🎯 Key Takeaways for quick navigation:
03:35 🤖 Patroni handles node failures and failovers internally.
04:19 🛡️ A demonstration of simulating a primary node failure and leader election in Patroni.
07:28 💼 How to perform a planned leader switch-over in Patroni.
09:22 🤖 Introduction to etcd commands for Patroni configuration and monitoring.
Made with HARPA AI

[@Taraval68]

🎯 Key Takeaways for quick navigation:
00:01 🤖 Introduction to Patroni and its reliance on DCS (etcd)
- Patroni is a Python-based bot used in PostgreSQL clustering.
- Patroni relies on a Distributed Configuration Store (DCS), like etcd, for coordination and leader election.
03:35 🛡️ Overview of Node Failure and Failover in Patroni
- When the primary node fails, a new leader election process is triggered.
- Replicas check the status of other nodes, and the one with the least replication lag becomes the new leader.
04:19 💼 Demonstration of Node Failure and Leader Election
- The TTL of the leader key counts down, and the first replica to acquire it becomes the new leader.
- Demonstrates the leader election process when the primary node fails.
07:28 🛡️ Planned Leader Switch Over in Patroni
- Shows how to manually switch the leader in a planned maintenance scenario.
- Node 1 is promoted as the new leader using the "switch over" option.
09:22 🤖 Introduction to etcd Commands
- Introduction to etcd commands used for Patroni configuration and monitoring.
- Demonstrates commands like "get leader key value," "get configuration," and "get member details."
Made with HARPA AI

[@ramazangok6633]

I'am issuing same etcdctl command to get kay-value, but nothing returning. What can be problem

[@RajeshKumar-fc9vk]

Do i have to take a downtime during switchover if i randomly wanted to switch one node and remove it