Re: increasing HA

From: Dmitri Maziuk <dmaziuk(at)bmrb(dot)wisc(dot)edu>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: increasing HA
Date: 2018-09-05 14:42:23
Message-ID: 20180905094223.acdb3411826e5317d7853020@bmrb.wisc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 5 Sep 2018 13:23:41 +0200
Thomas Poty <thomas(dot)poty(at)gmail(dot)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(at)bmrb(dot)wisc(dot)edu>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thiemo Kellner 2018-09-05 15:06:07 PostgreSQL intenal scheduler?
Previous Message Gunnlaugur Thor Briem 2018-09-05 14:06:17 Re: unaccent(text) fails depending on search_path (WAS: pg_upgrade fails saying function unaccent(text) doesn't exist)