Table of Contents [+/-]
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
. 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.
Set up agents to monitor each master and slave server. Only servers that are monitored appear on this page.
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
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
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 17, Managing Groups of Instances. However, any replicas removed from a server group are automatically restored to that group.