MySQL Forums
Forum List  »  Replication

Replication daisy chain - statements not carried through
Posted by: Kevin Page
Date: May 06, 2005 01:00PM

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!

Options: ReplyQuote

Written By
Replication daisy chain - statements not carried through
May 06, 2005 01:00PM

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.