mysql 主从复制

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