{"repo":"gocardless/stolon-pgbouncer","free":true,"listed":false,"github":"https://github.com/gocardless/stolon-pgbouncer","clone":"git clone https://github.com/gocardless/stolon-pgbouncer.git","description":"Add-on to stolon for providing zero-downtime failover and PgBouncer integration","language":"Go","stars":66,"topics":["postgresql","stolon","pgbouncer","team-core-infrastructure","archive-no","tier-1"],"license":"MIT","category":"databases-storage","readme_excerpt":"stolon-pgbouncer stolon-pgbouncer extends a stolon PostgreSQL setup with PgBouncer connection pooling and zero-downtime planned failover of the PostgreSQL primary. See Playground for how to start a Dockerised three node stolon PostgreSQL cluster utilising stolon-pgbouncer. - Overview - Stolon Recap - Playground - Node Roles - Postgres - Proxy - Zero-Downtime Failover - Development - Testing - Images - Releasing Overview stolon is a tool for running highly available Postgres clusters. stolon aims to recover from node failures and ensure data durability across your cluster. stolon-pgbouncer extends stolon with first class support for PgBouncer, a Postgres connection pooler. By introducing PgBouncer, it's possible to offer zero-downtime planned failovers of Postgres primaries, allowing users to perform maintenance operations without taking downtime. Live information about cluster health is maintained by stolon in a consistent data store such as etcd. stolon-pgbouncer runs two services that use this data to work with the cluster: - supervise manages PgBouncer processes to proxy connections to the currently elected Postgres primary - pauser exposes an API that can perform zero-downtime failover by pausing PgBouncer traffic Both these services are commands on the stolon-pgbouncer binary, with a third command called failover which speaks with the pauser API. Stolon Recap This README assumes familiarity with stolon and associated tooling that can be acquired by reading the stolon doc","default_branch":null,"files":null,"tree":[],"storefront":"/r/gocardless","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/gocardless/stolon-pgbouncer/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}