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

Sja 2-Way Sync Bug

forums forums SQLyog SQLyog: Bugs / Feature Requests Sja 2-Way Sync Bug

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #12899
      Pieter
      Member

      Hi,

      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.

      Xml file:

      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

    • #34097
      peterlaursen
      Participant

      I have repled in your ticket.

Viewing 1 reply thread
  • You must be logged in to reply to this topic.