MySQL Forums
Forum List  »  Replication

Mysql master slave replication
Posted by: tarun gupta
Date: May 27, 2020 06:50PM

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

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 in scenario 1

Please suggest if any configuration needs to be done

Options: ReplyQuote

Written By
Mysql master slave replication
May 27, 2020 06:50PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.