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.
Navigate to the Replication page by choosing
. 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
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 17, Managing Groups of Instances. However, any replicas removed from a server group are automatically restored to that group.