Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality. Learn more →
Pg_auto_failover Alternatives
Similar projects and alternatives to pg_auto_failover
-
patroni
A template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or Kubernetes
-
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
postgresql_cluster
PostgreSQL High-Availability Cluster (based on "Patroni" and DCS "etcd" or "consul"). Automating with Ansible.
-
-
-
vitess
Vitess is a database clustering system for horizontal scaling of MySQL.
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
-
tds_fdw
A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
-
amazon-redshift-utils
Amazon Redshift Utils contains utilities, scripts and view which are useful in a Redshift environment
-
postgres-operator
Postgres operator creates and manages PostgreSQL clusters running in Kubernetes
-
-
postgres-operator
Production PostgreSQL for Kubernetes, from high availability Postgres clusters to full-scale database-as-a-service. (by CrunchyData)
-
-
-
pgcat
PostgreSQL pooler with sharding, load balancing and failover support.
-
spilo
Highly available elephant herd: HA PostgreSQL cluster using Docker
-
-
roadmap
This is the public roadmap for Salesforce Heroku services. (by heroku)
-
rubyrep
Open-source solution for asynchronous, master-master replication of relational databases
-
pgcluster
Docker swarm cluster of postgres databases with streaming replication, pgpool and repmgr
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
pg_auto_failover reviews and mentions
- 11 Years of Hosting a SaaS
-
Why PostgreSQL High Availability Matters and How to Achieve It
pg_auto_failover makes it an absolute breeze. I cannot understand how it's not mentioned in the article.
I've been runnning it for 3 years with great success - https://github.com/hapostgres/pg_auto_failover/discussions/6...
-
Can someone share experience configuring Highly Available PgSQL?
Simplified and probably OK: pg_auto_failover - One Monitor/Witness node and minimum services otherwise. Good documentation to get started and not nearly as complex as Patroni.
- Just Use Postgres for Everything
-
The C++ Asynchronous Framework
This is /extremely/ uncharitable. It depends more on the project.
For example, both Go and .NET are very well written with comprehensible documentation. Many projects have also been absorbed by the Apache Foundation or other FOSS initiatives.
Every FANG has boat loads of teams working on umpteen different open source packages. The quality naturally varies.
Let me pick two more esoteric projects as a point of comparison.
Yandex Odyssey (https://github.com/yandex/odyssey) an advanced multi-threaded PostgreSQL connection pooler and request router. Figuring out how exactly and when to use this is not quite clear. There is no "getting started" guide for this package. There is barely any explanation for how it works or what it does.
pg_auto_failover (https://github.com/citusdata/pg_auto_failover) run by Citus (owned by Microsoft) monitors and manages automated failover for a Postgres cluster. This repo even has diagrams explaining the workflow and complete instructions.
-
Vitess 11
I completely missed the news that Microsoft acquired Citrus back in 2019.
I noticed in their MIT like license it referred to Microsoft and way confused until I learned they were acquired.
https://github.com/citusdata/pg_auto_failover/blob/master/LI...
- An early look at Postgres 14 performance and monitoring improvements
-
Citus 10 brings columnar compression to Postgres
Not multi-master, but pg_auto_failover looks to be a very nice solution for HA, and one that is operationally simple to manage: https://github.com/citusdata/pg_auto_failover
-
PostgreSQL High availability
Also check https://github.com/citusdata/pg_auto_failover
-
A note from our sponsor - InfluxDB
www.influxdata.com | 28 Mar 2024
Stats
hapostgres/pg_auto_failover is an open source project licensed under GNU General Public License v3.0 or later which is an OSI approved license.
The primary programming language of pg_auto_failover is C.
Popular Comparisons
- pg_auto_failover VS patroni
- pg_auto_failover VS citus
- pg_auto_failover VS orchestrator
- pg_auto_failover VS postgresql_cluster
- pg_auto_failover VS discussion
- pg_auto_failover VS plv8
- pg_auto_failover VS tds_fdw
- pg_auto_failover VS vitess
- pg_auto_failover VS amazon-redshift-utils
- pg_auto_failover VS pg-safeupdate