基于全备份+binlog方式恢复数据

基于全备份+binlog方式恢复数据

将bkxt从库的全备份在rescs5上恢复一份，用cmdb操作

恢复全备后执行如下操作

set global read_only=OFF; stop slave; reset slave all;

 

拉取主库的binlog看xtrabackup_slave_info文件内容

 

拉取从库的binlog看xtrabackup_binlog_info和xtrabackup_binlog_pos_innodb

 

 

 

本次只在主库上拉取binlog

# scp mysql-bin.000012 10.10.228.163:/data/recover2019/

分析binlog找到结束点position

/usr/local/mysql/bin/mysqlbinlog --no-defaults -vv --base64-output=DECODE-ROWS mysql-bin.000012 --start-datetime='2019-06-26 15:20:00' --stop-datetime='2019-06-26 15:50:00' > 20190626a.log

 

以position点945174224为例

 

用binlog恢复到指定position

/usr/local/mysql/bin/mysqlbinlog --no-defaults mysql-bin.000012 --start-position=918096986 --stop-position=945174224 |/usr/local/mysql/bin/mysql -ubluewhale -p -S /tmp/mysqld.5306_bkxttest.sock