Question

Problem with Setting up Master Slave Configuration

  • Posted March 16, 2013

Well, i just followed the steps as mentioned in this tutorial https://www.digitalocean.com/community/articles/how-to-set-up-master-slave-replication-in-mysql . But the changes in Master DB did not reflect in slave DB In my case, Master DB & Slave DB resides on two different droplets. Where could i have gone wrong ?

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

I have created 2 droplets and will try again…Incase if i face same problem i will be back to you :)

And also, /etc/mysql/my.cnf from each server.

To be able to help you, I’d need some more information. Can you please pastebin the output of “show master status;” from your master, “show slave status;” from your slave, the IP address of each server (with labels for “master” and “slave”)?