3

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?

1
  • 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. Dec 14, 2011 at 21:58

1 Answer 1

4

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.

3
  • ...and it should go without saying, but I'll say it anyway: Make a backup first!
    – voretaq7
    Dec 14, 2011 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, 2011 at 22:44
  • Slurpd in my case. Dec 14, 2011 at 23:37

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .