List:General Discussion« Previous MessageNext Message »
From:Rick James Date:May 1 2013 3:29pm
Subject:RE: Chain Replication QUestion
View as plain text  
> 1) Enable log-bin on master2 (slave that will be converted to a master)
That does not 'convert' it -- it makes it both a Master and a Slave (a "Relay").

The CHANGE MASTER is probably correct, but it is difficult to find the right spot.
A simple way is to 
1. Stop all writes everywhere.
2. Wait for replication to catchup everywhere.
3. FLUSH LOGS everywhere.
4. Now CHANGE MASTER on the Slave to the start (POS=0 or 4) of the freshly created binlog
in the machine that is the Slave's new Master.
5. Start writes.


> -----Original Message-----
> From: Richard Reina [mailto:gatorreina@stripped]
> Sent: Wednesday, May 01, 2013 6:00 AM
> To: Manuel Arostegui
> Cc: mysql@stripped
> Subject: Re: Chain Replication QUestion
> 
> Hello Manuel,
> 
> Thank you for your reply. Could I do the following?:
> 
> 1) Enable log-bin on master2 (slave that will be converted to a master)
> 2) Enable log-slave-updates on master2
> 3) Execute CHANGE MASTER to on another existing slave so that it gets
> it's updates from master2 instead of master1.
> 
> Thanks for the help thus far.
> 
> 
> 2013/4/30, Manuel Arostegui <manuel@stripped>:
> > 2013/4/30 Richard Reina <gatorreina@stripped>
> >
> >> I have a few slaves set up on my local network that get updates from
> >> my main mysql database master. I was hoping to turn one into a
> master
> >> while keeping it a slave so that I can set up a chain.  Does anyone
> >> know where I can find a "how to" or other documentation for this
> >> specific task?
> >>
> >>
> > It is quite easy:
> >
> > Enable log-slave-updates in the slave you want to be a master.
> > Do a mysqldump -e --master-data=2 and put that mysqldump in the
> future
> > slaves. Take a look at the first lines of the mysqldump where you'll
> > find the position and logfile those slaves need to start the
> replication from.
> > You can also use xtrabackup if you like.
> >
> > Manuel.
> >
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql

Thread
Chain Replication QUestionRichard Reina30 Apr
  • Re: Chain Replication QUestionManuel Arostegui30 Apr
    • Re: Chain Replication QUestionRichard Reina1 May
      • RE: Chain Replication QUestionRick James1 May
        • RE: Chain Replication QUestionAndrew Morgan1 May
    • Re: Chain Replication QUestionRichard Reina6 May
      • Re: Chain Replication QUestionMichael Dykman6 May