Backups from MySQL slave server -- Good idea or bad?

Question

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?

score 2 · Accepted Answer · answered Mar 07 '12 at 21:51

2

No, you should be monitoring your slaves so that you know when they stop replicating, and can fix it.

answered Mar 07 '12 at 21:51

womble

96,255
29
175
230

Not too detailed. You may write a few rows about binlog expirity and possibilities to monitor replicas – Gabor Vincze Mar 08 '12 at 00:16
1

I have found this handy python script to e-mail me when things go wrong http://geert.vanderkelen.org/post/678/ – CamelBlues Mar 12 '12 at 13:30

Backups from MySQL slave server -- Good idea or bad?

1 Answers1