Using mysqldump:
Copying the database files:
Using an online backup method:
Using LVM to get a snapshot:
Using filesystem snapshot methods
***********************************************************
Removing slaves from the topology
Switching the master
Handling slave failures
Handling master failures
Upgrading slaves
Upgrading masters:
To upgrade the master, it is usually necessary to upgrade all the slaves first. How-
ever, this may not always be the case. To upgrade the master, it is usually necessary
to either use a standby as a master while you are performing the upgrade or promote
one of the slaves to be the master for the duration of the upgrade.
Copying the database files:
Using an online backup method:
Using LVM to get a snapshot:
Using filesystem snapshot methods
***********************************************************
Removing slaves from the topology
Switching the master
Handling slave failures
Handling master failures
Upgrading slaves
Upgrading masters:
To upgrade the master, it is usually necessary to upgrade all the slaves first. How-
ever, this may not always be the case. To upgrade the master, it is usually necessary
to either use a standby as a master while you are performing the upgrade or promote
one of the slaves to be the master for the duration of the upgrade.