Multi-path
replication can improve replication performance as long as transactions can be divided into
parallel streams, and do not have to be serially committed across different streams.
You
can improve replication performance by dividing transactions into parallel replication
paths to reduce congestion. You can divide transactions according to parallelization
rules such as transaction attributes or derived data values. For example, you can:
- Dedicate paths to specific objects such as tables or stored
procedures. When you bind an object to a path, Replication Agent sends any
replicable actions that you perform upon that object through the path to the
Replication Servers that you define in your multiple replication path
configuration. RepAgent for Adaptive Server and Replication Agent for Oracle
support this replication distribution mode.
- Divide transactions by the session ID of the client connection
on the primary database. RepAgent for Adaptive Server supports distributing
transactions by client connections.
- Dedicate a Replication Server to each path.
- Allocate dedicated paths or less congested paths for priority
replication by binding objects to these paths or by creating dedicated routes
between Replication
Servers.