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
-- Thanks,
Jorge Torralba ----------------------------
Note: This communication may contain privileged or other confidential information. If you are not the intended recipient, please do not print, copy, retransmit, disseminate or otherwise use the information. Please indicate to the sender that you have received this email in error and delete the copy you received. Thank You.