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.
You can do a two-way sync. But it works like this: first a one-way sync in one direction (source>target) and next a one-way sync in the other direction. If you insert data in both between sync jobs you will have do define the Primary Key in such a way that the same PK-value is not created on both.
There are dozens of similar replies explaining (and also more elaborate) the importance of understanding how Data Sync works with the Primary Keys of tables..
Ilya Savinkov on
7 months, 1 week agoSibin A S on
7 months, 1 week ago