Wednesday, May 20, 2009

Database synchronization/replication with SymmetricDS

SymmetricDS is an open source, feature rich, web-enabled, database independent, data synchronization/replication software. It is written in Java 5 and released under GNU Lesser General Public License (LGPL) version 3.

It uses web and database technologies to replicate tables between relational databases in near real time. The software was designed to scale for a large number of databases, work across low-bandwidth connections, and withstand periods of network outage. By using database triggers, SymmetricDS guarantees that data changes are captured and atomicity is preserved.

Supported databases including:
  • MySQL version 5.0.2 and above

  • Oracle version 8.1.7 and above

  • PostgreSQL version 8.2.5 and above

  • Sql Server 2005

  • HSQLDB 1.8

  • H2 1.1

  • Apache Derby 10.3.2.1 and above

  • IBM DB2 9.5

  • Firebird 2.0 and above


SymmetricDS allows for 2-tier and even n-tier synchronization, which can be configured to push data (trickle-back) or pull data (trickle-poll) at an interval, as illustrated below:



The software is installed either standalone, as a web application in a Java application server or can be embedded into another Java application.

SymmetricDS will be useful for data synchronization between a central database and multiple remote databases. This kind of requirement is often in:
  • HQ and branches
  • General office and retail outlets
  • Police HQ and stations
  • Ministry of education and schools
  • Ministry of health and hospitals & clinics
  • etc.

Click here for more information about SymmetricDS.

1 comment:

  1. Interesting! MS is moving quickly to copy it by deliver its Microsoft Sync Framework as well.

    ReplyDelete