Failed reading log event, reconnecting to retry

haoge0205發表於2016-04-11
資料庫版本:5.6.16

系統:CentOS 6.5

搭建資料庫從庫報錯:
160411 14:30:39 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000004' at position 4279701

協助搭建資料庫從庫,之前同事搭建好了資料庫,只需要將主庫全部dump下來,記錄binlog在從庫還原即可。

change master配置的時候,搭建成功,但是透過 show slave status\G檢視從庫狀態,一會YES,一會NO....

檢視從庫警告日誌:
160411 14:30:39 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000004' at position 4279701

從庫沒有連線成功!

檢查配置檔案的server-id,是另一個從庫的配置檔案,修改即可!

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28939273/viewspace-2079004/,如需轉載,請註明出處,否則將追究法律責任。

相關文章