Methods of taking a snapshot

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.