Typically, the Agent runs on the same machine as the MySQL servers that it is monitoring. To monitor MySQL servers running on remote hosts, you can install the Agent on a machine other than the one hosting the MySQL server.
The process for installing an Agent to monitor a MySQL server on a
remote machine is identical to the process described in
Chapter 5, Monitor Agent Installation. Follow the directions given
there, being careful to either select "host-only" and add remote
MySQL instances later, or specify the correct IP address or host
name for MySQL Enterprise Service Manager and likewise for the MySQL server—
since the Agent is not running on the same machine as the MySQL
server, it cannot be the default (
Ensure that the Agent has the appropriate rights to log in to the
MySQL server from a host other than
and that the port used by the MySQL server, typically
3306 must be open for remote access. For more
information about the database credentials required by agents see,
Section 5.2, “Creating MySQL User Accounts for the Monitor Agent”.
The Agent also needs to be able to log in to MySQL Enterprise Service Manager,
typically using port
18443, so ensure that the
appropriate port is open.
Remote monitoring does not provide operating system level data, such as CPU, file, and network utilization information.
Monitoring multiple MySQL instances with a single agent potentially means having a single point of failure. This is especially true for remote monitoring, where a loss of connection means loss of monitoring data, whereas an Agent installed on the same server as the MySQL instance continues monitoring and transmits the backlog of data to the MySQL Enterprise Service Manager upon reconnection.
For replication autodiscovery, do not use remote monitoring for replicas or sources. The Agent must be installed on the same machine as the server you are monitoring for discovery to work properly. For more information, see Chapter 27, Replication Dashboard.