Re: increasing HA

Поиск
Список
Период
Сортировка
От Thomas Poty
Тема Re: increasing HA
Дата
Msg-id CAN_ctnj1jrABJUdwgAfLWhwn6nkWPa1=tKKD3+cDLnOPcALaGQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: increasing HA  (Dmitri Maziuk <dmaziuk@bmrb.wisc.edu>)
Ответы Re: increasing HA
Список pgsql-general
> 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 по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: PostgreSQL intenal scheduler?
Следующее
От: Paul Jungwirth
Дата:
Сообщение: Full table lock dropping a foreign key