This section describes the tabs of the Replication Dashboard.
The Max Replication Delay field displays the total amount of replication delay which exists on the monitored topologies.
To display a replication group, choose a group from the Replication Topology drop-down list.
Clicking the refresh icon, adjacent to the Replication Topology drop-down list, forces a re-discovery of all replication groups.
The Status tab displays information on the status of the members of the replication topologies. Each instance expands to display detailed information in a drill-down.
Data displayed in red indicates a problem with your configuration, while green indicates preferred settings.
If the monitored topology is a group topology, a status message is displayed above the Status table. The status message summarizes the current state of the group, whether all members are online, fault tolerance, and whether the group has quorum. The status message is prefixed with the Group Replication ID, which takes the form GR-nnnnnnnn-nnnn, where nnnnnnnn-nnnn is the UUID prefix of the group.
For more information on Group Replication, see Group Replication.
Table 28.1 Group Status Columns
Name | Description |
---|---|
Instance |
(All topologies) Name of the monitored instance. |
Member State |
(Group Replication topologies only) Displays whether the
member is N/A is displayed if the member is not using the Group Replication plugin. |
Fetch State |
(All topologies) Displays the current status of the fetch operations. If the replica successfully retrieved data from the source, the icon is green. If the replication has not stopped because of an error, the icon is yellow. If the state is unknown, either because the instance is currently unmonitored, or no replication is taking place, the icon is red and the errors are displayed in a tooltip. |
Apply State |
(All topologies) Displays the current status of the apply operations. If the changes are successfully applied to the replica, the icon is green. If the apply operation was stopped, but no error occurred, the icon is yellow. If the apply operation stops because of an error, the icon is red and the error displayed in a tooltip. |
Time Behind |
(Asynchronous topologies only) Amount of time the replica is behind the source. N/A is displayed for sources. If there is a problem with the Fetch or Apply state, Unknown is displayed. |
Read Only |
(All topologies) Displays one of the following values:
|
GTID Enabled |
(Asynchronous topologies only) Displays if the server is using GTIDs. |
Binary Log Format |
(Asynchronous topologies only) Displays the format used by the binary log. |
Node Type |
(All topologies) Displays the type of node. Source, Replica, Primary Group Member, Secondary Group Member, and so on. If the replication type is multi-source, the node can be Replica/Source. |
Flow Control |
(Group Replication only) The mode used for flow control. Possible values are QUOTA or DISABLED. N/A is displayed for instances which are not using the Group Replication plugin. |
View ID |
(Group Replication only) Unique identifier of the view. |
Group Auto Increment |
(Group Replication only) The auto increment defined for the group's members. |
Channels |
(Asynchronous topologies only) Displays the number of channels used by this instance. |
Version |
(All topologies) Displays the version of the MySQL instance. |
The instance drill downs contain different information depending on if the instance is a source or a replica, and also depends on the type of replication in use. Each replica also contains a tab listing all the instances from which it is receiving updates.
Source drill down contents:
Node Status: graphs the source load in running connections, queries per second, and the average response time. The server IDs are also provided.
Group Replication Status: (Group Replication only) graphs the transaction status in transactions queued, validating, checked, and in conflict.
Local Binary Log Status: displays the details of the local binary log, such as name, position, and GTID set.
Binary Log Statistics: graphs the average read/writes per second, log file latency and total space usage.
NoteThis frame requires sys schema to display all graphs. If sys schema is not installed on the node, only the Total Space Usage graph is displayed.
Most Appropriate Candidates for Source Promotion (best candidate on top): lists the replicas which are eligible for promotion to source.
For a replica to be eligible for promotion to source, it must have the same GTID mode as the source. If GTID mode and binary logging are disabled, the replica cannot be promoted. Such replicas are listed in red with a message explaining why they are not eligible for promotion.
Ordering of candidates is based on a scoring system. Replicas with the highest value of
RECEIVED_TRANSACTION_SET
in theperformance_schema.replication_connection_status
table are promoted.Semi-Synchronous Replication: this frame is present for both asynchronous and semi-synchronous types, but is only populated if semi-synchronous replication is in use. If semi-synchronous replication is running, this section contains graphs showing the Sessions Waiting, Waits, and transaction status.
Replication Configuration: displays all information related to the replication configuration:
General
Group Replication Recovery
Networking
Relay Logging
Group Replication General
Group Replication Security
Group Replication Performance
Crash Safety
Appliers
Multi-Threaded Appliers
Replica drill-down contents:
Node Status: graphs the replica load in running connections, queries per second, and the average response time. The server IDs are also provided.
Source Replication Status: displays a tab for every source replicating to the selected replica. Each tab displays the following:
Fetch Status: displays graphs and information on the status of the data retrieval from the source.
Filter / Delay Status: displays the defined and remaining delays and any filtered databases or specific tables.
Apply Status: displays the current apply status, the last executed GTID set, and so on. The status by worker is also displayed.
NoteThe Info column of the Status by Worker section requires the user have the Query Analysis Example and Explain Data permission set to at least Read-Only. If this permission is not granted, the Info column cannot be populated.
Source Configuration: displays the instance name, port, and username of the source.
Channel Configuration: displays the channel configuration information.
Secure Connection Configuration: displays all SSL-related information for the monitored instance.
Replication Configuration: displays all information related to the configuration of the replication process.
It is also possible to edit and delete connections from this tab. Clicking the drop-down list next to the instance opens the instance context menu. For more information on this menu, see Group and Instance Context Menu.
The Statistics tab graphs the activity of all members of the topology. You can change the data displayed using the Graph Time Range selections. If a range is selected for which there is no data, no graph is displayed.
The following graphs are available:
Database Activity - All MySQL Instances: displays the total number of
SELECT
,INSERT
,UPDATE
,REPLACE
,DELETE
, andCALL
statements performed on all members of the selected group.Connections Running - Per MySQL Instance: displays the running connections for each member of the group.
Database Queries - Per MySQL Instance: displays the number of queries performed against each member of the group.
If the selected topology is a member of a group replication topology,the following graphs are also displayed:
Group Replication - Transactions Rows Validating - Per Member
Group Replication - Transactions Checked - Per Member
Group Replication - Conflicts Detected - Per Member
Group Replication - Transactions In Queue - Per Member