i have a question related to replication on 4.0.x.
I have the following setup:
A -> B -> C
A is a Master and writes all changes to its binlog (meaning there is no
B acts as Slave from A and as Master for C. As a Slave B has filters set, so
not every change of every database and table is beeing replicated from the
relaylog. As Master there are also filters set, so not every database is
written to the binlog. On B log-slave-updates is set.
C replicates as a Slave of B and also has filters set, so not every database
and table is replicated from B.
Now, there is a table system.subscribers. This table exists on A, B and C.
This table is based on MyISAM, so i started the replication on B by calling
LOAD DATA FROM Master. Same on C. This worked so far. Now when i change a
record in the subscribers table, the changes are replicated from A to B and
from B to C. That also works as expected. But now there is a field in the
subscribers table, that will NEVER be changed on A but has to be changed on
B. When i do such a change on B, i expect this change to be replicated to C
but this does not happen.
So now my question is: is it basically possible to do this or doesn't mysql
replication mechanism support this setup? If it is possible: Any idea where
the problem could be? If it's not possible: any idea for a different setup
that would allow to this?
Thanks a lot for your help.