Use replication definitions and subscriptions to bind a replicate connection for a replicate database and a primary connection for a primary database to create two complete replication paths in an MSA environment.
- Divide transactions into two sets and ensure the transactions can be run in parallel.
For example, you can divide the transactions into two sets of objects such as tables or stored procedures.
- Create a default primary connection to the primary database and create a default replicate connection to the replicate database.
- Create an alternate primary connection to the primary database and create an alternate replicate connection to the replicate database.
- Enable multithreaded RepAgent and two replication paths for RepAgent, and bind the objects to the replication paths.
- Create a replication definition against the primary database.
If the default primary connection and the alternate primary connection are on different Replication Servers, create replication definitions on each Replication Server.
- Create a subscription against the default primary connection and the default replicate connection.
- Create a subscription against the alternate primary connection and the alternate replicate connection.