solidDB Help : Replication : Advanced Replication : solidDB Advanced Replication architecture components : Publications, subscriptions, and refreshes
  
Publications, subscriptions, and refreshes
The synchronization architecture of a multi-database system requires a way for applications to download data from the master database to the replica database, and to refresh this replica data on an as-needed basis.
A publication is a definition of a set of master data that can be downloaded to replicas. Replica databases use subscriptions to register their interest in a particular publication from the master. A publication is registered in a replica. Users can refresh data from only those publications that are registered. In this way, publication parameters are validated, preventing users from accidentally refreshing from unwanted or non-existing publications or making ad hoc refresh requests.
The initial download (refresh) always returns all the data for a publication; all data that matches the search criteria (given as publication parameters) is sent to the replica database.
After the initial download, subsequent refreshes to the same publication (using the same parameter values) receive only the data that has been changed since the prior refresh. This is known as an incremental refresh. Typically, only publication updates with the latest modifications need to be sent to a replica database. Creating publications and specifying that they are incremental is done by using solidDB Advanced Replication statements, which are extensions to solidDB SQL.
Go up to
solidDB Advanced Replication architecture components