1、 在MySQL的生产从库进行mysqlbackup的全备
mysqlbackup --login-path=root --socket=/paic/my$port/var/mysql.sock --backup-dir=$mybackdir_full --backup-image=$mybackdir_full/mybackup.mbi --compress backup-to-image
https://dev.mysql.com/doc/mysql-enterprise-backup/4.0/en/mysqlbackup.backup.html
2、 将备份文件拷贝到目标主机(现在MySQL物理主机的生产从库都挂载WOS卷,备份到WOS下可避免拷贝文件,需在下班之后实施备份)
3、 在目标库进行恢复
mysqlbackup --defaults-file=$mybackdir_full/backup-my.cnf --datadir=/paic/my$port/data --backup_image=$mybackdir_full/mybackup.mbi --backup_dir=$mybackdir_full copy-back-and-apply-log --uncompress
https://dev.mysql.com/doc/mysql-enterprise-backup/4.0/en/mysqlbackup.restore.html
4、 启动数据库
cd /paic/mysql/base
nohup ./bin/mysqld_safe --defaults-file=/paic/my${port}/my.cnf &
5、 为了接续复制需要重新设置gtid_purged,
运行$mybackdir_full/meta/backup_gtid_executed.sql重置gtid_purged
6、 修改MASTER,MASTER_HOST需要设置为生产从库IP
CHANGE MASTER TO MASTER_HOST='*.*.*.*', MASTER_USER='dbsync',Master_Port=3311, MASTER_PASSWORD='******', MASTER_AUTO_POSITION=1;
7、 RESET SLAVE
必须reset,否则会报错:ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository
8、 START SLAVE
9、 SHOW SLAVE STATUS\G