MySQL Forums
Forum List  »  Newbie

Adding slaves to replication environment
Posted by: Dmitry Pal
Date: July 31, 2009 10:01AM

I want to add additional slave to an existing replication environment. I read the reference materials about this, but am wondering if this approach would work:

Initial setup is a Master and one Slave.

On the Slave:
1) Issue "STOP SLAVE"
2) Record the binary log name and position using "SHOW SLAVE STATUS"
3) Create mysqldump.
4) Issue "START SLAVE"

Now on the new Slave that I want to add:
5) Set a unique server id in my.cnf
6) Start mysql
7) Import mysqldump from step 3
8) Issue "CHANGE MASTER TO ..." with binary log name and position from step 2
9) Issue "START SLAVE"

Thank you

Options: ReplyQuote

Written By
Adding slaves to replication environment
July 31, 2009 10:01AM

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.