This section describes the requirements for monitoring MySQL Server.
The Monitoring Agent can monitor any version of MySQL Server from version 5.5 onwards.Important
It is not possible to monitor pre-GA versions of MySQL 5.7 or 8.0. MySQL Enterprise Monitor supports monitoring of MySQL 5.7.6, and MySQL 8.0.11 onwards.
The monitoring Agent always uses
PERFORMANCE_SCHEMA.GLOBAL_STATUSon MySQL 5.7 versions, and supports both modes of
show_compatibility_56from MySQL 5.7.9 onwards.Note
To monitor versions of MySQL 5.7.8,
show_compatibility_56must be set to OFF.
If you intend to monitor MySQL NDB Cluster, you must ensure the following when configuring your cluster:
NDB Cluster version is 7.5.7, or higher
[System]section of your cluster configuration file to include the cluster name. MySQL Enterprise Monitor Agent reads this value and uses it to uniquely identify your cluster. For example:
It is strongly recommended to install MySQL Enterprise Monitor Agent on all Management, Data, and SQL nodes for optimal monitoring. If this is not possible, monitoring the SQL nodes provides useful information about the entire cluster.
Always include the
--ndb-nodeidflags in the corresponding command to facilitate topology discovery.
The Management node was started with the
--config-fileflag, and ensure the owner of MySQL Enterprise Monitor Agent process has permissions to read the configuration file.
If your host has multiple addresses, include the
--bind-addressflag on the ndb commands, matching the HostName variable defined in the configuration file.
Do not use
localhostor any loopback address in your configuration or commands. Always use a unique address.