MySQL Forums
Forum List  »  Replication

Build a slave from another slave
Posted by: Benny Pei
Date: January 06, 2017 08:27AM

Hi all,

I have a requirement to build a slave from another slave. The current environment is that we have one master and a couple of slaves. The current databases are 5.5 and are running on Solaris. We are in the process of migrating to Linux and perhaps upgrade to 5.6 in one shot. What would be the best way to do such task? I am leaning toward taking a mysqldump from one of the slaves. However I am not sure how I could take the binary log position from the master.

The master is doing row based replication and slaves don't have log-slave-updates enabled currently. It is a pretty simple replication setup.

Your input is appreciated.

thanks,

benny

Options: ReplyQuote


Subject
Views
Written By
Posted
Build a slave from another slave
892
January 06, 2017 08:27AM
443
January 06, 2017 03:51PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.