Replication daisy chain - statements not carried through
I have a simple replication chain of 3 systems:
SysA -> SysB ->SysC
Replication between SysA and SysB is filtered - only 3 tables get replicated.
Replication between SysB and SysC is unfiltered - everything gets replicated.
Statements from A to B replicate fine, and statements from B to C replicate as well, but statements from A are not getting replicated on C.
There are no error messages in slave status, and the server ID's all appear to be set correctly.
Is it possible that statements are not being passed through because of the filter between A and B? That sounds crazy but we're thinking the statement may be flagged somehow as "filtered" on B, and when C pulls statements from B it skips "filtered" statements.
Any help is much appreciated. Thank you!
Subject
Views
Written By
Posted
Replication daisy chain - statements not carried through
5102
May 06, 2005 01:00PM
2782
May 09, 2005 02:36PM
2484
May 09, 2005 06:45PM
Sorry, you can't reply to this topic. It has been closed.
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.