It is possible for the data on the master and slave to become
different if a statement is designed in such a way that the data
modification is nondeterministic; that is, left up the query
optimizer. (This is in general not a good practice, even outside
of replication.) Examples of nondeterministic statements include
DELETE
or
UPDATE
statements that use
LIMIT
with no ORDER BY
clause; see Section 16.4.1.9, “Replication and LIMIT
”, for a
detailed discussion of these.
Also see Additional Known Issues.
User Comments
Add your own comment.