CLONE INSTANCE
Cloneを使えばさっくりと
mysql> INSTALL PLUGIN clone SONAME 'mysql_clone.so';
Query OK, 0 rows affected (0.11 sec)
mysql> SET GLOBAL clone_valid_donor_list= '172.17.0.3:3306';
Query OK, 0 rows affected (0.00 sec)
mysql> CLONE INSTANCE FROM
[email protected]:3306 IDENTIFIED BY 'ccc';
ERROR 3707 (HY000): Restart server failed (mysqld is not managed by supervisor pro
cess).
mysql> CHANGE MASTER TO master_user= 'gr', master_password= 'ccc' FOR CHANNEL 'gro
up_replication_recovery';
Query OK, 0 rows affected, 2 warnings (0.02 sec)
mysql> SET GLOBAL group_replication_group_seeds= '172.17.0.3:13306,172.17.0.4:1330
6';
Query OK, 0 rows affected (0.00 sec)
mysql> start group_replication;
Query OK, 0 rows affected (3.88 sec)
15/147