23.MySQL -MGR修复方法2

1.主库备份

mysqldump --master-data=2 --single-transaction --user=root --password='rootroot' \
-h192.168.1.11 -P3306 \
-B data_api data_center_job ds_kettle it_int kettle rocp rpa rpa_process tiiia_soa > all.sql

2.关闭MGR;

show variables like 'super_read_only';
stop group_replication;

3.允许导入

set global super_read_only=0;

set global read_only=0;
reset master;
mysql -uroot -proot < all.sql

4.启动MGR 
start group_replication;
mysql> select * from performance_schema.replication_group_members;
+---------------------------+--------------------------------------+-------------+-------------+--------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
+---------------------------+--------------------------------------+-------------+-------------+--------------+
| group_replication_applier | 25685742-8b12-11ec-a7bc-005056991440 | SJFU-008 | 3306 | ONLINE |
| group_replication_applier | 3f5af718-8b14-11ec-972a-005056997022 | SJFU-010 | 3306 | ONLINE |
| group_replication_applier | ced5fc65-8b14-11ec-b51b-00505699c2a0 | SJFU-009 | 3306 | ONLINE |
+---------------------------+--------------------------------------+-------------+-------------+--------------+
3 rows in set (0.00 sec)

show variables like 'super_read_only';

show variables like 'read_only';

5.启动keepalived服务

启动keepalive;
sudo systemctl enable keepalived