How Patroni works - With Animations and Failure scenarios ? #postgres #postgresql

Показать описание

How Patroni works - With Animations and Failure scenarios ? #postgres #postgresql

Patroni is best in the Postgres HA space

KloudDB

Рекомендации по теме

Комментарии

🎯 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

Taraval

🎯 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

Taraval

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

RajeshKumar-fcvk

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

ramazangok

How Patroni works - With Animations and Failure scenarios ? #postgres #postgresql

How Patroni works - With Animations and Failure scenarios ? #postgres #postgresql

Patroni PostgreSQL - Cluster Setup

Citus & Patroni: The Key to Scalable and Fault-Tolerant PostgreSQL | Citus Con 2023

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

Part01-PostgreSQL Patroni Cluster HA

Patroni HA PostgreSQL Made Easy

PostgreSQL Tutorial - 20 - Highly Available PostgreSQL Cluster using Patroni and HAProxy on Ubuntu

Integrating Patroni PostgreSQL with Kubernetes

Patroni for PostgreSQL- High availability with automatic failover management: Topics

ptor + patroni + haproxy

PostgreSQL High-Availability Done using the components - PostgreSQL, patroni , etcd and HAProxy

Atmosphere 2018: Oleksii Kliukin - POSTGRESQL HIGH AVAILABILITY ON KUBERNETES WITH PATRONI

Databases: PostgreSQL HA using HAProxy and Patroni

PostgreSQL (in the Patroni cluster with HAProxy) full and incremental backups with Wal-G

Haproxy postgresql with patroni

11TB WAL, pgec Writes, Patroni 3 & Citus, PostgREST | Scaling Postgres 256

Management of High-Availability PostgreSQL clusters with Patroni | A.Klyukin, A.Kukushkin

Patroni on GitLab.com / Jose Cores (Finotto GitLab Inc.)

Protecting your data with Patroni and pgBackRest | Federico Campoli | #IDI22

Patroni | Postgres.FM 117 | #PostgreSQL #Postgres podcast

Postgresql HA Kurulumu Patroni ile

Setting Up and Using Patroni to Automate Failover in PostgreSQL - PostgreSQL Patroni Tutorial

Patroni: Your HA Patron Saint

PGConfRu 2019 Andrey Fefelov «Postgres + patroni + consul + s3 + walg + ansible = Simple HA cluster»...