After setup replication, I start to create a few database login. And the next day, I found that the database replication is stopped. The error code is 1396 which indicate the failure of create user.
However, when i checked into the database, the database login is created successfully. I restart the slave a few time but replication still failed to start.
Then I google and found this solution.
The workaround is add the following line into my.cnf, then restart the slave database:
slave_skip_errors=1396
No comments:
Post a Comment