The biggest concern with a slave is to ensure your data is consistent with the master! End of story!
3 of the biggest things I see when dealing with out-of-sync slaves:
Of course, if you have a slave, definitely use the --read-only option.
However, SUPER users can still write on slaves with --read-only, so blindly granting SUPER to all users just to save a little time when creating users won’t help. I’d suggest to use SUPER as sparingly as possible (not to mention it’s good for security also).
And the use of --slave-skip-errors=… is generally just a quick fix to avoid[Read more...]