Chapter 28 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, group replication, or complex, multi-level, multi-source hierarchies.

For more information on the various types of replication supported by MySQL Server, and monitored by MySQL Enterprise Monitor, see Replication and Group Replication.

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.

The Replication dashboard is organized by topology.

Note

Set up agents to monitor each source and replica server. Only monitored servers are displayed on this page.

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

Warning

Auto-discovery with remote monitoring is possible with MySQL 5.6 and later, only. 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 to SHOW SLAVE STATUS in versions preceding MySQL 5.6.

You can manage replication topologies from the Groups page in the same way as other groups. For more information, see Chapter 18, 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.