Repair Replication

로그확인

grep mysql /var/log/syslog

SHOW SLAVE STATUS

다음 값 확인

Slave_IO_Running: Yes

Slave_SQL_Running: No

Repairing The Replication

1.STOP SLAVE;

2.SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;

3.START SLAVE;

4.SHOW SLAVE STATUS \G

로그 확인

grep mysql /var/log/syslog