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.`

I found this.

  • 3
    Don't do it if you care about data consistency between the master and slave.
    – akuzminsky
    Jun 3 '14 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 '14 at 21:14
  • to find and fix inconsistencies use pt-table-checksum and pt-table-sync tools
    – akuzminsky
    Jun 3 '14 at 21:15
  • 1
    To skip a single, known query, issue: SET GLOBAL SQL_SLAVE_SKIP_COUNTER:=1; START SLAVE; Jun 4 '14 at 10:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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