SymmetricDS User Guide

Authors

Eric Long , Chris Henson

User Guide 1.0

Permission to use, copy, modify, and distribute the SymmetricDS User Guide Version 1.0 for any purpose and without fee is hereby granted in perpetuity, provided that the above copyright notice and this paragraph appear in all copies.

Table of Contents

Preface

1. Introduction

1.1. The Problem of Synchronization

1.1.1. Notification Schemes
1.1.2. Two-Way Table Synchronization
1.1.3. Data Channels
1.1.4. Transaction Awareness
1.1.5. Data Filtering and Rerouting
1.1.6. HTTP Transport
1.1.7. Remote Management

1.2. Requirements

1.3. Background

1.4. Version Numbering

2. Getting Started

2.1. Installing SymmetricDS
2.2. Creating and Populating Your Databases
2.3. Starting SymmetricDS
2.4. Registering a Node
2.5. Sending Initial Load
2.6. Pulling Data
2.7. Pushing Data
2.8. Verifying Outgoing Batches
2.9. Verifying Incoming Batches

3. Concepts

3.1. Configuration Data Model

3.1.1. Node
3.1.2. Node Security
3.1.3. Node Group
3.1.4. Node Group Link
3.1.5. Channel
3.1.6. Node Channel Control
3.1.7. Trigger
3.1.8. Parameter

3.2. Runtime Data Model

3.2.1. Data
3.2.2. Trigger Hist
3.2.3. Data Event
3.2.4. Outgoing Batch
3.2.5. Outgoing Batch Hist
3.2.6. Incoming Batch
3.2.7. Incoming Batch Hist

4. Architecture

4.1. Software Components

4.2. Deployment Options

4.2.1. Web Archive
4.2.2. Standalone
4.2.3. Embedded

5. Basic Configuration

5.1. Setting Startup Parameters
5.2. Basic Properties
5.3. Node Group
5.4. Node Group Link
5.5. Node
5.6. Channel
5.7. Trigger

6. Advanced Configuration

6.1. Initial Load

6.2. Dead Triggers

6.3. Extension Points

6.3.1. IParameterFilter
6.3.2. IDataLoaderFilter
6.3.3. IColumnFilter
6.3.4. IBatchListener
6.3.5. IReloadListener
6.3.6. IExtractorListener

6.4. Secure Transport

7. Administration

7.1. Changing Triggers
7.2. Sync Triggers Job
7.3. Enabling and Disabling Synchronization
7.4. Java Management Extensions
7.5. Opening Registration
7.6. Viewing Batches
7.7. Statistics

A. Startup Parameters

B. Database Notes

B.1. Oracle
B.2. MySQL
B.3. PostgreSQL
B.4. MS SQL Server
B.5. HSQLDB
B.6. Apache Derby

C. Data Format