Mysql Error 1236

Got fatal error 1236 from master when reading data from binary log: ‘Could not find first log file name in binary log index file’

마스터에 포지션을 잃어버려서 발생하는 이슈이다.

stop slave 이후에

CHANGE MASTER TO MASTER_HOST=’172.20.102.18′, MASTER_USER=’name’, MASTER_PASSWORD=’password’, master_log_file=’binlog.000001′, master_log_pos=1;

해주면 된다.

Published by

shotan

Hi i'm cho

Leave a Reply

Your email address will not be published. Required fields are marked *