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
My setup:
---------VIP (10.0.0.123)------
| |
Node1 Node2
Where bot Node1 and Node2 run:
- Mysql
- Multi-Master Replication Manager for MySQL (mmm)
- Heartbeat
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.
mysql
andheartbeat
are not the same. So please describe what you are doing a little bit deeper.mysql
has its own clustering abilities with no need for heartbeat...