Unsupported Screen Size: The viewport size is too small for the theme to render properly.

2-Way Sync Behavior With Sja

This topic contains 2 replies, has 0 voices, and was last updated by  peterlaursen 5 years ago.

  • Author
    Posts
  • #12898

    Pieter
    Member

    Hi,

    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.

    Xml file:

    < ?xml version="1.0" encoding="UTF-8"?>

    Server1

    MyUser

    ***** 3306

    0

    0

    0

    rev_CUST

    Server2

    MyUser

    ***** 3306

    1

    0

    0

    rev_CUST

    `MyTable`

    e:trctrace.trc.txt

    MyName

    mytarget@email.com

    from@email.com

    from@email.com

    my.smtp

    no

    25

    SYNC Error yyyy-mm-dd hh:mm:ss

  • #34094

    peterlaursen
    Participant

    What is the idea in creating 2 Forums post and 1 ticket? One contact option is enough!

    I have replied in your ticket

  • #34095

    mbLOORE
    Member

    was this resolved? i would like to do a 2-way sync myself.

  • #34096

    peterlaursen
    Participant

    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..

You must be logged in to reply to this topic.