(mysql.info.gz) Replication Compatibility
Info Catalog
(mysql.info.gz) Replication HOWTO
(mysql.info.gz) Replication
(mysql.info.gz) Replication Upgrade
6.5 Replication Compatibility Between MySQL Versions
====================================================
The original binary log format was developed in MySQL 3.23. It changed
in MySQL 4.0, and again in MySQL 5.0. This has consequences when you
upgrade servers in a replication setup, as described in
Replication Upgrade.
As far as replication is concerned, any MySQL 4.1.x version and any
4.0.x version are identical, because they all use the same binary log
format. Thus, any servers from these versions are compatible, and
replication between them should work seamlessly. The exceptions to
this compatibility is that versions from MySQL 4.0.0 to 4.0.2 were very
early development versions that should not be used anymore. (These
were the alpha versions in the 4.0 release series. Compatibility for
them is still documented in the manual included with their
distributions.)
The following table indicates master/slave replication compatibility
between different versions of MySQL.
*Master* *Master* *Master*
*3.23.33 and *4.0.3 and up *5.0.0*
up* or any 4.1.x*
*Slave* *3.23.33 and yes no no
up*
*Slave* *4.0.3 and yes yes no
up*
*Slave* *5.0.0* yes yes yes
As a general rule, we recommended using recent MySQL versions, because
replication capabilities are continually being improved. We also
recommend using the same version for both the master and the slave.
The preceding information pertains the replication compatibility at the
protocol level. There can also be SQL-level compatibility constraints,
as discussed in Replication Features.
Info Catalog
(mysql.info.gz) Replication HOWTO
(mysql.info.gz) Replication
(mysql.info.gz) Replication Upgrade
automatically generated byinfo2html