Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from impossible position'

mysql replication 에러중 아래와 같이 뜬다면

Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from impossible position'

에러가 뜬다면

master 서버에서 확인후

mysql> show master status;

+------------------+----------+--------------+------------------+

| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |

+------------------+----------+--------------+------------------+

| mysql-bin.000007 |    456 |              |                  |

+------------------+----------+--------------+------------------+

1 row in set (0.00 sec)

CHANGE MASTER TO MASTER_HOST='192.168.0.55', MASTER_USER='backup', MASTER_PORT=3306, MASTER_PASSWORD='1234', MASTER_LOG_FILE='mysql-bin.000007', MASTER_LOG_POS=456;

빨간 부분을 추가해서 적용시켜 주면 된다.

빨간부분은 position 수치다