List:Replication« Previous MessageNext Message »
From:Chris Kantarjiev Date:September 29 2009 1:29pm
Subject:Re: move master?
View as plain text  
Marcus Bointon wrote:
> On 28 Sep 2009, at 20:33, Chris Kantarjiev wrote:
>> Hmm. I guess I need a little more detail than this. "circular" 
>> replication means master-master? OK, but how do I move the slave when 
>> all the logname information is different?
> You've told us that t is a slave to a, so t already contains everything 
> that's on a, so all you need to do is point all your clients at t, and 
> 'stop slave' on t. No data needs to be moved (unless you have 
> non-replicated stuff you've not told us about). Now you can replace a 
> with your new box (call it 'b'), load it up with a dump form t, set it 
> up as a slave to t (so now b<-t->k). Circular is master-master, so close 
> the loop on that config so then you have: b<->t->k (this is particularly 
> easy if no writes are going to b). At this point you can switch clients 
> to b, and break replication from t to b, leaving you with b->t->k, which 
> is where you were originally with a.

Oh, I see. But in that case, why not just set up 'b' as slave to 'a', get it (and 't')
caught up, 
and then stop a, stop the slave on b, and CHANGE MASTER on t?

> It doesn't matter what you have called your log files - you tell the 
> slave the log file name when you're setting it up with CHANGE MASTER. 
> You don't need to copy log files around to set up a new slave.

Right. I hadn't read that carefully before - thanks.
move master?Chris Kantarjiev28 Sep
  • Re: move master?Marcus Bointon28 Sep
    • Re: move master?Walter Heck - OlinData.com28 Sep
    • Re: move master?Chris Kantarjiev28 Sep
      • Re: move master?Marcus Bointon28 Sep
        • Re: move master?Chris Kantarjiev29 Sep
          • Re: move master?Marcus Bointon29 Sep
    • Re: move master?Chris Kantarjiev28 Sep