Tagged articles

Patroni

7 articles · Page 1 of 1

Aug 10, 2026 · Databases

Build a High‑Availability PostgreSQL Cluster with Streaming Replication and Read‑Write Splitting from Scratch

This guide walks through the complete process of designing, configuring, and operating a PostgreSQL primary‑standby setup with streaming replication, choosing between asynchronous and synchronous modes, implementing read‑write splitting via application routing or PgBouncer, and handling monitoring, failover, and common pitfalls for production‑grade high availability.

PatroniPostgreSQLhigh availability

0 likes · 15 min read

Build a High‑Availability PostgreSQL Cluster with Streaming Replication and Read‑Write Splitting from Scratch

Hacker Afternoon Tea

Dec 5, 2023 · Databases

Building a Production‑Ready High‑Availability Sharded PostgreSQL Cluster with StackGres, Citus, and Patroni

This guide explains what a sharded PostgreSQL cluster is, how StackGres implements it with Citus and Patroni, and provides step‑by‑step YAML manifests and scripts to create both a basic and a custom production‑grade high‑availability sharded cluster on Kubernetes.

CitusKubernetesPatroni

0 likes · 10 min read

Building a Production‑Ready High‑Availability Sharded PostgreSQL Cluster with StackGres, Citus, and Patroni

Hacker Afternoon Tea

Dec 4, 2023 · Cloud Native

Managing StackGres 1.6 HA Clusters Fully with Patroni

This guide walks through identifying master and replica pods, performing graceful switchover, triggering automated failover, and reinitializing replicas in a StackGres 1.6 cluster using kubectl and patronictl commands, with practical notes and safety warnings.

FailoverHAKubernetes

0 likes · 10 min read

Managing StackGres 1.6 HA Clusters Fully with Patroni

Hacker Afternoon Tea

Apr 11, 2022 · Cloud Native

Introducing Zalando’s Postgres Operator: Infrastructure-as-Code for HA PostgreSQL on Kubernetes

The Zalando Postgres Operator enables easy deployment of high‑availability PostgreSQL clusters on Kubernetes using Patroni, managed entirely through CRDs, supporting rolling updates, sidecar monitoring, and seamless CI/CD integration without direct API calls.

HA PostgreSQLInfrastructure as CodeKubernetes

0 likes · 10 min read

Introducing Zalando’s Postgres Operator: Infrastructure-as-Code for HA PostgreSQL on Kubernetes

Qunar Tech Salon

Dec 1, 2021 · Databases

PostgreSQL High Availability (PGHA) at Qunar: Architecture, Customization, Testing, and Metrics

This article details Qunar's implementation of PostgreSQL high‑availability using Patroni, covering solution selection, custom DCS and failover mechanisms, operational impact, comprehensive testing procedures, performance metrics, and future directions for cross‑region HA deployment.

HA TestingMetricsPatroni

0 likes · 11 min read

PostgreSQL High Availability (PGHA) at Qunar: Architecture, Customization, Testing, and Metrics

360 Tech Engineering

Sep 9, 2021 · Databases

PostgreSQL High‑Availability Cluster Deployment with Patroni and Etcd

This article details the design, deployment, configuration, operation, monitoring, and backup of a PostgreSQL high‑availability cluster built on Patroni, Etcd, and LVS at 360, covering hardware layout, software versions, installation steps, parameter tuning, fail‑over testing, and future outlook.

ClusterPatroniPostgreSQL

0 likes · 16 min read

PostgreSQL High‑Availability Cluster Deployment with Patroni and Etcd

dbaplus Community

Dec 10, 2020 · Databases

How GitLab Achieved a Near-Perfect PostgreSQL 9.6→11 Upgrade

In May 2020 GitLab partnered with OnGres to upgrade a 12‑node PostgreSQL 9.6 cluster to version 11, using a carefully planned pg_upgrade process, automated Ansible playbooks, Patroni HA, and a detailed rollback strategy to keep a 6 TB dataset consistent while serving 300 k transactions per second.

AnsibleDatabase MigrationGitLab

0 likes · 16 min read

How GitLab Achieved a Near-Perfect PostgreSQL 9.6→11 Upgrade