• Info
• Initial State
• View Source
• Run

Bidirectional Snapshot Replicaton Setup

RE-SB-1 Publishing a table

Publishing a table for replication

Preliminaries

Bidirectional snapshot replication allows you to set up snapshot replication between multiple servers where updates can be performed on all servers.

• Publisher-subscriber model where each table has only one publisher and when an update is performed on subscriber it goes to publisher first, and then to all other subscribers.
• Conflict resolution may need to take place on the publisher when data coming from a subscriber is processed.
• It is assumed that all published tables have primary keys and that primary key columns are never modified.

Example publishing a table

1. Login to the Conductor UI using the dba account.
2. Go to the "Replication" tab and then go to the "Bidirectional Snapshot" tab.
3. Press the "Add table" button.
4. Enter table name or select the table using "Browse..." button and press "Add" button.

Equivalent SQL commands to above

1. Connect to the Virtuoso server via ISQL utility as DBA user.
2. Publish "Demo.demo.Orders" table.

   SQL> repl_create_snapshot_pub ('Demo.demo.Orders', 2);