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.

Database operationsHA TestingMetrics

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.

BackupClusterPatroni

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.

AnsibleGitLabHA

0 likes · 16 min read

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