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.
Subject
Views
Written By
Posted
1443
April 02, 2014 10:36AM
Re: howto add a slave in a master-mater replication
855
April 05, 2014 04:23PM
842
April 07, 2014 03:09AM
1066
April 08, 2014 11:28AM
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.