MySQL 8.0.18 rebuilding MG with clone plugin
Suppose a node in the three-node MGR is abnormal, and the node needs to be re-added to the MGR cluster. The specific operation process is as follows:
The contributor executes (192.168.1.11) DROP USER 'donor_clone_user'@'192.168.1.12';CREATE USER' donor_clone_user'@'192.168.1.12' IDENTIFIED BY 'password';GRANT BACKUP_ADMIN on *. * to' donor_clone_user'@'192.168.1.12';INSTALL PLUGIN clone SONAME 'mysql_clone.so' The receiver executes (192.168.1.12) DROP USER 'recipient_clone_user'@'192.168.1.12';CREATE USER' recipient_clone_user'@'192.168.1.12' IDENTIFIED BY 'password';GRANT CLONE_ADMIN on *. * to' recipient_clone_user'@'192.168.1.12';INSTALL PLUGIN clone SONAME 'mysql_clone.so';SET GLOBAL clone_valid_donor_list =' 192.168.1.11 recipient_clone_user'@'192.168.1.12' IDENTIFIED BY 3311' Exitmysql-urecipient_clone_user-ppassword-h 192.168.1.12-P3311CLONE INSTANCE FROM 'donor_clone_user'@'192.168.1.11':3311 IDENTIFIED BY' password';exitmysql-uroot-pstart group_replication;select * from performance_schema.replication_group_members