I have a already existing master slave replication setup. I want to create a new slave but I cannot ssh to the existing slave machine due to some issue with the slave so I cannot copy the relay log files and master.info file. I can however connect to slave mysql using workbench and can stop slave replication if i want. I have full acess to the master instance. Is there a way that I can create new slave ?
I am using mariadb 5.5. Thanks

New contributor
megamind is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • You can always create new slave server from the existing Master server. Check the steps here: dev.mysql.com/doc/refman/5.7/en/replication-setup-slaves.html – Madhur Bhaiya Sep 11 at 12:57
  • @MadhurBhaiya Should I follow same steps, that i followed in creating the old slave..also will master have two different logs files? – megamind Sep 11 at 13:00
  • Yes, the way you setup the first slave using Master. No, there should not be two different log files. – Madhur Bhaiya Sep 11 at 13:03

Your Answer

megamind is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.