Assume that a node in the three-node MGR is abnormal and 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'; Execution on the receiver side (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:3311'; exit mysql -urecipient_clone_user -ppassword -h 192.168.1.12 -P3311 CLONE INSTANCE FROM 'donor_clone_user'@'192.168.1.11':3311 IDENTIFIED BY 'password'; exit mysql -uroot -p start group_replication; select * from performance_schema.replication_group_members; The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM. You may also be interested in:
|
<<: Linux implements the source code of the number guessing game
>>: WeChat applet component development: Visual movie seat selection function
Table of contents Preface: Step 1: Find the free ...
When we make a form, we often set a submit button ...
Performance For example: HTML: <div class=&quo...
illustrate: There are two main types of nginx log...
Related articles: Beginners learn some HTML tags ...
Without further ado, let me show you the code. Th...
This article example shares the specific code of ...
1. Install MySQL: Use the following three command...
In this article, I will explain the relevant cont...
Overview This article begins to introduce content...
1. Unzip the mysql compressed package to the /usr...
Current demand: There are two tables, group and f...
Table of contents Overview CommonJS Specification...
Table of contents introduction Why bother? Commun...
1. Create a new object using the Object.create() ...