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 contains 0 replies, has 0 voices, and was last updated by  peterlaursen 6 years ago.

  • 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:

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

  • #34097

    peterlaursen
    Participant

    I have repled in your ticket.

You must be logged in to reply to this topic.