推荐快速恢复 binlog日志的方法

A:192.168.13.12 (原主库)
B:192.168.13.13 (空实例) binlog server ，需要恢复的binlog在上面
C:192.168.13.14 (从库用于恢复全备)

A 是坏的库现在用 B 和C 去恢复
用B去伪装A库所以A和C的 server-id uuid要一样

说明：192.168.13.14的server-id，uuid要与192.168.13.12一致,依次修改my.cnf 与 auto.cnf

全备A实例：
mysqldump -h127.0.0.1 -uroot -P3306 -pmysql --single-transaction -A --master-data=2 > all.sql

A实例多切换几次 binlog日志
mysql> flush logs;

mysql> insert into test values(10,'bbb');
mysql> insert into test values(11,'bbb');
mysql> insert into test values(12,'bbb');
mysql> insert into test values(13,'bbb');
mysql> insert into test values(14,'bbb');
mysql> insert into test values(15,'bbb');
mysql> insert into test values(16,'bbb');

mysql> flush logs;

A实例：/etc/init.d/mysqld stop 停止服务将binlog考到B实例对应目录下,并且修改权限

将全备考到C实例上并恢复

B实例：
修改mybinlog.index
/data/mysql/mysql3308/data/mybinlog.000001
/data/mysql/mysql3308/data/mybinlog.000002
/data/mysql/mysql3308/data/mybinlog.000003
/data/mysql/mysql3308/data/mybinlog.000004
/data/mysql/mysql3308/data/mybinlog.000005
/data/mysql/mysql3308/data/mybinlog.000006
/data/mysql/mysql3308/data/mybinlog.000007
/data/mysql/mysql3308/data/mybinlog.000008
/data/mysql/mysql3308/data/mybinlog.000009
/data/mysql/mysql3308/data/mybinlog.000010
/data/mysql/mysql3308/data/mybinlog.000011
/data/mysql/mysql3308/data/mybinlog.000012
/data/mysql/mysql3308/data/mybinlog.000013
/data/mysql/mysql3308/data/mybinlog.000014
/data/mysql/mysql3308/data/mybinlog.000015
/data/mysql/mysql3308/data/mybinlog.000016

B实例新建同步账号：
create user 'rep'@'%' identified by 'rep1';
grant replication slave on *.* to 'rep'@'%';

C实例：
将全备考到C实例上并恢复
查看 all.sql中 change master to 语句确实是哪个binglog以及position
-- CHANGE MASTER TO MASTER_LOG_FILE='mybinlog.000012', MASTER_LOG_POS=194;

C实例执行：
change master to master_host='192.168.13.13', master_port=3306, master_user='rep',master_password='rep1',master_log_file='mybinlog.000012',master_log_pos=194;
start slave;
show slave statusG;

START SLAVE UNTIL MASTER_LOG_FILE='mysql-bin.000009, MASTER_LOG_POS=888
start slave until SQL_BEFORE_GTIDS ='22159214-cfae-11e8-a25f-41f6116df06e:71'