当前位置: 代码迷 >> 综合 >> replication_group_members和replication_group_member_stats
  详细解决方案

replication_group_members和replication_group_member_stats

热度:61   发布时间:2024-01-18 06:40:01.0

        在在开启了mysql group replication后,有两个比较重要的表,记录了group replication复制组成员及其信息,我们来说说表中具体字段的意义。

1、replication_group_members:该表记录了group replication架构中,组成员的状态信息。

mysql> select * from replication_group_members;
+---------------------------+--------------------------------------+-------------+-------------+--------------+
| CHANNEL_NAME              | MEMBER_ID                            | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
+---------------------------+--------------------------------------+-------------+-------------+--------------+
| group_replication_applier | 12ed1804-ff04-11eb-810c-0050568f8774 | rac1        |        3306 | ONLINE       |
| group_replication_applier | 789c2972-ff04-11eb-b4e1-0050568fa18f | rac2        |        3306 | ONLINE       |
| group_replication_applier | 9278af53-ff04-11eb-892d-0050568fd5f5 | rac3        |        3306 | ONLINE       |
+---------------------------+--------------------------------------+-------------+-------------+--------------+
3 rows in set (0.00 sec)

表中各字段的含义:

channel_name:group replication架构中复制通道的名称“group_replication_applier”

member_id:组成员的server uuid,mysql实例启动后生成的唯一标识

member_host:组成员的主机名

member_port:组成员的服务端口

member_state:组成员的状态

offline:当前组成员并未启动组复制进程
online:当前组成员已正常加入集群
recovery:当前组成员正在恢复同步数据

2、replication_group_member_stats:该表中记录了group replication状态信息,在启动group replication时表中才会有记录。

mysql>  select * from performance_schema.replication_group_member_stats\G
*************************** 1. row ***************************CHANNEL_NAME: group_replication_applierVIEW_ID: 16291687993785114:15MEMBER_ID: 789c2972-ff04-11eb-b4e1-0050568fa18fCOUNT_TRANSACTIONS_IN_QUEUE: 0COUNT_TRANSACTIONS_CHECKED: 22COUNT_CONFLICTS_DETECTED: 0
COUNT_TRANSACTIONS_ROWS_VALIDATING: 0
TRANSACTIONS_COMMITTED_ALL_MEMBERS: 05153196-c2ab-43ae-b355-b9832eacf0b2:1-22:1000006-1000008:2000006-2000011LAST_CONFLICT_FREE_TRANSACTION: 05153196-c2ab-43ae-b355-b9832eacf0b2:20
1 row in set (0.00 sec)

channel_name:group replication架构中复制通道的名称“group_replication_applier”

view_id:组成员所在组的视图唯一标识符

member_id:组成员的server uuid,mysql实例启动后生成的唯一标识

count_transactions_in_queue:当前队列中等待冲突检查的事务数量,冲突检测通过后,他们将进行应用

count_transactions_checked:当前已通过检查的事务数量,从启动group replication后计算

count_conflicts_detected:当前未通过检测机制的事务数

count_transactions_rows_validating:当前certification_info里面有多少条记录

transactions_committed_all_members:所有成员已提交的事务集合

last_conflict_free_transaction:最后一次提交事务集合

  相关解决方案