Building messages for synchronization

Advanced Replication Guide : Using advanced replication with applications : 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 ;