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

Synchronization Problems

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Synchronization Problems

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • September 29, 2005 at 4:17 pm #9263
      nicolas
      Member

      Hello!

      First of all, i am sorry for mi english, please try to understand me.

      I have a problem during de Synchronization.

      i'm Synchro a lot of BD of different host, sometimes the result is good, but sometimes never finish, i'm using 5.0.4 v.

      Can you help me?

      Thank you, Nicolás

    • September 29, 2005 at 4:19 pm #19343
      Ritesh
      Member

      What is the error you are getting?

      Can you give me more info about your MySQL (source and target) & SQLyog versions? How big is the table that you are trying to sync?

    • September 29, 2005 at 7:31 pm #19344
      peterlaursen
      Participant
      Quote:
      but sometimes never finish

      You must understand the the client (the computer running the sync job) must do a lot of calculations (calculations of checksums). That can take a lot of time is there are many BIG field (BLObs etc) and many rows. Also database servers at ISP often are very slow at the type of queries that the sync job needs.

      The solution is to use the and options effectively so that no time is wasted doing a lot of calculations that there is no need to do.

      I persoanlly have an example where the time for a sync job was reduced from 11 hours to 5 minutes using these options.

      You can try if you can read this paper:

      http://www.webyog.com/forums/index.php?showtopic=1507

      I have a newer version that I can mail you, if you PM me your mail adress.

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