Further to my replication assignment, I notice there are some triggers on some tables and this may make the scenario more complicated. I encounter a situation which I can't understand very well.
Say, there are two database A and B. DB A contains two tables c and d, while DB B contain two tables e and f. Table c is with the same structure with e and table d is with the same structure with f. DB A is the publisher (with aritcles of tables c and d) and DB B is the subscriber (subscribing tables e and f). There is a trigger in table c. It will insert an record into table d whenever there is an insert into table c. There is no such trigger in table e.
The interesting scenario is as follows. I insert an record in table e, and it is replicated to table c. Thanks to the trigger, it will insert an record in table d. However, not as I expected, the new record in table d will NOT be replicated to table f. If I directly insert an record into table d, it will be replicated to table f.
I enable nested trigger and disable recursive trigger.
Can any one explain this? Thanks!