AWS RDS binlog 读取

下载 aws rds binlog 并转换成 sql 的脚本

# download_and_convert_binlog.sh

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37

#!/bin/bash   logFile=$1   mysqlbinlog \     --read-from-remote-server \     --host=xxx.ap-east-1.rds.amazonaws.com \     --port=3306  \     --user admin \     --password \     --raw \     --result-file=/data1/ \     $logFile   function getBinlogStartTime() {     theFile="$1"     #取出文件头做分析     binlogHead=`hexdump ${theFile} | head -1`       #binlog文件校验     binlogCrc=`echo $binlogHead | awk '{print $1$2$3}'`     if [ "${binlogCrc}" != '000000062fe6e69' ]; then         echo '${theFile} is damage.'         exit 1     fi       #计算binlog的开始时间     binlogBeginTimeInt=`echo $binlogHead | awk '{print $5$4}' | gawk ' { printf strtonum("0x" $0)}'`       binlogBeginTime=`date -d "1970-01-01 UTC $binlogBeginTimeInt seconds" "+%F %T"`     echo $binlogBeginTime }   getBinlogStartTime $logFile   # binlog 转换成 sql mysqlbinlog $logFile -r $logFile.sql

 

脚本执行

?

1	bash download_and_convert_binlog.sh mysql-bin-changelog.057167

 

查看 binlog 文件名

?

1	SHOW BINARY LOGS;