Re: increasing HA

From: Thomas Poty <thomas(dot)poty(at)gmail(dot)com>
To: ioguix(at)free(dot)fr
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: increasing HA
Date: 2018-09-05 14:05:40
Message-ID: CAN_ctnhQr7mX6Mvcr=Z+5eGOwMiHXLnYBV9LAbbcgh3bOy3yqQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> OK, so either patch PAF yourself (not recommended) or choose something
> else. Note that two other ways are working with Pacemaker:
> * the pgsql resource agent (see FAQ of PAF)
> * a shared disk architecture (no pgsql replication)
Probably, i will be interested by the solution "patroni-etcd-haproxy" you
suggested

> I suppose you could find fencing agents for:

> * the blade itself, but it would fence all the container running on it
> * the access to the SAN from the failing container

> I don't know if fencing agent exists for a container itself. Note that
I'm not
> familiar with the container world, I lack a lot of knowledge on this
> technology.

I am not familiar with this too. I heard that for the first time few days
ago by reading how to improve HA ... :-)

Many thanks for your opinions/advices

Le mer. 5 sept. 2018 à 15:44, Jehan-Guillaume (ioguix) de Rorthais <
ioguix(at)free(dot)fr> a écrit :

> On Wed, 5 Sep 2018 15:06:21 +0200
> Thomas Poty <thomas(dot)poty(at)gmail(dot)com> wrote:
>
> > > In fact, PAF does not support slots. So it is not a good candidate if
> > > slot are a requirement.
> > Effectively slots are a requirement we prefer to keep
>
> OK, so either patch PAF yourself (not recommended) or choose something
> else. Note that two other ways are working with Pacemaker:
> * the pgsql resource agent (see FAQ of PAF)
> * a shared disk architecture (no pgsql replication)
>
> > > > a proxy HAproxy and
> > > > for fencincg, i am a bit disappointed, i don't know what to do/use
> > > Depend on your hardware or your virtualization technology.
> > Our production cluster (master and slave) runs on LXC container. Each LXC
> > container runs on a HPE Blade Server. The storage is on a SAN 3PAR array.
> > Any advice ?
>
> I suppose you could find fencing agents for:
>
> * the blade itself, but it would fence all the container running on it
> * the access to the SAN from the failing container
>
> I don't know if fencing agent exists for a container itself. Note that I'm
> not
> familiar with the container world, I lack a lot of knowledge on this
> technology.
>
> ++
>

In response to

Browse pgsql-general by date

  From Date Subject
Next 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)
Previous Message Adrian Klaver 2018-09-05 14:00:03 Re: unaccent(text) fails depending on search_path (WAS: pg_upgrade fails saying function unaccent(text) doesn't exist)