Question

coniguring databse as master and slave

While performing mysql replication i am observing below issue:

Pre requistes : I have three mysql databases all located on different machines. Lets suppose we have db1,db2,db3 and each of them have one table languages db1 is the master of db2 db2 is the slave of db1 and master of db3 db3 is the slave of db2

Scenario 1 while inserting something in language table of db1 changes are reflected to db2 in language tables but it doesnot propagate to db3 language table.

Expectation - since db3 is the slave of db2 then above change should reflect in db3 as well but its not happening

Scenario 2 but while inserting something in language table of db2 changes are reflected in language table of db3 perfectly.

I dont know whats the gap while inserting into db1

Please suggest if any configuration needs to be done


Submit an answer

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!

Sign In or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

Hey @messielectra

You’re likely running with the log_slave_updates configuration variable disabled. With replication between db1 and db2; the events that are replicated to db2 are not logged in the replication logs (binary logs). Having log_slave_updates enabled on db2 the events are logged to the binary log and will be consumed by db3.

HTH

BR

Andrew