6.2.8.Replication & Synchronization

Snapshot Replication

Conductor "Replication" offers manage Virtuoso Replication. You are offered with "Basic", "Incremental", "Bidirectional Snapshot" and "Transactional" sub-tabs.

  • From

    Replication/Basic/Query(Table select)to local

    to replicate local table(s) to another data source click

    Create New Snapshot

    and follow the wizard.

  • To copy the changes from the local table to the remote select some replications and press

    Synchronize

  • To drop the replication definition without dropping the destination table select some replications and press

    Remove

  • To drop the replication definition and the destination table select some replications and press

    Remove & Drop Remote

  • To copy the changes from the local table to the remote automatically select some replications, enter minutes in

    Scheduled Interval

    and press

    Schedule

  • To remove scheduled update select the replications enter 0 in "Scheduled Interval" and press Schedule

  • Figure6.102.Snapshot Replication

    Snapshot Replication

  • Figure6.103.Snapshot Replication

    Snapshot Replication

  • Figure6.104.Snapshot Replication

    Snapshot Replication

  • Figure6.105.Snapshot Replication

    Snapshot Replication

  • Figure6.106.Snapshot Replication

    Snapshot Replication

  • Figure6.107.Snapshot Replication

    Snapshot Replication

Transactional Replication

Publications

The Transaction Publication screen lists publications. You can add, edit or remove publications as necessary, each time using the guide-lines of the wizard.

Figure6.108.Transaction Replication - Publications

Transaction Replication - Publications

Add a new publication by clicking on the Create button.
Edit an existing publication by clicking on publication name.
Remove publications by selecting their checkbox and clicking on the Delete button. Use caution, as this action cannot be reverted.

When creating a new publication you must supply a name. At this point you have the option to create an updateable publication - see the Bi-Directional Transactional Replication section for more details - which allows updates to come from subscribers rather than being limited to originating from the publisher only.

Figure6.109.Transaction Replication - New Publication

Transaction Replication - New Publication

Figure6.110.Transaction Replication - List of Publications

Transaction Replication - List of Publications

Once a new publication has been made you can add database objects to it using the Add ... buttons, or remove them by selecting their checkbox and using the Remove button. To add a new table to the publication click on Add Table/Procedure . Follow the wizard by choosing the appropriate database/catalog by clicking on its name, you will then be presented with the tables within it.

Figure6.111.Transaction Replication - Publish Tables and Procedures

Transaction Replication - Publish Tables and Procedures

Select the tables to publish using the checkboxes and press Add to Publication to add the tables and continue.

Once returned the publication screen, the published tables will be listed. Updatable publication will need conflict resolvers in case of conflicting data arriving from a subscriber. Click on the table name to manage the resolvers list.

Figure6.112.Transaction Replication - Published Items

Transaction Replication - Published Items

Use the Add /Remove to add or remove selected resolvers.

Click on Publication Item -> New Resolver to add a new resolver. You have the following details to contend with:

  • Name Suffix

    Conflict resolver name suffix.

  • Order

    Resolver order number.

  • Type

    The resolver type, one of: Insert, Update, or Delete for resolving such SQL queries.

  • Class

    The kind of resolver. Class can be one of the following:

    'max' row with maximum value of specified column wins
    'min' row with minimum value of specified column wins
    'ave' new value of specified column is calculated as: current_val = (current_val + new_val) / 2
    'add' new value of specified column is calculated as: current_val = current_val + (new_val - old_val)
    'pub_wins'
    'custom' publisher always wins
    'sub_wins' subscriber always wins
  • Column

    This should specify the column name if class is not one of 'pub_wins', 'sub_wins' or 'custom'.

Figure6.113.Transaction Replication - Resolvers

Transaction Replication - Resolvers

Click on Publication -> Advanced Options to set additional settings such as split size, default copy mode of publication item, etc.

Figure6.114.Transaction Replication - Advanced

Transaction Replication - Advanced

Subscriptions
  • To add new subscription click at New Subscription and follow the wizard.

  • Click Edit to change properties.

  • To drop subscription click at link Drop.

  • To synchronize subscription click the Sync button.

  • To disconnect all subscriptions click at Disconnect all button.

  • To load image file click at Load image button and follow the wizard.

Figure6.115.Transaction Replication - Subscription

Transaction Replication - Subscription

Figure6.116.Transaction Replication - Subscription

Transaction Replication - Subscription