Common Problems
•
Auto-increment fields
•
User variables
•
Improper sync of a new slave
•
Cross database queries and slave filtering
•
Binary (or relay) logs use all your disk
space!
•
Version mismatch
•
LOAD TABLE … FROM MASTER
–
Not for InnoDB