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

One Way Sync +2,500,000 Header Db / +7,500,000 Detail Db

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › One Way Sync +2,500,000 Header Db / +7,500,000 Detail Db

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • June 26, 2009 at 9:44 pm #29219
      peterlaursen
      Participant

      We cannot rell how much time it wil take to sync. But it is not the number or rows that matters most, but rather what operations (INSERTS, UPDATES, DELETES) will need to be performed (if there is nothing to do it will take a few minutes only). So the first sync may take considerable time, but sync job following after may take much less time. So the general advice would be that sync job should be scheduled so frequently that sync time is acceptable.

    • June 26, 2009 at 10:46 pm #29220
      Jeanswhse
      Member

      Thank for your reply!

      The first sync from source db to empty target db, how long do you think that will be? 1-2 hours?

      Alfred

    • June 27, 2009 at 7:32 am #29221
      peterlaursen
      Participant

      When target table is empty we are just doing a plain copy (there are no data to compare). It will be almost as fast as importing a dump if network is fast. But I cannot give numbers.

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.