In a Multi-Path Replication™ environment, you can use different
distribution models to achieve parallel replication and improved replication performance by
distributing the replication load from the primary database through the available primary
replication paths originating from the database.
With multiple replication
paths, you can select one of the distribution models:
The default model is distribution by object.
RepAgent does not support more than one distribution model at a time.
Active and Inactive Bindings for Each Distribution ModelDistribution Model |
Active Bindings |
Inactive Bindings |
object |
table, stored procedure |
filter |
connection |
none |
table, stored procedure, filter |
filter |
filter |
table, stored procedure |
Use
sp_replication_path to bind filters or specific objects
such as tables and stored procedures to replication paths. See
Replication Server Reference Manual
> Adaptive Server Commands and System Procedures >
sp_replication_path. RepAgent saves the bindings you
make even if you change distirbution models but only enables the binding if the model
supports the bindings.
You must restart RepAgent and quiesce Replication Server when you change the:
- Distribution model – for example, if the current distribution model is filter,
RepAgent does not distribute any tables or stored procedures along specific
paths that you have defined under the distribution by object model or distribute
transactions according to the distribution by connection model when RepAgents
loads replication paths during startup.
- Replication topology – data loss or data duplication may occur if you do not
restart RepAgent and quiesce Replication Server.