Report this

What is the reason for this report?

Problem with Setting up Master Slave Configuration

Posted on 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 ?



This textbox defaults to using Markdown to format your 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.

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”)?

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

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

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.