Saturday, 17 August 2013

How to configure bi-directional replication on a single table in symmetricDS?

How to configure bi-directional replication on a single table in symmetricDS?

I have installed and configured the database replication software from
http://www.symmetricds.org/ on the client and the server. I have followed
the directions to setup the example replication, and everything works as
advertised.
I am interested in is bi-directional Replication on a single table. That
means that each database on the client and server can be
inserted/updated/deleted and changes occur on the other database. Each
table is both an originator and destination of content for the other.
I've read the entire manual for symmetricDS and there is no example of how
a bi-directional table should be configured. There is a single paragraph
in the manual that says it can be done, but not how.
Where are the instructions to create bi-directional database replication
in symmetricDS? The default example they provide is single directional
replication pumps.
My System:
Client: Fedora 17 Linux with postgresql
Server: Windows 8 with mysql
My presumptuous attempt at bi-directional pumps failed:
The trigger sym_trigger_router is where you define the direction the data
pumps. I create a pump in both directions. But this creates a problem with
key-enforced conflicts. If an insert or update or delete is performed at
the same moment on the same key, the database will have to take remedial
action to restore sanity.
Are there any instructions for how to do this or has anybody done this?

No comments:

Post a Comment