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