The following sections provide information about what is supported and what is not in MySQL replication, and about specific issues and situations that may occur when replicating certain statements.
In general, replication compatibility at the SQL level requires
that any features used be supported by both the master and the
slave servers. If you use a feature on a master server that is
available only as of a given version of MySQL, you cannot
replicate to a slave that is older than that version. Such
incompatibilities are likely to occur between series, so that, for
example, you cannot replicate from MySQL 4.1 to
4.0. However, these incompatibilities also can occur
for within-series replication. For example, the
CONVERT_TZ() function is available
in MySQL 4.1.3 and up. If you use this function on the master
server, you cannot replicate to a slave server that is older than
Additional information specific to
replication is given in
Section 18.104.22.168, “InnoDB and MySQL Replication”.