I'm have one MySQL master and two MySQL slaves set up to replicate. I'm running my database backup process, consisting of an
Xtrabakup (via the perl wrapper
Innobackupex) backup and an atomic
mysqldump, off one of the slaves. This morning, I noticed the slave I do the backup from had stopped replicating a few days ago, meaning my backups were out of sync with the master.
Should I be backing up from the master?