MySQL 5.0 Reference Manual  /  ...  /  Replication and Server SQL Mode Replication and Server SQL Mode

Using different server SQL mode settings on the master and the slave may cause the same INSERT statements to be handled differently on the master and the slave, leading the master and slave to diverge. For best results, you should always use the same server SQL mode on the master and on the slave.

For more information, see Section 5.1.7, “Server SQL Modes”.

User Comments
Sign Up Login You must be logged in to post a comment.