Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Richard Reina (gatorreinagmail.com)
Date: Mon May 06 2013 - 10:06:57 CDT
To activate log-slave-updates do I just add "log-slave-updates" to the
2013/4/30, Manuel Arostegui <manueltuenti.com>:
> 2013/4/30 Richard Reina <gatorreinagmail.com>
>> 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.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql