increasing HA

From: Thomas Poty <thomas(dot)poty(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: increasing HA
Date: 2018-09-04 14:58:51
Message-ID: CAN_ctnh=Pg6nGDtwxv+qJdpF_yHsJFZx1CcA0YSTgN8nvpnnrw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I am looking after some advice about solution allowing to increase High
availability?

Here is a bit of context :

I have an Master-Slave architecture
- 1 master
- 2 asynchronous slaves using replication slot
- backup is made with barman using replication slot
- Wal archiving is done towards barman server

I think 3 axes could be improved ( I am totaly novice with these):

- using of a proxy
I found HAproxy.
Could you advice any others solutions to explore or share your experience?

- using an automatick failover
I found PAF
Could you advice any others solutions to explore or share your experience?

- using a tool for fencing a failing node
Ideally, I aimagine to disable network traffic in I/O to prevent client
connecting and exchange between backup server failling server + on
postgesql server disable automatic restart of the service.
Could you share you experience about it?

- Maybe an other axe to explore ?

Thank you

Thomas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ROS Didier 2018-09-04 15:09:51 RE: increasing HA
Previous Message Ron 2018-09-04 14:52:10 Re: Barman versus pgBackRest