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

Build a severe weather real-time warning system with Node.JS

Table of contents Preface: Step 1: Find the free ...

How to use an image button as a reset form button

When we make a form, we often set a submit button ...

A brief discussion on CSS height collapse problem

Performance For example: HTML: <div class=&quo...

Nginx access log and error log parameter description

illustrate: There are two main types of nginx log...

HTML Tutorial: Collection of commonly used HTML tags (6)

Related articles: Beginners learn some HTML tags ...

Implementation of CSS heart-shaped loading animation source code

Without further ado, let me show you the code. Th...

Detailed explanation of jquery tag selector application example

This article example shares the specific code of ...

Detailed explanation of CocosCreator message distribution mechanism

Overview This article begins to introduce content...

Tutorial on installing the unpacked version of mysql5.7 on CentOS 7

1. Unzip the mysql compressed package to the /usr...

Nodejs module system source code analysis

Table of contents Overview CommonJS Specification...

Vue/react single page application back without refresh solution

Table of contents introduction Why bother? Commun...

Detailed explanation of Object.create instance usage in js

1. Create a new object using the Object.create() ...