We have a PHP script that handles synchronization between two databases. The script runs on a 30 minute schedule and has a random anamoloy that we need to diagnose.
Database 1 is our accounting software database (source database - Providex)
Database 2 is our warehouse management database (destination database - MySQL)
Our script uses hash values in the destination database to check for NEW, UPDATES or DELETED records in the source database.
For NEW rows in the source: the record is selected from the source database and replicated in the destination database.
For UPDATE rows in the source: the changes are selected from the source database and replicated in the matching row of the destination database.
For DELETED rows in the source: the matching row in the destination database is deleted
We are seeing an issue happen occasionally and randomly where our script thinks that some of the rows in our table have been deleted from the source database and therefore are removed from the destination database. However, those lines have not been deleted from the source table. The next time the script runs, it detects that those lines are still in the source database and recreates them in the destination table as if they are brand new. We see this happening in our sales order details data but suspect it may be happening for all synced tables. However, since the order details table is our main transnational table, this one impacts us the most.
This issue is not reproducible on demand. It happens rarely and randomly.
The only two things that come to mind:
Connectivity - Could this sort of behavior happen if there is a disruption in the network? How to diagnose from the script side if this is the case? some sort of logging possible to confirm connectivity when the sync runs?
Script Bug - Could there be an error in the code that allows for this behavior? This is less likely given the rare and random occurrence - but not impossible.
We need someone to suggest some options for diagnosing the root cause of the issue.
Sync files are attached for review.
18 freelancer đang chào giá trung bình $171 cho công việc này
Hi i can Diagnose database synchronization issue i am expert at , PHP , SQL , MySQL , Database Programming So send me Private message at PMB so we can discuss more about it Thanks
Hi, I have understand the project requirement & interested to work for this project. I will start right now and I will do it within your time . Please send a message so we can discuss more & start the project. Thanks
Hi my name is Muhammad Hassan. I have high level expertise in Mysql. I can check whats wrong with your current and I might fix that issue too. Regards Muhammad Hassan
Hello I am interested in working with you on this project. Please let me know if we can meet up today or tomorrow on Skype to discuss this further. Thanks