1.介绍

复制2台以上节点，通过binlog实现最终“同步”关系

2.复制前提(搭建过程)

2个以上MySQL实例
源端开启binlog日志 , 创建复制用户。
mysql> select @@log_bin;
mysql> select @@log_bin_basename;
mysql> create user repl@'10.0.0.%' identified with mysql_native_password by '123';
mysql> grant replication slave on . to repl@'10.0.0.%';
server_id server_uuid不同
mysql> select @@server_id;
mysql> select @@server_uuid;
+--------------------------------------+
| @@server_uuid |
+--------------------------------------+
| 1cc19357-f1b9-11ea-b9cc-000c29914382 |
+--------------------------------------+
1 row in set (0.00 sec)

mysql> set global server_id=8;

版本一般一致
从库的数据同步(mysqldump xtrabackup clone plugin).
远程克隆
4.2.0 各个节点加载插件
INSTALL PLUGIN clone SONAME 'mysql_clone.so';
或
[mysqld]
plugin-load-add=mysql_clone.so
clone=FORCE_PLUS_PERMANENT

SELECT PLUGIN_NAME, PLUGIN_STATUS
FROM INFORMATION_SCHEMA.PLUGINS
WHERE PLUGIN_NAME LIKE 'clone';

4.2.1 创建远程clone用户

捐赠者(source)授权

create user test_s@'%' identified by '123';
grant backup_admin on . to test_s@'%';

接受者(target)授权

create user test_t@'%' identified by '123';
grant clone_admin on . to test_t@'%';

4.2.2 远程clone(目标端)

开始克隆

SET GLOBAL clone_valid_donor_list='10.0.0.51:3306';

mysql -utest_t -p123 -h10.0.0.52 -P3306
CLONE INSTANCE FROM test_s@'10.0.0.51':3306 IDENTIFIED BY '123';

告诉从库连接信息,从什么位置开始自动复制 change master to

mysql> select *from performance_schema.clone_status\G

help change master to 可以查看这个模板
CHANGE MASTER TO
MASTER_HOST='10.0.0.51',
MASTER_USER='repl',
MASTER_PASSWORD='123',
MASTER_PORT=3306,
MASTER_LOG_FILE='mysql-bin.000005',
MASTER_LOG_POS=156,
MASTER_CONNECT_RETRY=10;

启动专用复制线程 start slave;
mysql> start slave ;
mysql> show slave status \G

主从复制