We're used to Cold, Warm and Hot backups. This scale of three temperatures does not quite reflect the impact of backups on your MySQL database.
In this post I offer a new backup temperature scale, and (somewhat seriously) compare it with showers. Call it the backup shower scale.
A database backup is like a shower: the colder it is, the less time you want to spend doing it.
A cold backup requires taking your database down (i.e. stop the service).
Example: file system copy
This can work well for replicating slaves, which may not be required for normal operation. You take the …[Read more...]