Versions Compared

Version Old Version 1 New Version 2
Changes made by

KrupeshD (Deactivated)

KrupeshD (Deactivated)

Saved on

Key

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

...

Dbvisit Replicate keeps a connection to the source (for mine and fetcher) or target (apply) database.Console keeps connection to both of them, but only if it is used to change the configuration.

Info
titleBest Practice
  • Configure separate TNS identifier for the databases.
  • For each source node, configure the TNS identifier to connect to the local instance

  • only. If possible, do that for target nodes as well.

This ensures that when Replicate is running on a node, it is connecting to one instance only.This limits its dependencies to current node only. The database load imposed by mine is very low on source, so no load balancing is needed. Apply currently executes only one SQL at a time, so the load is also not high – but this will change in the future.

...