List:General Discussion« Previous MessageNext Message »
From:Andrew Morgan Date:May 1 2013 3:45pm
Subject:RE: Chain Replication QUestion
View as plain text  
If you're able to use MySQL 5.6 and enable GTIDs then it gets a whole lot simpler as you
don't need to worry about finding the correct positions in the binary logs. Take a look
at http://www.mysql.com/why-mysql/white-papers/mysql-replication-high-availability/ and
http://www.mysql.com/why-mysql/white-papers/mysql-replication-tutorial/

Andrew.

> -----Original Message-----
> From: Rick James [mailto:rjames@stripped]
> Sent: 01 May 2013 16:29
> To: Richard Reina; Manuel Arostegui
> Cc: mysql@stripped
> Subject: RE: Chain Replication QUestion
> 
> > 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
> 
> 
> --
> 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