The Replication Manager provides a wizard to help you quickly set up one of several types of working replication environments, including:
warm standby environment
An environment consisting of one primary and multiple replicates
A bidirectional replication environment
After you have created the replication environment, use the Configure Replication wizard to create connections, database replication definitions, and subscriptions for your replication tasks.
Select the environment object you created.
In the right pane, double-click Configure Replication. The Configure Replication wizard appears.
In the Configure Replication wizard, select the type of environment you want to create:
Standard Replication Server warm standby environment. To configure, go to “Configuring a standard warm standby environment”.
An environment where the primary database is replicated to several replicate sites. To configure, go to “Configuring an environment with one primary and multiple replicates”.
Bidirectional replication environment. To configure, go to “Creating a bidirectional replication environment”.
Configuring a standard warm standby environment
If the active server you want to configure does not appear in the list, click Add Server to open the Add Server wizard. Follow the procedure to add servers in “Creating a replication environment object”.
After selecting the type of environment to create from the Configure Replication wizard, click Next.
Select the active server and active database.
Select the Replication Server that will manage the database connections.
Select the standby server and standby database.
Enter the name of the logical connection.
When using an existing connection to create a warm standby logical connection, you must use the existing data server and database names of the active database for the logical connection name. See the Replication Server Administration Guide Volume 2 for more information.
Enter the user name and password of the maintenance user. If the maintenance user does not exist, the wizard creates one for you. Accept the defaults, or enter your own values.
Select the user name and password that the RepAgent will use to connect to the Replication Server. If the RepAgent user does not exist, the wizard creates one for you. Accept the defaults, or enter your own values.
Select the materialization method.
Review the summary information about the replication environment.
If everything looks correct, click Finish. Otherwise, click Back to return to an earlier window and change the replication environment information. Then, return to the final wizard window and click Finish.
Replication Manager creates the following replication objects:
Logical connections
Physical connections
Maintenance user in both active and standby Adaptive Server Enterprise servers.
Configuring an environment with one primary and multiple
replicates
Use this procedure to set up a warm standby environment where data is replicated from one site to many replicate sites using multisite availability (MSA).
Select the primary server and the primary database. Click Next.
Select the Replication Server that will manage the database connections. Click Next.
Select a replicate server, then a corresponding database, and click Add.
The corresponding server.database connection displays in the Connections list.
Repeat this step for each replicate server and replicate database pair you need in your environment. Click Next.
Enter the user name and password of the maintenance user. If the maintenance user does not exist, the wizard creates one for you. Accept the defaults, or enter your own values. Click Next.
All selected connections will use this maintenance user login.
Select the user name and password that the RepAgent will use to connect to Replication Server. If the RepAgent user does not exist, the wizard creates one for you, assigning a default name and password. Accept the defaults, or enter your own values. Click Next.
All connections will use this RepAgent login.
Specify how replicated tables will materialize:
Create Subscription Without Materialization – use this method if the primary data is already loaded at the replicate and updates are not in progress.
Define Subscription for Bulk Materialization – in this method, a subscription is initialized by a user-specified mechanism outside the replication system.
If you chose Define Subscription for Bulk Materialization, click Use Dump Marker in the Transaction Log to use dump and load coordination. Click Next.
Click Finish if everything looks correct in the information summary of replication environment. Otherwise, click Back to return to an earlier window and change the replication environment information. Then, return to the final wizard window and click Finish.
At the end of the configuration, Replication Manager creates the following replication objects:
Physical connections
A database replication definition for the primary database
One or more database subscriptions for each of the replicate databases
Maintenance user in Adaptive Server Enterprise servers
Creating a bidirectional replication environment
Use this procedure to define an environment where data is updated at multiple locations and replicated on each site.
Identify the servers and databases that will be part of the bidirectional replication environment.
Follow steps 3 through 8 in configuring an environment with one primary and multiple replicates.
