[GENERAL] Cluster, repmgr, pgbouncer, pgpool, ha proxy, virtual IP, replication, failover and load balance - Mailing list pgsql-general

From Juliano
Subject [GENERAL] Cluster, repmgr, pgbouncer, pgpool, ha proxy, virtual IP, replication, failover and load balance
Date
Msg-id M9giYXSpEBpjlkte1Mke1_ZtdyRncxSaolDw5Fqn0-0upQyQeU-67Q2QMJ6pIMVZAlGtHRrv_bKxuz_4ql07RiMvNxwBatLNgfEA1Y6hCgM=@protonmail.com
Whole thread Raw
List pgsql-general
Hi guys

I would like to deploy load balance on Postgres master/slave(RW/R) servers and also use a virtual IP on this cluster

I currently have Postgres 9.4 using Repmgr for replication and manual failover to avoid split-brain problems and save a witness server. Also, there is Pgbouncer connection pooling working in session mode

So, what is recommended to use in my current environment?

Is Pgpool the best solution to use with Repmgr+Pgbouncer? In this case, should I replace Pgbouncer for Pgpool or use both? What about HA proxy?

I have never configured a virtual IP to cluster, should I use Keepalived, Heartbeat or any other solution?

Here is the image of what is in my mind: https://ibb.co/fZFebk
cluster.jpg

Thanks in advance for any help!

pgsql-general by date:

Previous
From: Vincenzo Romano
Date:
Subject: Re: [GENERAL] DROP [TEMP] TABLE syntax, as reason why not?
Next
From: Pavel Stehule
Date:
Subject: Re: [GENERAL] DROP [TEMP] TABLE syntax, as reason why not?