This section describes important features of the Agent.
The Agent uses three users with different connection levels: Admin, General (optional), and Limited (optional). These can be created manually or by the installation and configuration process.
Typically, one Agent is installed per host, and the Agent monitors the host and all MySQL instances on it. An Agent may also monitor remote MySQL instances.
Agents automatically detect MySQL instances on a host. Adding the new MySQL instance may be performed in the MySQL Enterprise Monitor UI or from the command line.
Choosing a MySQL Instance to monitor during the installation is optional. If you choose to define a MySQL Instance while running the Installer, additional MySQL Instances on the host are detected and reported in the MySQL Enterprise Monitor User Interface. From there, you can add the appropriate configuration information.
To detect a local connection in IPv6, the Agent requires forward resolution configured on the system from localhost to
::1, which could mean editing the
This is because the
SHOW PROCESSLISTstatement always reports
localhosteven when bound to
::1without an address resolution. If localhost resolution is not configured for IPv6, the Agent cannot detect a local IPv6 MySQL server connection.
Proxy and AggregatorNote
The Proxy and Aggregator are not included in the MySQL Enterprise Monitor Agent. As of version 3.0.14, the Proxy and Aggregator have a dedicated installation package. For more information, see Chapter 11, Proxy and Aggregator Installation
You can assign a monitored MySQL instance to a group via the Agent installer, which is displayed in the MySQL Enterprise Service Manager.
The old Agent's configuration files (
agent-instance.ini) no longer exist. Use
Passwords are now stored in an encrypted format, so you can no longer recover passwords by looking in the configuration files.
The Service Manager now bundles an Agent, which monitors the host on which it is installed, scans for all MySQL instances on the host, and also monitors the Service Manager repository database.Note
It is recommended to install MySQL Enterprise Service Manager on a dedicated server with no other MySQL instances installed.
For a list of supported platforms that the Agent installation supports, see http://www.mysql.com/support/supportedplatforms/enterprise-monitor.html.