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
. 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.
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.
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.
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.