Getting started with Advanced Replication: an evaluation setup

This topic gives instructions on setting up a simple Advanced Replication system that demonstrates the basic functionality of synchronizing data between two databases. The topic contains sample scripts that are also included in the solidDB installation package.

Instead of going through the steps in this topic and setting up the evaluation environment manually, you can use the Advanced Replication sample that is shipped with solidDB, see Advanced Replication sample.

The evaluation setup procedure assumes the following familiarity with working with solidDB:

▪ Basic administration of solidDB, such as installing, starting, shutting down, configuring network names, and so on.

▪ Working with solidDB, such as connecting to the database, running SQL statements.

Note In Advanced Replication, synchronization is implemented with SQL statements. The data synchronization SQL statements that are described in this section can be used with the solidDB SQL Editor (solsql), as well as with the ODBC and JDBC APIs.

▪ Fundamentals of solidDB Advanced Replication architecture.

Note The steps and scripts use a number of system stored procedures to configure the synchronization environment. Instead of using the stored procedures, you can configure the environment by using SQL statements. For more information about the SQL statements, see Setting up databases for synchronization.

If the set up of the Advanced Replication environment (by using the stored procedures) fails for any reason, you might need to use the SQL statements to remove and modify configuration information.

To set up, configure, and use solidDB to use the Advanced Replication technology sample, complete the following steps:

1 Install and start two solidDB database servers, see Preparing the environment for Advanced Replication.

2 Design a table that meets the Advanced Replication design requirements, see Designing a database table for synchronization.

3 Configure a server as the master database, create the table, and define the publication, see Configuring master database.

4 Configure a server as the replica database, create the table, and register the publication, see Configuring the replica database.

5 Create stored procedures for populating master and replica databases, see Creating stored procedures for populating master and replica databases.

6 Update the replica database, and save the transactions for propagation to the master database, see Enabling refresh of data and inserting data in replica.

7 Synchronize the master and replica databases by issuing Advanced Replication SQL statements from a console, see Synchronizing data by using synchronization messages.