5.9 Monitoring Multiple MySQL Servers

You can monitor multiple MySQL servers (either on the same machine, or remotely across different machines) using a single Agent.

Make sure that the MySQL instance that you want to monitor has a suitable user to use for connecting to the host. For more information, see Section 5.2, “Creating MySQL User Accounts for the Monitor Agent”.

Typically, an Agent will scan a host and report unmonitored MySQL instances to the MySQL Enterprise Monitor User Interface. For more information about how this works, see Section 1.2, “MySQL Enterprise Monitor Agent”. For information about how to change the status of a MySQL instance from unmonitored to monitored, see Section 14.4, “MySQL Instances”.

Note

In MySQL Enterprise Monitor 2.x, a single Agent was designed to monitor a single MySQL instance. As of MySQL Enterprise Monitor 3.0.0, an Agent can monitor multiple MySQL instances, and unmonitored MySQL instances are now reported to MySQL Enterprise Service Manager using the MySQL Process Discovery Advisor.