27.2 复制仪表板选项卡

本节介绍复制仪表板的选项卡。

重要的

Max Replication Delay字段显示受监控拓扑中存在 的复制延迟总量。

要显示复制组，请从 Replication Topology下拉列表中选择一个组。

重要的

单击Replication Topology下拉列表 旁边的刷新图标，强制重新发现所有复制组。

地位

Status选项卡显示有关复制拓扑成员状态的信息 。每个实例都会展开以在向下钻取中显示详细信息。

笔记

以红色显示的数据表示您的配置有问题，而绿色表示首选设置。

如果受监视的拓扑是组拓扑，状态消息将显示在状态表上方。状态消息总结了群组的当前状态，是否所有成员都在线，容错，群组是否有法定人数。状态消息以组复制 ID 为前缀，其格式为 GR-nnnnnnnn-nnnn，其中 nnnnnnnn-nnnn 是组的 UUID 前缀。

有关组复制的更多信息，请参阅 组复制。

表 27.1 组状态列

姓名 描述

实例

（所有拓扑）受监视实例的名称。

成员国

（仅限组复制拓扑）显示成员是ONLINE、 ERROR、RECOVERING、 OFFLINE还是 UNREACHABLE。

如果成员未使用 Group Replication 插件，则显示 N/A。

获取状态

（所有拓扑）显示提取操作的当前状态。如果副本成功从源检索数据，则该图标为绿色。如果复制因错误而未停止，则该图标为黄色。如果状态未知，要么是因为实例当前未受监控，要么没有进行复制，则图标为红色，并且错误会显示在工具提示中。

应用状态

（所有拓扑）显示应用操作的当前状态。如果更改成功应用于副本，则该图标为绿色。如果应用操作已停止，但未发生错误，则该图标为黄色。如果应用操作因错误而停止，则图标为红色并在工具提示中显示错误。

时间落后

（仅限异步拓扑）副本落后于源的时间量。来源显示 N/A。如果 Fetch 或 Apply 状态有问题，则会显示 Unknown。

只读

（所有拓扑）显示以下值之一：

启用 GTID

（仅限异步拓扑）显示服务器是否正在使用 GTID。

二进制日志格式

（仅限异步拓扑）显示二进制日志使用的格式。

节点类型

（所有拓扑）显示节点类型。源、副本、主要组成员、次要组成员等。如果复制类型是多源，节点可以是 Replica/Source。

流量控制

（仅限组复制）用于流量控制的模式。可能的值为 QUOTA 或 DISABLED。对于未使用 Group Replication 插件的实例，将显示 N/A。

查看 ID

（仅限组复制）视图的唯一标识符。

群组自增

（仅限组复制）为组成员定义的自动增量。

频道

（仅限异步拓扑）显示此实例使用的通道数。

版本

（所有拓扑）显示 MySQL 实例的版本。


实例向下钻取包含不同的信息，具体取决于实例是源还是副本，还取决于所使用的复制类型。每个副本还包含一个选项卡，列出它从中接收更新的所有实例。

  • 源深化内容：

    • 节点状态：绘制运行连接中的源负载、每秒查询和平均响应时间的图表。还提供了服务器 ID。

    • Group Replication Status：（仅 Group Replication）绘制排队、验证、检查和冲突事务中的事务状态图。

    • Local Binary Log Status：显示本地二进制日志的详细信息，例如名称、位置和 GTID 集。

    • Binary Log Statistics：绘制平均每秒读/写、日志文件延迟和总空间使用情况的图表。

      笔记

      此框架需要 sys 架构来显示所有图形。如果节点上未安装 sys 架构，则仅显示总空间使用率图。

    • Most Appropriate Candidates for Source Promotion (best candidates on top)：列出有资格升级到源的副本。

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

        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 27.2 Replication Statistics tab

Example of the Replication Statistics tab, showing several graphs and their data. The figure content is described in the surrounding text.

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.