Projects:DB Synchronization With Symmetric DS

Contents 1 Introduction 2 Documentation 2.1 Tasks todo 2.2 Technical Documentation 2.3 User Documentation 2.4 QA & Tests

Introduction

The purpose of this project is to build a tool, or use an existing one, to allow synchronizing data at database level between a master server and its secondary servers.

The tool should:

• Support one-way and two-way synchronization
• Allow to specify what tables should be synchronized
• Allow to specify what columns of those tables should be synchronized
• Allow to define a WHERE clause to filter out the rows that don't need to be updated
• Support big volumes of data
• Be able to disable the triggers of a table while synchronizing data
• Be deployable as an Openbravo module

Documentation

Tasks todo

• https://docs.google.com/spreadsheets/d/1dFRezC0jnHIZLFDtBkdpovoaw5BtKwJGE895oyI2Ia0/edit#gid=0

Technical Documentation

• SymmetricDS User Guide
• Trigger Execution Order
• How to Upgrade SymmetricDS

User Documentation

The user documentation is available here:

• Symmetric DS Howtos & User Guids

QA & Tests

• JMeter Tests