[pgsql-cluster-hackers] Help cluster, repmgr, pgboucer, pgpool, ha proxy, virtual IP, replication, failover, load balance

Поиск
Список
Период
Сортировка
От Juliano
Тема [pgsql-cluster-hackers] Help cluster, repmgr, pgboucer, pgpool, ha proxy, virtual IP, replication, failover, load balance
Дата
Msg-id zTMInqF_BBEo_E7IVCzgPMBBPPIFxL2_wfb_FXJo8Uf1LLEuGYKvZPpvxfUtm7UiuZ3PDYvsjTyZxaiGxAUn-JRwljwmxH_fPZ7xs_1T4hQ=@protonmail.com
обсуждение исходный текст
Список pgsql-cluster-hackers
Hi guys

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

I currently have a 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+pgboucer? In this case, should I replace Pbgbouncer 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 for any help!
Вложения

В списке pgsql-cluster-hackers по дате отправления:

Предыдущее
От: DEV_OPS
Дата:
Сообщение: Re: [pgsql-cluster-hackers] Replication over RDMA with Infiniband orRoCE