Replication
• Backup your slave instead of your master
– Master won’t 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
Copyright 2002, Jeremy Zawodny (Jeremy@Zawodny.com)