Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Active - Active or 2-way replication is very similar to 1-way replication. This is used when changes can be made to both databases and they both must be kept in sync. 

...

The differences between 1-way replication and 2-way replication are:

  1. There is a Mine MINE and Apply APPLY processes running on each server. With 1-way replication there is only an Apply APPLY OR a Mine MINE process running on each server. 
  2. Changes that are mined on the source server and then applied on the target server are not mined again on the target server. This prevents the feedback loop.
  3. The Mine MINE and Apply APPLY processes are paired together. So in a typical 2-way replication there are the following 2-pairs: 

...

Each run script ( reptest1-run-dbvldemo101.sh and reptest1-run-dbvldemo102.sh) has commands to start both a Mine MINE and Apply APPLY on each server.


Dbvisit Replicate command console

...

With 2-way replication the table listing in the console can so long that the prompt cannot be seen. By default, 30 tables are listed for each replication, thus for a 2-way replication, it takes up to 70 screen lines.
To change this, edit the *-MINE.ddc file and add line "set STATUS_BAR_ACTIVE_TABLES 5". Or enter this command at the console prompt. Restart the console for this change to take affect.