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

Sync Production Data To Secondary Server Or Failover Server

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Sync Production Data To Secondary Server Or Failover Server

Tagged: ,

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • December 14, 2012 at 2:11 am #12882
      Raja
      Member

      I am new and like to use SQLYog to Sync production DATA to secondary server. Secondary server will be used as a failover server for redundancy or availability of database in case primary server fail. I like to sync data every 30 second. Is this possible on SQLYog? I will appreciate if someone can share their experience or advice to achieve explained goal.

    • December 14, 2012 at 4:43 am #34040
      sathish
      Member

      Hello,

      You can use Database Synchronization to sync the database. For this you can go to Powertools->Data Synchronization Wizard. There is an option to create a job file and schedule it such that, it performs the sync at specified intervals. Please refer the program help file (help .. help menu) provides more information.

      Please refer this FAQ:http://faq.webyog.co…agent_-sja.html

      Regards,

      Sathish

    • December 14, 2012 at 5:42 am #34041
      Raja
      Member

      Thanks.

      To run schedule task SQLYog must be running on my desktop? Can i create schedule file for my Linux server?

    • December 14, 2012 at 8:26 am #34042
      sathish
      Member

      Hello,

      No, Schedule tasks are initiated by the task scheduler. And yes you can create schedule job file for the Linux server.

      And from the previous post you said the you want to schedule the task for every 30 seconds. But it is not advisable to schedule the tasks for every 30 second because you will have some lock problem. I think what you are looking for is replication.

      Please refer the FAQ for the difference between MySQL server replication and SQLyog synchronization : http://faq.webyog.com/content/11/60/en/what-is-the-difference-between-mysql-server-replication-and-sqlyog-synchronization.html

      Regards,

      Sathish

    • December 14, 2012 at 9:03 am #34043
      peterlaursen
      Participant

      On Linux use SJA for Linux available from http://code.google.com/p/sqlyog/downloads/list

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