• Info
• Initial State
• View Source
• Run

Bidirectional Transactional Replicaton Setup

RE-XB-1 Creating a publication

Creating a replication publication account

Preliminaries

Virtuoso supports bidirectional transactional replication via mechanism of updateable subscriptions.

• Every table has only one publisher.
• Subscribers can update replicated tables on their side and then submit data back to publisher. Publisher performs conflict resolution and either accepts or rejects that data.
• It is assumed that all the tables in publication with updateable subscriptions option have primary keys and that primary key columns are never modified.

Example publication account setup

1. Login to the Conductor UI using the dba account.
2. Go to the "Replication" tab, then go to the "Transactional" tab and then go the "Publications" sub-tab.
3. Press the "Create" button.
4. Enter publication name, check the "Updateable" checkbox and press the "Create" button.

Equivalent SQL commands to above

1. Connect to the Virtuoso server via ISQL utility as DBA user.
2. Create publication "repldemo" with log file "repldemo.log"

   SQL> repl_publish('repldemo', 'repldemo.log', 1);