binlog2sql快闪回滚

最新推荐文章于 2023-12-09 19:49:44 发布

被遗忘的区域

最新推荐文章于 2023-12-09 19:49:44 发布

阅读量186

点赞数

分类专栏：服务器架构 python语言

西西工作室

本文链接：https://blog.csdn.net/songxi_bo/article/details/108843682

版权

服务器架构同时被 2 个专栏收录

66 篇文章 2 订阅

订阅专栏

python语言

4 篇文章 0 订阅

订阅专栏

yum -y install git wget
yum clean all
mkdir -p /mnt/soft && cd /mnt/soft
wget --ftp-password=z3Qwdq ftp://baosoft@222.209.82.51:5566/linux/binlog2sql.tar.gz
tar zxf binlog2sql.tar.gz -C /usr/local/src/
cd /usr/local/src/binlog2sql/binlog2sql_dependencies
tar xvf setuptools-0.6c11.tar.gz
cd setuptools-0.6c11
python setup.py install
cd …
tar xvf pip-9.0.1.tar.gz
cd pip-9.0.1
python setup.py install
cd …
pip install *.whl mysql-replication-0.9.tar.gz

echo ‘export PATH=$PATH:/usr/local/src/binlog2sql/binlog2sql’ >> /etc/profile
source /etc/profile

#mysql设置
#GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON . TO
#server-id = 1
#log_bin = /var/log/mysql/mysql-bin.log
#max_binlog_size = 1000M
#binlog-format = row

#mysqlbinlog解析二进制日志
mysqlbinlog --base64-output=decode-rows -v --start-datetime=‘2018-08-02 15:15:08’ --stop-datetime=‘2018-08-02 15:18:59’ mysql-bin.000155 >01

#查看日志文件名
ll /mnt/data/mysql/

#binlog2sql读取二进制日志解析出标准SQL
binlog2sql.py -h10.169.154.44 -P3306 -ubinloguser -p’binlog’ -dbaodian_platform -tedai_deposit_e_user --start-file=‘mysql-bin.000155’ --start-datetime=“2018-08-02 15:20:20” --stop-datetime=“2018-08-02 15:20:59” >02

#binlog2sql读取二进制日志解析出回滚SQL
binlog2sql.py --flashback -h10.169.154.44 -P3306 -ubinloguser -p’binlog’ -dbaodian_platform -tedai_deposit_e_user --start-file=‘mysql-bin.000155’ --start-datetime=“2018-08-02 15:20:20” --stop-datetime=“2018-08-02 15:20:59” >0