Advanced Replication Guide : 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 a replica and the master database.
The synchronization process of advanced replication architecture consists of two different tasks:
propagating transactions to the master database
refreshing of publications to a replica
A combination of these tasks (containing the propagation command, REFRESHes, or both) is grouped together in a synchronization message. Note that transactions referring to a particular table should always be propagated to the master before refreshing data from that table. Both of these actions are permitted in the same synchronization message as shown in the example below:
Synchronization messaging
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 also
Beginning messages
Propagating transactions from replica to master
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
Using advanced replication with applications