Sync Production Data To Secondary Server Or Failover Server

[sathish]

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

[Raja]

Thanks.

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

[sathish]

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

[peterlaursen]

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

[Author]

Posts