my2sql

#处理离线sql

my2sql -user root -passwd 111111 -host 127.0.0.1 -port 3308 -mode file  -work-type 2sql -local-binlog-file mysql-bin.007013 -start-file mysql-bin.007013 -start-pos 1111223   -output-dir /data/xx/

 

#伪装成从库解析binlog
./my2sql -user root -password xxxx -host 127.0.0.1 -port 3306 -mode repl -work-type 2sql -start-file mysql-bin.011259 -start-datetime "2020-07-16 10:20:00" -stop-datetime "2020-07-16 11:00:00" -output-dir ./tmpdir
#直接读取binlog文件解析
my2sql -user root -password xxxx -host 127.0.0.1 -port 3306 -mode file -local-binlog-file ./mysql-bin.000060 -work-type 2sql -start-file mysql-bin.000060 -output-dir /data/tmpdir

 

my2sql -user root -password 123456 -host 127.0.0.1 -port 3308 -mode repl -work-type 2sql -start-file mysql-bin.000060 -output-dir /data/tmpdir
my2sql -user root -password 123456 -host 127.0.0.1 -port 3308 -mode file -local-binlog-file ./mysql-bin.000060 -work-type 2sql -start-file mysql-bin.000060 -output-dir /data/tmpdir

#伪装成从库解析binlog
./my2sql -user root -password xxxx -host 127.0.0.1 -port 3306 -mode repl -work-type rollback -start-file mysql-bin.011259 -start-datetime "2020-07-16 10:20:00" -stop-datetime "2020-07-16 11:00:00" -output-dir ./tmpdir
#直接读取binlog文件解析
./my2sql -user root -password xxxx -host 127.0.0.1 -port 3306 -mode file -local-binlog-file ./mysql-bin.011259 -work-type rollback -start-file mysql-bin.011259 -start-datetime "2020-07-16 10:20:00" -stop-datetime "2020-07-16 11:00:00" -output-dir ./tmpdir

my2sql -user root -password 123456 -host 127.0.0.1 -port 3308 -mode repl -work-type stats -start-file mysql-bin.000060 -output-dir /data/tmpdir
my2sql -user root -password 123456 -host 127.0.0.1 -port 3308 -mode file -local-binlog-file ./mysql-bin.000060 -work-type rollback -start-file mysql-bin.000060 -output-dir /data/tmpdir