1 mysq error日志報錯如下:
2014-05-12 11:29:54 22977 [ERROR] Slave SQL: The incident LOST_EVENTS occured on the master. Message: error writing to the binary log, Error_code: 1590
2014-05-12 11:29:54 22977 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log ‘mysql-bin.010275‘ position 91642
2 登入mysql從庫,check slave狀态
從這裡看出來,複制down了。
3,google了很多資料,大部分出現在mysql cluster中,大家的做法都是從新做從庫,或者換個master接入點。
時間緊急,我也隻能從新搭建從庫了,特留此記錄于此,如果有朋友看到這裡,有别的解決方案,非常歡迎留言或者發email到[email protected]