# 11. Data Replication, Synchronization and Transformation Services

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Data Replication, Synchronization and Transformation Services
Introduction
Snapshot replication Transactional replication
Snapshot Replication
Transactional Replication
Virtuoso scheduler
Transactional Replication Example
Replication Logger Sample

## 11.1. Introduction

Virtuoso provides several replication methods:

### 11.1.1. Snapshot replication

Virtuoso provides the following flavors of snapshot replication:

- Non-incremental snapshot replication

  Non-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:

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

### 11.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 replication

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

Previous Contents of Data Replication, Synchronization and Transformation Services | Chapter Contents | Next Snapshot Replication