CODEWITHSUNDEEP
mysqlreplicationdatabase-replication
Juned
Juned

Reputation: 6326

MySQL : data is not replicating

I have setup master master as well as 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 works fine.

The problem is If I insert row in C then its replicating with A but not with B (as A and B are setup as master slave data should replicate to B as well). But if I insert row in A then its replicating with B.

Here am I missing something, what causes this problem ? Any comments on this will be appreciated.

Regards
Juned Khan

Upvotes: 3

Views: 995

Answers (1)

Bill Karwin
Bill Karwin

Reputation: 562230

You need to set the variable log_slave_updates on A, so that as it plays changes in its replication thread, it also logs those changes to its binary log. Only that way will B receive the same changes.

Upvotes: 4

Related Questions