1

Preparation

Install and start two solidDB^® database servers.

2

Configuring the servers and creating the publications.

Configure the servers as master and replica.

Define a table in both the master and replica databases that meets the advanced replication design requirements.

Define a sample publication in the master database.

3

Creating stored procedures for populating master and replica databases

Create stored procedures for inserting and updating data in the master and replica databases.

4

Using synchronization functionality

Register the sample publication, update the replica database, and save the transactions for propagation to the master database.

5

Synchronize data by implementing synchronization messages

Synchronize the master and replica databases by issuing advanced replication SQL commands from a console.