Documentation Home
MySQL Enterprise Monitor 3.4 Manual
Related Documentation Download this Manual

19.2 Replication Dashboard Tabs

This section describes the tabs of the Replication Dashboard.

Important

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.

Important

Clicking the refresh icon, adjacent to the Replication Topology drop-down list, forces a re-discovery of all replication groups.

Topology

The Topology tab graphically displays the replication topology of the selected group.

Figure 19.2 Replication Topology Graph

Replication topology tab

This tab contains the following:

  • Topology graph: graphically displays the replication setup, enabling you to reposition the nodes for better visibility, and zoom in and out using your mouse wheel.

  • Tooltips: For information on an individual node or channel, hover the mouse cursor over the node or channel. A tooltip is displayed containing information about the node or channel. The node tooltip displays the ID, Name, and Status of the node, while the channel tooltip displays the name of the channel.

  • Legend : displays the meaning of each of the graphical elements.

    • Nodes:

      • Node OK

      • Replication Issues

      • Node/Replication Down

      • Node Unmonitored

    • Links:

      • Async Fetch OK

      • Async Fetch Down

      • Semi-Sync Fetch OK

      • Semi-Sync Fetch Down

      • Group Replication Recovery

      • Link Status Unknown

    • Group replication Status:

      • Online

      • Group Replication Recovering

      • Offline/Error

      • Unknown/Plugin Not Available

Note

The topology graph displays semi-synchronous links only if both source and replica use the semi-sync plugins.

Group replication topologies are displayed differently. For example, the following is a three-node group:

Figure 19.3 Group Replication Single Group Topology

Group Replication Single Group Topology

While the following shows normal communication between two groups:

Figure 19.4 Group Replication Multiple Group Topology

Group Replication Multiple Group Topology

Status

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.

Note

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 summarises 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 19.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 ONLINE, ERROR, RECOVERING, OFFLINE, or UNREACHABLE.

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.

      Note

      This 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. To be listed near the top of the list, the replica must have at least 70% of all transactions performed as transactions retrieved from a source, and no more than 30% of total transactions are transactions performed directly on the replica and not originating with a source. Then higher retrieved percentage and lower errant percentage improve the ranking of the replica. Higher ranking means higher chance of promotion.

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

        Note

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

Statistics

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, and CALL 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.

Figure 19.5 Replication Topology Statistics

Replication dashboard topology statistics tab

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

Error History

The Error History tab displays all errors logged for the members of the selected group. The time of the error, type of error and error message are displayed.


User Comments
Sign Up Login You must be logged in to post a comment.