Re: 9.2 Observer node for streaming replication

On 7/15/2013 8:55 AM, Jorge Torralba wrote:
> I have a master and a slave running streaming replication between the
> two servers. I would like to setup some kind of third machine to play
> the role of observer node to monitor the replication and do the
> automatic fail over.  However, I can't find any documentation or
> suggestions on such an implementation. Is it possible to do with 9.2.4
> or will I need to rely on some sort of F5 load balancer to handle the
> auto failover?

Depends on your OS. We do this all the time with our HAC setups and we
don't need any kind of load balancer to pull it off.

JD