• Info
• Initial State
• View Source
• Run

Bidirectional Transactional Replicaton Setup

RE-XB-4 Creating a subscription

Creating a subscription

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".

Example creating a subscription

These steps should be executed on subscriber.

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 "Subscriptions" sub-tab.
3. Press "New Subscription" button.
4. Select connected DSN from the list and then press "Publications list" button. If the desired DSN is not connected yet you can connect to it using "Specify new data source" dialog below.
5. Select a publication and press "List items" button.
6. Press "Subscribe" button. You can optionally load initial data by checking "Load data" checkbox.

Equivalent SQL commands to the above

1. Connect to the subscriber via ISQL utility as DBA user.
2. Define a replication server "demoserver" at "localhost:1111" and subscribe to publication "repldemo" from it.

   SQL> repl_server('demoserver', 'localhost:1111', 'localhost:1111');
   SQL> repl_subscribe('demoserver', 'repldemo', 'dba', 'dba', 'dba', 'dba');