1.介紹
復制2臺以上節(jié)點惜纸，通過binlog實現最終“同步”關系
2.復制前提(搭建過程)
2個以上MySQL實例
源端開啟binlog日志 , 創(chuàng)建復制用戶。
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 各個節(jié)點加載插件
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 創(chuàng)建遠程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
