To activate log-slave-updates do I just add "log-slave-updates" to the my.cnf file?
2013/4/30, Manuel Arostegui <man...@tuenti.com>: > 2013/4/30 Richard Reina <gatorre...@gmail.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. > > Manuel. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
