MGR Muti-Primary 切换 single_primary 模式

原因:因为希望做ProxySQL+MGR之间Proxy层的消耗测试,需要把原有的MGR多主改为单主模式.

• 修改MGRgroup_replication_single_primary_mode参数为ON

root@localhost [(none)]>show global variables like '%group_replication_single_primary_mode%' ;+---------------------------------------+-------+| Variable_name                         | Value |+---------------------------------------+-------+| group_replication_single_primary_mode | OFF   |+---------------------------------------+-------+1 row in set (0.01 sec)root@localhost [(none)]>set global group_replication_single_primary_mode=ON;ERROR 3093 (HY000): Cannot change into or from single primary mode while Group Replication is running.

• 提示不能在running下进行.只能把集群停下来:
  每个节点执行(注意记住最后的退出的节点):

root@localhost [(none)]>stop group_replication;Query OK, 0 rows affected (9.26 sec)关闭节点后执行:set global group_replication_single_primary_mode=ON;ERROR 1231 (42000): Cannot turn ON single_primary_mode while enforce_update_everywhere_checks is enabled.执行:set global group_replication_enforce_update_everywhere_checks = OFF;set global group_replication_single_primary_mode=ON;Query OK, 0 rows affected (0.00 sec)再一次启动第一个MGR节点:set global group_replication_bootstrap_group=on; start group_replication; 其它节点启动:set global group_replication_bootstrap_group=off;set global group_replication_enforce_update_everywhere_checks = OFF;set global group_replication_single_primary_mode=ON; start group_replication; 一定要执行第2条,否则会报配置不兼容错误: ERROR] Plugin group_replication reported: 'The member configuration is not compatible with the group configuration. Variables such as single_primary_mode or enforce_update_everywhere_checks must have the same value on every server in the group. (member configuration option: [group_replication_enforce_update_everywhere_checks], group configuration option: [group_replication_single_primary_mode]).'