1.利用MYSQLBACKUP重建
备份一个完整的数据库实例 mysqlbackup --defaults-file=/mysql/data/3306/my.cnf --user=backup --password=backup \ --backup-image=/mysql/backup/backup-db/fullbackup`date +%Y%m%d`.mbi --with-timestamp backup-to-image \ --backup-dir=/mysql/backup/backup-tmp
2.关闭从库
STOP SLAVE; systemctl stop mysqld
3.将备份拷贝至从库
scp root@192.168.18.81:/mysql/backup/backup-db/fullbackup20260512.mbi fullbackup20260512.mbi
4.删除从库数据目录
5.恢复备份
mysqlbackup --backup-image=/mysql/backup/backup-db/fullbackup20260512.mbi image-to-backup-dir \ --backup-dir=/mysql/backup/backup-db/fullbackup20260512 mysqlbackup --defaults-file=/mysql/data/3306/my.cnf apply-log \ --backup-dir=/mysql/backup/backup-db/fullbackup20260512 mysqlbackup --defaults-file=/mysql/data/3306/my.cnf --user=backup --password=backup \ --datadir=/mysql/data/3306/data --backup-dir=/mysql/backup/backup-db/fullbackup20260512 \ --log-bin=/tmp/binlog copy-back
6.修改权限
chown -R mysql:mysql /mysql/data/3306/data chmod 755 /mysql/data/3306/data
7. 启动从库mysql
8.同步
CHANGE REPLICATION SOURCE TO SOURCE_HOST='192.168.18.81', SOURCE_PORT=3306, SOURCE_USER='repuser', SOURCE_PASSWORD='repuser123', GET_SOURCE_PUBLIC_KEY=1, SOURCE_AUTO_POSITION = 1; start replica;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/15412087/viewspace-3117666/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
MGR完全重启流程
下一篇：
没有了~
请登录后发表评论
登录
全部评论
