[go: up one dir, main page]
  Top

Chapter 13. Data Replication, Synchronization and Transformation Services

Abstract

This chapter describes how to replicate data between Virtuoso and non-Virtuoso servers.

The material in this chapter covers the programmatic means of performing these operations. You can also use the graphical interface to do replication and synchronization. This is covered in the Replication & Synchronization section of the Visual Server Administration Interface chapter.

Table of Contents

13.1. Introduction
13.1.1. Snapshot replication
13.1.2. Transactional replication
13.2. Snapshot Replication
13.2.1. Non incremental snapshot replication
13.2.2. Incremental snapshot replication
13.2.3. Command reference
13.2.4. Bi-Directional Snapshot Replication
13.2.5. Registry variables
13.2.6. Heterogeneous snapshot replication
13.2.7. Data type mappings
13.2.8. Objects created by incremental snapshot replication
13.2.9. Objects created by bi-directional snapshot replication
13.2.10. Replication system tables
13.2.11. Table snapshot logs
13.3. Transactional Replication
13.3.1. Publishable Items
13.3.2. Errors in Replication
13.3.3. Publisher Transactional Replication Functions
13.3.4. Subscriber Functions
13.3.5. Common Status Functions
13.3.6. Bi-Directional Transactional Replication
13.3.7. Purging replication logs
13.3.8. Objects created by transactional replication
13.4. Virtuoso scheduler
13.4.1. SYS_SCHEDULED_EVENT
13.5. Transactional Replication Example
13.5.1. Transactional Replication Objects Example
13.6. Replication Logger Sample
13.6.1. Configuration of the Sample
13.6.2. Synchronization
13.6.3. Running the Sample
13.6.4. Notes on the Sample's Dynamics

13.1. Introduction

Virtuoso provides several replication methods:

13.1.1. Snapshot replication

Virtuoso provides the following flavors of snapshot replication:

Non-incremental snapshot replicationNon-incremental snapshot replication is useful when the data is changed infrequently or when data is modified in large portions at a time.
Incremental snapshot replication Incremental snapshot replication is useful when the data is changed frequently and implements incremental updates using a snapshot log.
Bi-directional snapshot replication Bi-directional snapshot replication allows data to be modified on both publisher and subscribers. This is useful read-write access to the replicas is needed.
[Note] Note:

Snapshot replication can be used in heterogeneous environments to set up replication between non-Virtuoso databases.

13.1.2. Transactional replication

Transactional replication allows subscribers to receive data in near-real time. ACID properties of transactions are maintained in transactional replication as well. Virtuoso implements the following flavors of transactional replication:

Ordinary transactional replicationOrdinary transactional replication flavor implements one-way data replication and is useful when data can be modified on only one server with other servers participating in replication providing read-only data access.
Bi-directional transactional replication Bi-directional transactional replication is useful when there is a requirement to allow data updates on multiple servers.

Prev     Next
12.9. Associating Auxiliary Data With A Connection  Home  13.2. Snapshot Replication