Post

1 follower Follow
0
Avatar

Loop Prevention

Valid values for *_LOOP_PREVENTION parameters are YES and NO.

In the basic one-way replication *_LOOP_PREVENTION parameters are not required by Dbvisit Replicate at all.

In two-way replication where no change should be propagated further once applied, MINE loop prevention is

used whereas APPLY loop prevention does not get invoked.

In advance configurations such as cascading destinations ( A -> B -> C), APPLY loop prevention is used

and MINE loop prevention is disabled.

APPLY loop prevention can be used in all cases but the disadvantage is that mine and apply have to do

more work by processing changes that eventually get skipped later.

Therefore MINE loop prevention is used in some scenarios (i.e two-way) to achieve good replication performance.

Setup wizard sets correct value for *_LOOP_PREVENTION parameters for advance replication automatically. Although

for some complex configurations ( such as A -> B <=>C <- D) where multiple setup wizards are used manual setting

of *_LOOP_PREVENTION is required to prevent propagating DMLs further once applied.

Donna Zehl Answered

Please sign in to leave a comment.