Ecosystem:PostgreSQL only:Clustering

From PostgreSQL wiki

Jump to: navigation, search

Contents

EDB Postgres Failover Manager

Postgres-BDR

  • Provider -- 2ndQuadrant
  • Website -- https://www.2ndquadrant.com/
  • License -- Proprietary
  • Interoperability level -- explicitly supports PostgreSQL 9.4 or higher
  • Verified PostgreSQL versions -- https://www.2ndquadrant.com/en/resources/bdr/
  • Last update (YYYY-MM-DD) -- 2018-03-16
  • Description --Postgres-BDR (Bi-Directional Replication for PostgreSQL) is a ground-breaking multi-master replication tool for PostgreSQL databases that has been in full production status since 2014. In the complex environment of replication, BDR achieves efficiency and accuracy, ensuring very high availability of all nodes in a geographically distributed cluster.
  • Additional info -- click here

repmgr

  • Provider -- 2ndQuadrant
  • Website -- https://www.2ndquadrant.com/
  • License -- GPL v3
  • Interoperability level -- explicitly supports PostgreSQL 9.1 or higher
  • Verified PostgreSQL versions -- https://www.2ndquadrant.com/en/resources/repmgr/
  • Last update (YYYY-MM-DD) -- 2018-03-09
  • Description -- repmgr helps DBAs and System Administrators manage a cluster of PostgreSQL databases. It simplifies administration and daily management, enhances productivity and reduces the overall costs of a PostgreSQL cluster.
  • Additional info -- click here

Pgpool-II

  • Provider -- Pgpool-II Global Development Group
  • Website -- https://pgpool.net
  • License -- PostgreSQL License
  • Interoperability level -- PostgreSQL 7.3 or higher
  • Verified PostgreSQL versions -- PostgreSQL 7.3 or higher
  • Last update (YYYY-MM-DD) -- 2018-04-26
  • Description -- Pgpool-II is a cluster management tool for PostgreSQL. It provides features currently lacking in PostgreSQL: automatic failover, automatic query dispatching to master (primary) server and slave (standby) servers, load balancing for SELECTs, session level connection pooling, in memory query cache and more. Pgpool-II is mostly transparent to non-cluster-aware PostgreSQL applications. Also Pgpool-II provides built-in High Availability feature to protect Pgpool-II itself.
  • Additional info -- click here
Personal tools