89469

Replication and Server SQL Modę

Using different server SQL modę 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 modę on the master and on the

slave. This advice applies whether you are using statement-based or row-based replication.

If you are replicating partitioned tables, using different SQL modes on the master and the slave is likely

to cause issues. At a minimum, this is likely to cause the distribution of data among partitions to be

different in the master's and slave's copies of a given table. It may also cause inserts into partitioned

tables that succeed on the master to fail on the slave.

For morę information, see Section 5.1.7, “Sen/er SQL Modes".