• Info
• Initial State
• View Source
• Run

Bidirectional Snapshot Replicaton Setup

RE-SB-3 Defining subscribers for published table

Defining subscribers

Preliminaries

In order to run this example you need two Virtuoso servers running (publisher and subscriber). In the example scripts it is assumed that the first Virtuoso server (publisher) is running at localhost:1111 and the second Virtuoso server (subscriber) is running at localhost:1112. If you are running ODBC versions of the servers there should be 2 ODBC DSN's records named "localhost:1111" and "localhost:1112". Subscriber should have "ServerName" configuration parameter set to "demoserver2".

Example creating a subscription

These steps should be executed on publisher.

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. Click "Subscriptions" for desired published table ("Demo.demo.Orders").
4. Press "New Subscriber" button.
5. Select connected DSN from the list and then press "Create Subscription" button. If the desired DSN is not connected yet you can connect to it using "Specify new data source" dialog below.

Equivalent SQL commands to above

1. Connect to the publisher via ISQL utility as DBA user.
2. Define a replication server "demoserver2" at "localhost:1112" and subscribe it to published "Demo.demo.Orders" table.

   SQL> repl_snp_server('localhost:1112');
   SQL> repl_create_snapshot_sub('demoserver2', 'Demo.demo.Orders', 2, 'dba', 'dba');