MySQL: data is not replicated
I have a setup wizard as well as a master slave replication with three MySQL servers. My setup is like this ->
I have three servers A, B and C
A --> B = Master Slave
A --> C = Master Master
MySQL version:
mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1
Here master master replication between A and C, master slave replication between A and B is working fine.
The problem is that if I insert a row in C, then its replicated with A, but not with B (since A and B are set as slave data, should also be copied to B). But if I insert a row into A, then replicating it with B.
Am I missing something here, what is causing this problem? Any comments on this would be appreciated.
Regards
Juned Khan
source to share
You need to set the variable log_slave_updates to A so that when you play back changes in its replication stream, it will also write those changes to its binary log. Only in this way will B receive the same changes.
source to share