Top

13.2. Snapshot Replication

13.2.1. Non incremental snapshot replication

The Virtuoso Server periodically evaluates a query and inserts the result into a table, replacing the content. The source and target can be anywhere but typically will be on different databases of which at least one is remote.

This makes a two party distributed transaction. Only one of the transaction branches is writing, hence this goes with a one phase commit.

[Note] Note:

This can be used to replicate between two non-Virtuoso databases.

The prerequisite of this mode of replication is that all tables exist. The schema is never replicated.

Prev  Up  Next
Chapter 13. Data Replication, Synchronization and Transformation Services  Home  13.2.2. Incremental snapshot replication