I think SJA has a bug. I have setup 2-way sync between 2 MySQL servers where S1 is the Source and S2 is the Target. The sync appears to work somewhat: The INSERT statements propagate both directions regardless whether created on S1 or S2. UPDATE statements are a problem! If the UPDATE was initiated on S2 (target), they will be reset back to S1 state (even if that record on S1 wasn't touched). That is not 2-way in my book.
Example:
+ S1 and 2 start with: MyTable; Record R1 with myStatus column data 'test'.
+ Update the myStatus of R1 to 'Changed' on S2.
+ 2-way sync.
+ Result both S1 and S2 are back to original state where the myStatus is 'test'
I would expect this from 1 way sync with overwrite but not from 2-way.
