replication_group_members - xiaoboluo768/mysql-system-schema GitHub Wiki

该表记录组复制架构中，组成员的网络和状态信息
replication_group_members表列和含义如下：
- CHANNEL_NAME：组复制架构中使用的通道名称
- MEMBER_ID：组复制架构中，组成员的ID，与组成员实例的server UUID相同
- MEMBER_HOST：组复制架构中，组成员的网络地址（主机名或IP地址）
- MEMBER_PORT：组复制架构中，组成员的侦听端口
- MEMBER_STATE：组复制架构中，组成员的状态有效状态如下：
  - OFFLINE：组复制成员已经安装组复制插件，但未启动
  - RECOVERING：组复制成员已经加入到组复制架构中，正在从组中接收数据，即正在加入集群
  - ONLINE：组复制成员处于正常运行状态
对于replication_group_members表，不允许执行TRUNCATE TABLE语句
表记录内容示例

root@localhost : performance_schema 02:43:55> select * from replication_group_members;
+---------------------------+--------------------------------------+-------------+-------------+--------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
+---------------------------+--------------------------------------+-------------+-------------+--------------+
| group_replication_applier | 19f71b6a-30d3-11e8-a724-525400c33752 | node2 | 3306 | OFFLINE |
+---------------------------+--------------------------------------+-------------+-------------+--------------+
1 row in set (0.00 sec)

# 在MySQL 8.0中会记录更多的信息，类似如下
root@localhost : (none):01: > select * from performance_schema.replication_group_members;
+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION |
+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+
| group_replication_applier | 2d283e92-de7b-11e9-a14d-525400c33752 | node2 | 3306 | ONLINE | SECONDARY | 8.0.17 |
| group_replication_applier | 2e33b2a7-de7b-11e9-9a21-525400bdd1f2 | node3 | 3306 | ONLINE | SECONDARY | 8.0.17 |
| group_replication_applier | 320675e6-de7b-11e9-b3a9-5254002a54f2 | node1 | 3306 | ONLINE | PRIMARY | 8.0.17 |
+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+
3 rows in set (0.00 sec)

表结构定义

CREATE TABLE `replication_group_members` (
  `CHANNEL_NAME` char(64) NOT NULL,
  `MEMBER_ID` char(36) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `MEMBER_HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `MEMBER_PORT` int(11) DEFAULT NULL,
  `MEMBER_STATE` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8

参考链接：https://dev.mysql.com/doc/refman/5.7/en/replication-group-members-table.html

上一篇： replication_group_member_stats表 | 下一篇： metadata_locks表