MGR 添加新节点

# 导出数据
innobackupex --defaults-file=/data/mysql3306/my.cnf --user='xxx' --password='xxx' --parallel=4 --host='127.0.0.1' --port=3306 --no-timestamp --stream=xbstream . | ssh 10.x.x.x "cat - > /data/tmp/recover/xtrabak3306.xbstream"

# 恢复数据
xbstream --parallel=16 -x < /data/tmp/recover/xtrabak3306.xbstream -C /data/tmp/recover/
innobackupex --apply-log /data/tmp/recover/
innobackupex --defaults-file=/data/mysql3306/my.cnf --move-back /data/tmp/recover/

# 设置同步点
cat   /data/tmp/recover/xtrabackup_binlog_info

//  reset master + set global  gtid_purged 组合
reset master;
set global gtid_purged='156af709-08b3-4d93-a40f-89dd8c7d67AA:1-325,
1a1650d9-889f-11e8-8dcf-246e96d6d7f6:3409237-38474AA:38832-51066';

# 开启组复制
CHANGE MASTER TO MASTER_USER='repl', MASTER_PASSWORD='XXXXXX' FOR CHANNEL 'group_replication_recovery';
start group_replication;