MySQL Forums
Forum List  »  Newbie

adding new slave to master slave replication
Posted by: Aiman Kreidly
Date: January 08, 2024 02:58AM

i have master slave replication, 1 master and 2 slaves i want to add new slave to the existing setup from taking backup from working slave
below is what im doing, appreciate if you confirm if im missing any step as once done the replication is not working:
2. Export databases from the existing slave
3.Copy relay-log.info and master.info from existing to the new slave server
4.Import MySQL dump to the new slave server and stop mysqld
5.Edit relay-log.info file
6.edit my.cnf file
7.start slave

Options: ReplyQuote


Subject
Written By
Posted
adding new slave to master slave replication
January 08, 2024 02:58AM


Sorry, only registered users may post in this forum.

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.