Documentation Home
MySQL Enterprise Monitor 3.2 Manual
Related Documentation Download this Manual
PDF (US Ltr) - 3.7Mb
PDF (A4) - 3.6Mb
EPUB - 2.7Mb
HTML Download (TGZ) - 2.6Mb
HTML Download (Zip) - 2.7Mb


Chapter 17 Replication Dashboard

The Replication Dashboard displays all information related to monitored replication groups. MySQL Enterprise Monitor supports monitoring of single-source tree hierarchy, circular replication, or complex, multi-level, multi-source hierarchies.

Navigate to the Replication page by choosing Replication under Dashboards. This page summarizes the state of your replication servers; you can drill down to see details about any source or replica. Using this page helps you avoid running the SHOW SLAVE STATUS command over and over on multiple servers; for consistency, the Replication page uses some of the same keywords as the output from that command.

Replication is organised by group. You must select a replication group.

Note

Set up agents to monitor each master and slave server. Only servers that are monitored appear on this page.

The Replication page groups all sources and replicas. Sources and replicas are autodiscovered and a grouped, based on the replication topology. Scans run on a five minute interval, so it can take as long as 2 polling intervals to create a complete group.

Warning

Auto-discovery with remote monitoring only functions with MySQL 5.6 and later. Earlier versions of MySQL server require the Agent to be installed on the same host as the monitored MySQL instance. This is because mysqld did not expose the master's uuid value via SHOW SLAVE STATUS until version 5.6.

You can manage replication groups from the Groups page in the same way as other groups. For more information, see Chapter 16, Managing Groups of Instances. However, any replicas removed from a server group are automatically restored to that group.

Important

For information on the kinds of problems you might find while monitoring replication, and how to solve them, see Troubleshooting Replication and Improving Replication Performance.


User Comments
Sign Up Login You must be logged in to post a comment.