mysql-Learning -13-20170621-mysql Backup Recovery-xtrabackup-3

mysql-Learning -13-20170621-mysql Backup Recovery-xtrabackup-3

MariaDB Mysqlbinlog 10.2 Belt

"Admin" Wu Bingxi (82565387) 20:35:31
Maxscale Proxy: Support semi-synchronous
The two tools under Binlog Server can support Binlog rollback BINLOG Server

Mysqlbinlog_sql

Https://github.com/danfengcao/binlog2sql
"Admin" Wu Bingxi (82565387) 20:36:25
Https://github.com/danfengcao/binlog2sql
Mysqlbinlog_sql
"Admin" Wu Bingxi (82565387) 20:38:15
shell> git clone https://github.com/danfengcao/binlog2sql.git && CD Binlog2sql
shell> Pip Install-r requirements.txt
Yum install python-pip.noarch Yum search pip

Direct recovery, non-annotated way:

No Gtid related information

#/usr/local/mysql/bin/mysqlbinlog--skip-gtids--start-position=898--stop-position=1423 mysql-bin.000001 |mysql-s/ Tmp/mysql3307.sock-p--binary-mode

TRUNCATE TABLE WUBX;

Big strokes, using: Sql_thread data below the red is the idea of recovery!!! #ls mysql-bin.*|awk-f ' {print ' mv ' $ relay-bin. ' $ '

Special method for renaming

mysql-Learning -13-20170621-mysql Backup Recovery-xtrabackup-3