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:
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)
The output from the management node on the current state of my cluster:
The heartbeat configurations:
The Mon Configurations:
Can anyone point me in the right direction on how to make this work?