Re: [Postgres-xc-general] Failed to get pooled connection error when any of node goes down

[Mason S. <ms...@tr...>]

On Mon, Apr 7, 2014 at 1:19 AM, Juned Khan <jkh...@gm...> wrote:

> Hi koichi,
>
> Yeah we can have slave of each component but in case of failure i need to
> promote it
> manually right ?
>
> is there any way to make this process automatic ?
>
>
>
We use Corosync/Pacemaker. One should be careful though, it takes time; you
may encounter false positives with premature failover, or one down
component could impact another and also failover. So, I recommend a lot of
testing.

Also, one should be prepared to fall back and have a strategy for that in
place.



-- 
Mason Sharp

TransLattice - http://www.translattice.com
Distributed and Clustered Database Solutions