up vote 3 down vote favorite
1
share [g+] share [fb]

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?

link|improve this question
90% accept rate
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
feedback

1 Answer

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.

link|improve this answer
Make's total sense. Thank you! – Beaming Mel-Bin 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. – Beaming Mel-Bin Dec 14 '11 at 23:37
feedback

Your Answer

 
or
required, but never shown
discard

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