Postgres Pro
Downloads
Home   >   mailing lists

Re: increasing HA - Mailing list pgsql-general

From Thomas Poty
Subject Re: increasing HA
Date
Msg-id CAN_ctnj1jrABJUdwgAfLWhwn6nkWPa1=tKKD3+cDLnOPcALaGQ@mail.gmail.com
Whole thread Raw
In response to Re: increasing HA  (Dmitri Maziuk <dmaziuk@bmrb.wisc.edu>)
Responses Re: increasing HA  (Dmitri Maziuk <dmaziuk@bmrb.wisc.edu>)
List pgsql-general
Tree view
> How many nodes do you want run? Keep in mind that with only 2 nodes, fencing off the right one is by definition an undecidable problem. That's one of the features of the current linux HA stack that makes one want to go BSD/CARP.
>
> And if you want to run fully distributed, you might want to look at redis in the first place.
We have one master and 2 slaves so 3 nodes

Le mer. 5 sept. 2018 à 16:42, Dmitri Maziuk <dmaziuk@bmrb.wisc.edu> a écrit :
On Wed, 5 Sep 2018 13:23:41 +0200
Thomas Poty <thomas.poty@gmail.com> wrote:

> At first glance, i may use for automatic failover PAF, a proxy HAproxy and
> for fencincg, i am a bit disappointed, i don't know what to do/use

How many nodes do you want run? Keep in mind that with only 2 nodes, fencing off the right one is by definition an undecidable problem. That's one of the features of the current linux HA stack that makes one want to go BSD/CARP.

And if you want to run fully distributed, you might want to look at redis in the first place.

--
Dmitri Maziuk <dmaziuk@bmrb.wisc.edu>

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: PostgreSQL intenal scheduler?
Next
From: Paul Jungwirth
Date:
Subject: Full table lock dropping a foreign key