MySQL 8.0.18 uses clone plugin to rebuild MGR implementation

MySQL 8.0.18 uses clone plugin to rebuild MGR implementation

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:
  • How to configure MGR single master and multiple slaves in MySQL 8.0.15
  • What are the advantages of MySQL MGR?
  • Detailed explanation of mysql MGR single-master and multi-master mode switching knowledge points
  • mysql 8.0.18 mgr installation and its switching function
  • Detailed explanation of MySQL 5.7 MGR single master determination master node method
  • Common problems and solutions during MySQL MGR construction

<<:  Linux implements the source code of the number guessing game

>>:  WeChat applet component development: Visual movie seat selection function

Recommend

React Routing Link Configuration Details

1. Link's to attribute (1) Place the routing ...

mysql data insert, update and delete details

Table of contents 1. Insert 2. Update 3. Delete 1...

Vue uniapp realizes the segmenter effect

This article shares the specific code of vue unia...

How to test the maximum number of TCP connections in Linux

Preface There is a misunderstanding about the max...

Why the table file size remains unchanged after deleting data in MySQL

For databases that have been running for a long t...

vue element el-transfer adds drag function

The Core Asset Management Project requires el-tra...

Fixed table width table-layout: fixed

In order to make the table fill the screen (the re...

Use tomcat to deploy SpringBoot war package in centos environment

Prepare war package 1. Prepare the existing Sprin...

HTML+CSS+jQuery imitates the search hot list tab effect with screenshots

Copy code The code is as follows: <!DOCTYPE ht...

Three ways to refresh iframe

Copy code The code is as follows: <iframe src=...

Linux file and user management practice

1. Display the files or directories in the /etc d...

Docker Compose practice and summary

Docker Compose can realize the orchestration of D...