1、主库
[mysqld]
server_id=1
log_bin=/xx/x-bin
2、主库建立主从账号
grant replication slave on . to 'repl'@'xx.xx.x.x' identified by 'x';
flush privileges;
3、对主库锁表只读后备份
flush table with read lock;
4、另开一个窗口，导出数据库
mysqldump -A -B|gzip >bak_$(date+%F).sql.gz
5、解锁主库
unlock tables;

查看binlog, show master status/G;

6、DB复制到从库
scp -rp bak_xx.sql.gz root@x.x.x.x:/opt
7、从库
[mysqld]
server_id=2 #ID要不一致
log_bin=/x/x_bin
8、导入数据库
zcat bak_x.sql.gz|mysql
9、配置主从
CHANGE MASTER TO MASTER_HOST='x.x.x.x' MASTER_PORT=3306 MASTER_USER='repo' MASTER_PASSWORD='xxxx' MASTER_LOG_FILE='x-bin.000023' MASTER_LOG_POS=626;
10、启动从库
start slave;

级联方案

A==>B==>C

级联复制中B要开启如下配置

log_bin=/xx/xx-bin
log_slave_updates
expire_logs_days=7