Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'binlog truncated in the middle of event; consider out of disk space on master; the first event 'mysql-bin.001841' at 826366537, the last event read from './mysql-bin.002333' at 2828282975, the last byte read from './mysql-bin.002333' at 2828283169.'
mysqlbinlog ./mysql-bin.002333 --start-position=2828282975
显示2828282975后没有日志,并有错误信息,所以直接使用下一个日志,post为0
stop slave;
change master to master_host='10.0.0.x', master_user='', master_password='', master_log_file=./mysql-bin.002333, master_log_pos=0;
start slave;
show slave status\G
显示正在同步,一切正常