Shulou(Shulou.com)06/01 Report--

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:

Contributor side execution (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'

Receiver execution (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.11purl 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

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.