Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We currently have one master server that is replicated to two read-only slaves. We are adding to the schema. Is it recommended to reload the master first or the slaves?

share|improve this question
I'm not sure, but there is some logic to the fact when you add a schema, that you restart the master first, who then propagates it to the slaves no ? I mean that's how it works in MySQL or most master/slaves configuration. – Lucas Kauffman Dec 14 '11 at 21:58
up vote 4 down vote accepted

When adding a new schema, reload the slaves first, so that they won't receive updates of unknown object-types at any time.

Otherwise if you would have to remove a schema, do it on the master first.

share|improve this answer
Make's total sense. Thank you! – Belmin Fernandez Dec 14 '11 at 22:01
...and it should go without saying, but I'll say it anyway: Make a backup first! – voretaq7 Dec 14 '11 at 22:06
BTW: I haven't asked if you're using slurpd or syncrepl for replication ... but it makes no difference therefore – powo Dec 14 '11 at 22:44
Slurpd in my case. – Belmin Fernandez Dec 14 '11 at 23:37

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.