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
By default, Docker runs over a non-networked UNIX...
Table of contents 1. List traversal 2. The role o...
Table of contents Preface LED Trigger Start explo...
Preface Learn MySQL to reorganize previous non-MK...
Table of contents What is LocalStorage What is Se...
Preface In the past, the company used the 5.7 ser...
Table of contents Get the time in the past week G...
Installation Steps 1. Install Redis Download the ...
The official source code of monaco-editor-vue is ...
How to install iso files under Linux system? Inst...
Table of contents Overview 1. Menu and routing pr...
Similar structures: Copy code The code is as foll...
This article example shares the specific code of ...
What is an HTML file? HTML stands for Hyper Text M...
environment Host IP 192.168.0.9 Docker version 19...