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

  • 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 '19 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 '19 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 '19 at 13:03

Your Answer

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.