Issue With Database Synchronisation

[Distinctive]

Hi,

I am an SQLyog Ultimate subscriber.

We're using the database synchronisation job manager tool to synchronise the data between two databases.

The target database is an exact copy of the source database, the source database is extremely busy so we like to keep a copy of the database on the other server for data retrieval purposes.

We've scheduled the synchronisation to run every 30 minutes.

This runs happily for a number of days, and then suddenly the Data Synchronisation Wizard stops inserting new records and deleting records, but it will happily update records. It doesn't give us any error or warning, it just stops working.

Here is an example of the output:

Code:

`detection` 6005325 6003718 0 11070 0

This only happens on the 'detection' table, all other tables will update correctly. The detection table is frequently updated, but the table schema is almost never changed. You can see that the table has over 6 million records, and that the source table has 1607 more records than the destination table, from that output you can see it updated 11070 rows but neither inserted nor deleted any records, I'd expect the output to look like this:

Code:

`detection` 6005325 6003718 1607 11070 0

To make the database synchronise again we need to manually copy the source table from the source database to the destination database (To avoid interruption of our services we actually copy to a placeholder database, rename the table and then copy to the destination database, delete the old table and replace with the copied table, its really annoying and takes 1.5 hours to complete).

Source database server:

MySQL 4.1.22-community (x86), Windows Server 2003 Standard R2, 32-bit

Destination database server:

MySQL 5.1.42-community (x64), Windows Server 2008 Standard, 64-bit

We're using the latest stable version of SQLyog Ultimate (8.6 GA).

Can you please help because this is a MAJOR inconvenience.

Thank you.

[Mahesh]

This is really weird behavior.

Can you attach a source and target .SQL dump (zip format) where this issue is reproducible.

If you are unable to upload dump files here please follow the steps mentioned below:

We have created an account for you to send files here, http://www.yousendit.com/login.php

Please login with the below details,

Email : [email protected]

Password : tester

and send file(zipped) to email address “[email protected]” mentioning subject as “Datasync problem”

You can create a ticket for privacy of data

http://webyog.com/support

[Author]

Posts