Shulou(Shulou.com)06/01 Report--

mysql 5.1 master-master replication cluster 1062 Out of sync error

1062 error reported from the slave library, master-slave replication stopped.

Start using SET GLOBAL SQL_SLAVE_SKIP_COUNTER = N to skip some duplicate data, primary keys, etc.

Finally found too much data, re-import the master database to the slave database.

Check:

show slave status \G

Seconds_Behind_Master: 0

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

These three values.

Inquiry:

Exec_Master_Log_Pos Slave_SQL_Running_State, Last_Errno, Last_Error, Last_IO_Errno, Last_IO_Error, Last_SQL_Errno, Last_SQL_Error Look at several values.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.