《Mysql应用Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘Could not》要点:
本文介绍了Mysql应用Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘Could not,希望对您有用。如果有疑问,可以联系我们。
导读:在slave启动报错:Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘Could not...
在slave启动报错:
MYSQL实例“Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘Could not find first log file name in binary log index file’”
MYSQL实例解决:报错的原因主要是slave设置master的二进制文件名或pos值不对应!
MYSQL实例先flush logs;清空日志,在查看下主数据库的状态 show master status;看下日志文件名字和position值;
MYSQL实例再在slave中,执行:CHANGE MASTER TO MASTER_LOG_FILE=‘二进制日志名’,MASTER_LOG_POS=值;
MYSQL实例最后启动同步进程:start slave;
转载请注明本页网址:
http://www.vephp.com/jiaocheng/5554.html