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

Forums | Webyog

Tools to manage and monitor MySQL databases

How Does Sja Know Which Records Has Been Updated Since Last Run?

This topic is empty.

Viewing 2 reply threads

Author

Posts
- August 29, 2016 at 2:48 pm #35767
  
  Sibin A S
  Moderator
  
  Hi,
  
  SJA uses an efficient algorithm to generate checksums to find out the changes. Therefore only those rows that have been inserted, updated or deleted since the last sync are transferred between the hosts.
  
  You may refer our doc regarding the checksum calculation for comparing the data between the databases, here >> http://sqlyogkb.webyog.com/article/294-selecting-tables
  
  Regards,
  
  Sibin
- August 30, 2016 at 8:27 pm #35768
  
  mario60
  Member
  
  Hi Sibin
  
  thanks for your reply.
  
  Do you happen to know a tutorial on how to use checksums to sync two databases?
  
  Is SJA algorithm documented somewhere?
  
  best wishes
  
  mario
- September 6, 2016 at 1:44 pm #35769
  
  Sibin A S
  Moderator
  
  Hi,
  
  You may refer our doc for more information, here >> http://sqlyogkb.webyog.com/article/294-selecting-tables and http://sqlyogkb.webyog.com/category/321-sqlyog-job-agent-from-command-line
  
  Regards,
  
  Sibin
Author

Posts

Viewing 2 reply threads

You must be logged in to reply to this topic.