系统表介绍
replication_group_members 显示了组复制的成员信息
列名 | 含义 |
---|---|
CHANNEL_NAME | 通道名称 |
MEMBER_ID | 成员编号 |
MEMBER_HOST | 成员IP |
MEMBER_PORT | 成员端口号 |
MEMBER_STATE | 成员的状态 |
实例
mysql> select * from performance_schema.replication_group_members;
+---------------------------+--------------------------------------+---------------+-------------+--------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
+---------------------------+--------------------------------------+---------------+-------------+--------------+
| group_replication_applier | 748703ac-dbcc-11e6-a668-90e2bac5d924 | 10.202.44.215 | 24801 | ONLINE |
| group_replication_applier | 8f8bc352-2566-11e7-aa5e-d4ae52ab91b3 | 10.202.44.214 | 24801 | ONLINE |
| group_replication_applier | 9c09340a-e04c-11e6-9916-0024e869a606 | 10.202.44.213 | 24801 | ONLINE |
+---------------------------+--------------------------------------+---------------+-------------+--------------+
3 rows in set (0.00 sec)
————————————————
以上数据摘选自:https://blog.csdn.net/d6619309/article/details/70432640