Centos7.4下MySQL8.0.26克隆主从

==========================参照mysql8.0.26的安装准备好三台空库[已加载克隆插件和组复制插件]=============================
# 检查确认插件
mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME in ('clone','group_replication');
+-------------------+---------------+
| PLUGIN_NAME | PLUGIN_STATUS |
+-------------------+---------------+
| clone | ACTIVE |
| group_replication | ACTIVE |
+-------------------+---------------+
2 rows in set (0.00 sec)

# 手动加载安装MGR插件
mysql> INSTALL PLUGIN clone SONAME 'mysql_clone.so';
mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so';
/*
克隆插件要求执行克隆操作必须加载组复制插件（只是加载组复制插件，并不需要启用）
否则报错：ERROR 3870 (HY000): Clone Donor plugin group_replication is not active in Recipient
*/

##准备好账号 三台上都要操作
create user clone_user identified with mysql_native_password by 'xxxxxx';
grant replication slave,backup_admin, clone_admin on *.* to clone_user;
flush privileges;
show grants for clone_user;

mysql> select host, user, authentication_string, plugin from user;
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
| host | user | authentication_string | plugin |
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
| % | clone_user | *99E1DF02392B4612DBF218686DAC865FB817AB02 | mysql_native_password |
| % | root | *99E1DF02392B4612DBF218686DAC865FB817AB02 | mysql_native_password |
| localhost | mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
| localhost | mysql.session | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
| localhost | mysql.sys | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
5 rows in set (0.00 sec)


# 预备克隆操作
##在执行克隆时，会先将从库本地的数据目录清空，请确保本地数据目录没有重要数据，可以清空，否则将导致本地数据丢失。
SET GLOBAL clone_valid_donor_list = '192.168.100.202:3362'; -------------可使用root用户登陆操作
CLONE INSTANCE FROM 'clone_user'@'192.168.100.202':3362 IDENTIFIED BY 'xxxxxx';----------使用clone_user登陆操作
# 克隆完成后，从库MySQL实例自动重启。

 

# 开启通道[带端口]&启动复制线程
change master to master_host='192.168.100.202',master_user='clone_user',master_password='xxxxxx',master_auto_position=1 for channel 'ms_replication_clone_Jaylon';
#
change master to master_host='192.168.100.202',MASTER_PORT=3362,master_user='clone_user',master_password='xxxxxx',master_auto_position=1 for channel 'ms_replication_clone_Jaylon';

start slave for channel 'ms_replication_clone_Jaylon'\G ;

# 查看状态
show slave status for channel 'ms_replication_clone_Jaylon'\G ;

mysql> show slave status for channel 'ms_replication_clone_Jaylon'\G ;
*************************** 1. row ***************************
Slave_IO_State: Waiting for source to send event
Master_Host: 192.168.100.202
Master_User: clone_user
Master_Port: 3362
Connect_Retry: 60
Master_Log_File: mybinlog.000002
Read_Master_Log_Pos: 3362
Relay_Log_File: Centos-7-relay-bin-ms_replication_clone_jaylon.000002
Relay_Log_Pos: 415
Relay_Master_Log_File: mybinlog.000002
Slave_IO_Running: Yes ------ok
Slave_SQL_Running: Yes ------ok

##
mysqldump -uroot -p --single-transaction --master-data=2 --flush-logs --flush-privileges --routines --all-databases --set-gtid-purged=off > db_fullbackup.sql