I have two Ubuntu 12.04 servers, which run mysql in a master-master setup, with mmm as manager. How can I set up heartbeat to make sure that mmm only runs at one node at the time?
*Edit to explain more clearly
---------VIP (10.0.0.123)------ | | Node1 Node2
Where bot Node1 and Node2 run:
- Multi-Master Replication Manager for MySQL (mmm)
I only want a single write enabled Mysql node, and I can only have one mmm running at the time, else I'll get collision between the managers.
heartbeatare not the same. So please describe what you are doing a little bit deeper.
mysqlhas its own clustering abilities with no need for heartbeat...