1.4 Monitored MySQL Server

MySQL Enterprise Monitor can monitor any MySQL server running MySQL 5.1 or higher. The advisors provide specific support for different versions. For example, there are unique advisors and graphs for different MySQL versions, and some rules provide advice about MySQL upgrades.

In addition to monitoring the internal operation of the MySQL server, the MySQL Enterprise Monitor Agent and MySQL Enterprise Service Manager monitors the hosts themselves for problems like high CPU, memory, and disk usage, and can determine the topology of MySQL servers in a replication configuration, and monitor the replication status.

MySQL Enterprise Monitor uses a number of unique values known as UUIDs to identify the different components, including the MySQL instance being monitored. UUID values related to the MySQL instance and the host on which it runs are stored in a table mysql.inventory within the instance. MySQL Enterprise Monitor creates this table if it does not exist already.

These UUIDs are used in combination to register and collate information, and to determine the location and source of an issue.

Note

Because each host, agent, and MySQL server must be unique, be careful when restoring from a backup or cloning a virtual machine (VM) image so you do not have hosts with duplicated SSH keys or UUIDs.

You can monitor any MySQL server, because the agent communicates with the MySQL server using the same protocol as any other client. For best results when using MySQL Enterprise Monitor Agent with your MySQL Server, follow these guidelines: