Issues Heartbeat and Mon for SQL Node Failover in MySQL Cluster

view full story

http://www.linuxquestions.org – Hi, I set up MySQL cluster, which went fine but then I needed a mechanism to provide failover between the two sql nodes in my cluster. I searched online for software that would be appropriate for this and what I found was mainly t he use of Heartbeat and Mon. The problem is that: A) it appears as if the IP is tied to both boxes and in fact if I run a ping to the virutal IP the pings will hit both boxes: http://pastebin.com/5jN0fZ1Y B)Killing the MySQL instance doesn't cause anything to happen (I checked all error logs and nothing even registers the failure aside from the mysql error logs) (HowTos)