The goal is to have only one entry in the Enterprise Monitor Dashboard that shows the status of the MySQL instance, no matter on which physical server in runs. There are two ways to achieve this:
- You can install the agent on both physical nodes
- You can install the agent on a shared storage.
In either case you have to make sure, that only one agent runs at a time. You have to integrate the agent into your cluster framework. I will not describe how this works, as it is highly dependant on your cluster framework.
The following description assumes, that you will install the agent on both physical nodes.Install the agent but DO NOT START the agent yet.
Edit the [agent-installdir]/etc/mysql-monitor-agent.ini
In the [mysql-proxy] section add the following line:
agent-host-id=[logical [Read more...]