-2

If I become a MySQL DBA, will I had to deal all day with those kind of issues or do you have tips to prevent from breaking the whole replication?

I received this message because I removed manually the database, and after that the php script remove it.

Last_SQL_Errno: 1133`
Error 'Can't find any matching row in the user table' on query.`

1 Answer 1

-3

I found this.

slave-skip-errors=1133
4
  • 4
    Don't do it if you care about data consistency between the master and slave.
    – akuzminsky
    Jun 3, 2014 at 21:13
  • To prevent errors like that put the slave in read_only mode and make sure MySQL clients don't have SUPER privilege.
    – akuzminsky
    Jun 3, 2014 at 21:14
  • to find and fix inconsistencies use pt-table-checksum and pt-table-sync tools
    – akuzminsky
    Jun 3, 2014 at 21:15
  • 1
    To skip a single, known query, issue: SET GLOBAL SQL_SLAVE_SKIP_COUNTER:=1; START SLAVE; Jun 4, 2014 at 10:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.