级联复制

准备：三台主机

1 master 服务器配置

vim /etc/my.cnf
server-id=1
log-bin=/data/logbin/mysql

mysql> grant replication slave on *.* to repluser@'192.168.36.%' identified by  'centos';

mysqldump -A --single-transaction --master-data=1  -F > /data/all.sql 
scp /data/all.sql 将来的级联从服务器上:/data

2 级联从服务器

vim /etc/my.cnf
server-id=2
log-bin
log_slave_updates
read-only

vim /data/all.sql 
CHANGE MASTER TO
MASTER_HOST='主服务器',
MASTER_USER='repluser',
MASTER_PASSWORD='centos',
MASTER_PORT=3306,
MASTER_LOG_FILE='mariadb-bin.000001', MASTER_LOG_POS=400;   

mysql <  /data/all.sql 
mysql> start slave;

mysqldump -A --single-transaction --master-data=1  -F > /data/all.sql 
scp /data/all.sql 最终的从服务器上:/data

3 最后的从服务器

vim /etc/my.cnf
server-id=3
read-only

vim /data/all.sql 
CHANGE MASTER TO
MASTER_HOST='级联从服务器',
MASTER_USER='repluser',
MASTER_PASSWORD='centos',
MASTER_PORT=3306,
MASTER_LOG_FILE='mariadb-bin.000001', MASTER_LOG_POS=400;   

mysql <  /data/all.sql 
mysql> start slave;

CHANGE MASTER TO
MASTER_HOST='192.168.37.7',
MASTER_USER='repluser',
MASTER_PASSWORD='centos',
MASTER_PORT=3306,
MASTER_LOG_FILE='mariadb-bin.000001', MASTER_LOG_POS=245;