binlog2sql binlog解析与回滚

• 用途

1. 数据快速回滚(闪回)
2. 主从切换后新master丢数据的修复
3. 从binlog生成标准SQL，带来的衍生功能

• 安装
  git clone https://github.com/danfengcao/binlog2sql.git && cd binlog2sql
  pip install -r requirements.txt

• mysql参数设置
  [mysqld]
  server_id = 1
  log_bin = /var/log/mysql/mysql-bin.log
  max_binlog_size = 1G
  binlog_format = row
  binlog_row_image = full

• 对用户赋权
  GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON . TO ‘glon’@’%’ IDENTIFIED BY ‘glon’

• 通过模糊时间点解析binlog
  python binlog2sql/binlog2sql.py -h127.0.0.1 -P3306 -uglon -p’glon’ -d test -t tb1 --start-file=‘mysql-bin.000052’ --start-datetime=‘2016-12-13 20:25:00’ --stop-datetime=‘2016-12-13 20:30:00’

• 使用flashback模式生成回滚sql
  -------使用时间点
  python binlog2sql/binlog2sql.py -h12