Configuring and administering synchronization environment
You configure and administer the solidDB Advanced Replication environment by using SQL statements and system stored procedures.
Typically the setup of the Advanced Replication environment includes the following steps:
1 Set up master database
a Define the database as a master database and create a catalog for synchronization.
b Create a publication to define the data set that will be replicated to one or more replica databases.
c Define user access rights to control who can synchronize data.
You can complete the setup steps by using a combination of system procedures and SQL statements or by using SQL statements only. To modify the publication definitions later on, a set of SQL statements are available.
2 Set up replica databases
a Define each database as a replica database, register replica databases with the master database and create a catalog for synchronization.
b Define user access rights to control who can synchronize data.
c Register each replica database for a publication.
You can complete the setup steps by using a combination of system procedures and SQL statements or by using SQL statements only. To modify the publication definitions later on, a set of SQL statements are available.
In the Advanced Replication environment, data changes can be synchronized bidirectionally:
3 Synchronize data
To synchronize (load) data from the master database to a replica database, execute a refresh. The refresh can load all data (full refresh) or only changed data (incremental refresh).
To synchronize changes to data from a replica database to the master database, complete the following steps:
a Save each DML statement by using a proprietary SAVE statement.
b Compose a message that defines the saved data to be propagated to the master database.
c Send (forward) the message to the master database.
The refreshes of data from the master database to the replica database are started by issuing a REFRESH statement on the replica database.
The propagation of data from the replica database to the master database is controlled by using SQL statements and procedure-type MESSAGE statements.