solidDB Help : Replication : Advanced Replication : Using Advanced Replication with applications : Building messages for synchronization
  
Building messages for synchronization
The data synchronization between two solidDB servers relies on the solidDB Advanced Replication messaging architecture. This is a store-and-forward messaging architecture that is built inside solidDB. It is capable of transferring messages reliably between master and replica databases.
The synchronization process of Advanced Replication architecture consists of two different tasks:
propagating transactions to the master database
refreshing publications on a replica
A combination of these tasks is grouped together in a synchronization message. Note that transactions that refer to a particular table should always be propagated to the master database before data is refreshed from that table. Both of these actions are permitted in the same synchronization message as shown in the following example:
MESSAGE my_msg BEGIN ;
MESSAGE
my_msg APPEND PROPAGATE TRANSACTIONS ;
MESSAGE my_msg APPEND REFRESH ORDERS_BY_SALESPERSON ('1') ;
MESSAGE my_msg APPEND REFRESH PARTS_IN_INVENTORY ;
MESSAGE my_msg END ;
COMMIT WORK ;
See
Beginning messages
Propagating transactions from replica database to master database
Refreshing publication data from master to replica
Ending messages
Forwarding messages to the master database
Requesting a reply message from the master database
Configuring Advanced Replication messages
Executing a synchronization process
Go up to
Using Advanced Replication with applications