重做主从复制时,手动删除从库中继日志,之后开启从库时报错:
[ERROR] Slave SQL: Slave failed to initialize relay log info structure from the repository, Error_code: 1872
由于是rm删除中继日志,导致mysql无法进一步处理相关日志,此时需要reset
mysql>reset slave
查看主库的日志位置,change后重启复制进程
mysql>change master to master_log_file='mysql-bin.000368',master_log_pos=596264036;
mysql>start slave;