Replication Load Distribution

Use the distribution mode supported by the primary database to distribute the replication load over available replication paths.

Distribution Modes

With the Adaptive Server distribution by object binding mode, you can distribute objects such as tables and stored procedures over the multiple paths by binding an object to a specific path. If you match the primary and replicate connection names, the object follows an end-to-end replication path from primary to replicate data server. See Replication Server > Administration Guide: Volume 2 > Performance Tuning > Multi-Path Replication > Multiple Primary Replication Paths > Binding Objects to a Replication Path.

With the Adaptive Server distribution by connection mode, the Adaptive Server RepAgent assigns transactions originated by different client processes to the available replication paths. Over time, the distribution of data tends to be balanced across all available paths. Replication performance improves and replication load distribution is more uniform if there are more RepAgent paths available and the number of client processes is large. See Replication Server > Administration Guide Volume 2 > Performance Tuning > Multi-Path Replication > Parallel Transaction Streams > Distribution Modes for Multi-Path Replication.

Sybase IQ Multiplex Nodes

You can allocate replicate connections to different nodes in a Sybase IQ multiplex to distribute the replication load by creating connections to each node and creating the relevant interfaces file entries. See Sybase IQ > Using Sybase IQ Multiplex.