MySQL Forums
Forum List  »  Replication

Re: howto add a slave in a master-mater replication
Posted by: Rick James
Date: April 05, 2014 04:23PM

Stop one of the masters. (Not the one you want to hang the Slave off of.)
Dump it.
Restart that Master.
Load the dump on the new machine.
Make sure all machines have different server_id.
On new Slave, do CHANGE MASTER ..., setting only (?) the MASTER_HOST to point to the Master you did _not_ dump from. Do not modify binlog name and pos; the existing values are correct so that your Slave will continue replicating exactly where the Master was.

Caveat: I may have left out a step.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: howto add a slave in a master-mater replication
855
April 05, 2014 04:23PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.