89567

Upgrading a Replication Setup

When you upgrade serversthat participate in a replication setup, the procedurę for upgrading depends

on the current server versions and the version to which you are upgrading.

This section applies to upgrading replication from older versions of MySQL to MySQL

5.6.    A 4.0 server should be 4.0.3 or newer.

When you upgrade a master to 5.6 from an earlier MySQL release series, you should first ensure that

all the slaves of this master are using the same 5.6.x release. If this is not the case, you should first

upgrade the slaves. To upgrade each slave, shut it down, upgrade itto the appropriate 5.6.x version,

restart it, and restart replication. The 5.6 slave is able to read the old relay logs written prior to the

upgrade and to execute the statements they contain. Relay logs created by the slave after the upgrade are in 5.6 format.

After the slaves have been upgraded, shut down the master, upgrade itto the same

5.6. x release as

the slaves, and restart it. The 5.6 master is able to read the old binary logs written prior to the upgrade

and to send them to the 5.6 slaves. The slaves recognize the old format and handle it properly. Binary

logs created by the master subsequent to the upgrade are in 5.6 format. These too are recognized by the 5.6 slaves.

In other words, when upgrading to MySQL 5.6, the slaves must be MySQL 5.6 before you can upgrade

the master to 5.6. Notę that downgrading from 5.6 to older versions does not work so simply: You must

ensure that any 5.6 binary log or relay log has been fully processed, so that you can

remove it before

proceeding with the downgrade.

Downgrading a replication setup to a previous version cannot be done once you have switched from

Statement-based to row-based replication, and after the first row-based statement has been written to

the binlog. See Section 16.1.2, “Replication Formats”.

Some upgrades may require that you drop and re-create database objects when you move from

one MySQL series to the next. For example, collation changes might require that table indexes be

rebuilt. Such operations, if necessary, will bedetailed at Section 2.11.1.1, “Upgrading from MySQL

5.5 to 5.6". It is safest to perform these operations separately on the slaves and the master, and to

disable replication of these operations from the master to the slave. To achieve this,

use thefollowing

procedurę