1、創建複製用户。
create user 'repl'@'%' identified with 'mysql_native_password' by '123456';
grant replication slave on *.* to 'repl'@'%';
2、配置新成員和捐贈者之間異步複製的複製渠道。
change master to master_user='repl', master_password='123456' for channel 'group_replication_recovery';
3、需要指示服務器S1引導該組,然後啓動組複製。
這個引導程序應該只由一個服務器完成,服務器啓動組只執行一次。
set global group_replication_bootstrap_group=on;
start group_replication;
set global group_replication_bootstrap_group=off;
4、確認組複製是否成功啓動。
當STARTGROUP_REPLICATION語句返回時,該組已經啓動。可檢查該組目前是否已創建,幷包括一名成員。
mysql> select * from performance_schema.replication_group_members;
+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION |
+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+
| group_replication_applier | 8eed0f5b-6f9b-11e9-94a9-005056a57a4e | hdp2 | 3306 | ONLINE | PRIMARY | 8.0.16 |
+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+
1 row in set (0.00 sec)
以上就是mysql啓動組複製的方法.