MGR重启

MGR 上次搭建OK 后虽然做了个简单的单节点重启, MGR可以自动完成重组和组成员重配.

这次把MGR全部打开了后,发现了各自为重! 并没有自动开启MGR

mysql> SELECT * FROM performance_schema.replication_group_members;

+---------------------------+-----------+-------------+-------------+--------------+

+---------------------------+-----------+-------------+-------------+--------------+

+---------------------------+-----------+-------------+-------------+--------------+

1 row in set (0.00 sec)

mysql> START GROUP_REPLICATION;

ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more details on error log.

mysql> SET GLOBAL group_replication_bootstrap_group=ON;

Query OK, 0 rows affected (0.00 sec)

mysql> START GROUP_REPLICATION;

ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more details on error log.

2019-06-23T11:21:45.187551Z 3 [ERROR] Plugin group_replication reported: 'binlog_checksum should be NONE for Group Replication'

mysql> sET GLOBAL binlog_checksum=none;

Query OK, 0 rows affected (0.42 sec)

mysql> START GROUP_REPLICATION;

Query OK, 0 rows affected (2.75 sec)

mysql> SELECT * FROM performance_schema.replication_group_members;

+---------------------------+--------------------------------------+--------------+-------------+--------------+

+---------------------------+--------------------------------------+--------------+-------------+--------------+

+---------------------------+--------------------------------------+--------------+-------------+--------------+

1 row in set (0.00 sec)

原来两个MGR-SLAVE 是从其他主从关系复制过来的MYSQL系统.

mysql> show slave status\G;

1. row

           Slave_IO_State:               Master_Host: 192.168.2.11              Master_User: rpl              Master_Port: 3306            Connect_Retry: 60          Master_Log_File:       Read_Master_Log_Pos: 4           Relay_Log_File: MYSQL-SLAVE1-relay-bin.000001

怎么还记得老恋人呀?

STOP SLAVE;

RESET SLAVE ALL;

停止,并且清理所有的SLAVE信息.

重新设置主复制通道信息.

CHANGE MASTER TO MASTER_USER='repl',MASTER_PASSWORD='repl' FOR CHANNEL 'group_replication_recovery';

把3个参数添加到MY.CNF中

service mysqld stop

vim /etc/my.cnf

group_replication_allow_local_disjoint_gtids_join=ON

loose-group_replication_bootstrap_group=ON

binlog_checksum=none