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 3 reply threads

Author

Posts
- August 27, 2016 at 2:35 pm #13558
  
  mario60
  Member
  
  Hi
  
  I am curious about how SJA (for Linux) knows which records from a Db/Table has been updated since its last run.
  
  (I understand SJA knows, because if I run it once, updated some rows of the source table, and run SJA again, it dumps just the updated records, doesn’t it?)
  
  If the answer is written somewhere, please let me know where
  
  Thanks
  
  Cheers
  
  mario
- 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 3 reply threads

You must be logged in to reply to this topic.