MySQL Group Replication–节点down机对GR组的影响(single-primary mode)
这个模式下,group内只有一台节点可写可读,其他节点只可以读。
环境信息
节点down掉之前,先来描述下当前GR组的成员和状态:
当前GR组的成员为:
mysql> select * from performance_schema.replication_group_members ;
+---------------------------+--------------------------------------+---------------+-------------+--------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
+---------------------------+--------------------------------------+---------------+-------------+--------------+
| group_replication_applier | 2c27df35-de6b-11e8-ae95-525400dd0d42 | 10.202.10.122 | 24801 | ONLINE |
| group_replication_applier | 545de62a-e02e-11e8-8161-525400dd0d42 | 10.202.10.123 | 24802 | ONLINE |
| group_replication_applier | fffe345a-de9a-11e8-ad8e-525400dd0d42 | 10.202.10.125 | 24803 | ONLINE |
+---------------------------+--------------------------------------+---------------+-------------+--------------+
3 rows in set (0.00 sec)
查看当前GR组主master,官方提供的方法:
mysql> select * from performance_schema.global_status where VARIABLE_NAME ='group_replication_primary_member';
+----------------------------------+--------------------------------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+----------------------------------+--------------------------------------+
| group_replication_primary_member | 2c27df35-de6b-11e8-ae95-525400dd0d42 |
+----------------------------------+--------------------------------------+
或者你可以使用以下方法看当前GR组的主节点信息
SELECT *
FROM performance_schema.replication_group_members
WHERE MEMBER_ID = (
SELECT VARIABLE_VALUE FROM performance_schema.global_status WHERE VARIABLE_NAME= 'group_replication_primary_member'
);
+---------------------------+--------------------------------------+---------------+-------------+--------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
+---------------------------+--------------------------------------+---------------+-------------+--------------+
| group_replication_applier | 2c27df35-de6b-11e8-ae95-525400dd0d42 | 10.202.10.122 | 24801 | ONLINE |
+---------------------------+--------------