stolon
patroni
Our great sponsors
| stolon | patroni | |
|---|---|---|
| 6 | 16 | |
| 4,182 | 5,486 | |
| 0.5% | 1.6% | |
| 0.0 | 9.3 | |
| about 2 months ago | 5 days ago | |
| Go | Python | |
| Apache License 2.0 | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
stolon
patroni
-
Docker: Patroni + HAProxy + Etcd + PgBouncer
Hello. I am currently using this docker-compose model from Zalando repository. It does not include PgBouncer in its architecture by default. I've been trying to find a containerized implementation involving Patroni, HAProxy, Etcd and PgBouncer. I didn't find anything solid so far.
-
Can someone share experience configuring Highly Available PgSQL?
General purpose: Patroni - Set up your own etcd + HAProxy + Patroni + Postgres components and it'll generally manage itself after that.
- Any self hostable postgres clustering, replication and fail over system?
-
GCP Cloud SQL Migration without outage?
This is why I always recommend using a postgres proxy so you can point it to different database servers as you stand them up. AWS does this by default but GCP doesn’t yet, so you have to have your own Postgres proxy (e.g https://github.com/CrunchyData/crunchy-proxy) or move to an HA Postgres setup like Patroni that has streaming replication (https://github.com/zalando/patroni).
- PostgreSQL 14 Released
- Vitess 11
-
How can I check the load of the PostgreSQL container?
Want a tool for increasing the durability of your DB? I suggest running postgres via systemd, or failing that, start-stop-daemon. To get even more robust, look in to something like setting up pgbouncer in front of haproxy in front of a set of read-only replica PG instances running in either logical or streaming replication. To get even MORE robust, I suggest Patroni for high-availability PG.
-
PostgreSQL High availability
see here - https://github.com/zalando/patroni
What are some alternatives?
pg_auto_failover - Postgres extension and service for automated failover and high-availability
Grafana - The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.
postgres - 🐘 Run PostgreSQL in Kubernetes
stolon-chart - Kubernetes Helm chart to deploy HA Postgresql cluster based on Stolon
postgresql_cluster - PostgreSQL High-Availability Cluster (based on "Patroni" and DCS "etcd" or "consul"). Automating with Ansible.
citus - Distributed PostgreSQL as an extension
remco - remco is a lightweight configuration management tool
crunchy-proxy - PostgreSQL Connection Proxy by Crunchy Data (beta)
zombodb - Making Postgres and Elasticsearch work together like it's 2023
pgvector - Open-source vector similarity search for Postgres
absurd-sql - sqlite3 in ur indexeddb (hopefully a better backend soon)