 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
Backup
your slave instead of your master
|
|
|
|
|
Master
wont be interrupted
|
|
|
|
|
Slave
can probably be shut down
|
|
|
|
|
Or
at least you can hold read locks for a long time and
|
|
|
nobody
will care
|
|
|
|
|
Maybe
use different table types on slave
|
|
|
|
|
MyISAM
rather than InnoDB
|
|
|
|
It
may be worth setting up a slave just for doing
|
|
|
|
backups
|
|
|
|
Remember
to backup the master.info file
|
|