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

v-for directive in vue completes list rendering

Table of contents 1. List traversal 2. The role o...

Explore how an LED can get you started with the Linux kernel

Table of contents Preface LED Trigger Start explo...

How to enable MySQL remote connection in Linux server

Preface Learn MySQL to reorganize previous non-MK...

The difference and usage of LocalStorage and SessionStorage in vue

Table of contents What is LocalStorage What is Se...

Summary of 3 minor errors encountered during MySQL 8.0 installation

Preface In the past, the company used the 5.7 ser...

How to deploy redis in linux environment and install it in docker

Installation Steps 1. Install Redis Download the ...

Vue uses the method in the reference library with source code

The official source code of monaco-editor-vue is ...

How to install iso file in Linux system

How to install iso files under Linux system? Inst...

Several situations where div is covered by iframe and their solutions

Similar structures: Copy code The code is as foll...

Vue implements a simple magnifying glass effect

This article example shares the specific code of ...

HTML basics HTML structure

What is an HTML file? HTML stands for Hyper Text M...

Sample code for deploying ELK using Docker-compose

environment Host IP 192.168.0.9 Docker version 19...