Đang Thực Hiện

Diagnose database synchronization issue

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.

Kĩ năng: PHP, MySQL, Lập trình cơ sở dữ liệu, SQL

Xem nhiều hơn: database synchronization, resolve sql database replication issue, perl database synchronization, database synchronization xml day, joomla database synchronization, joomla user database synchronization, database synchronization sql server 2005 webservice, database synchronization j2ee j2me, database synchronization daemon, remote database synchronization tcpip, joomla database synchronization free, database synchronization freelancer, local database synchronization pda, synk joomla database synchronization, database synchronization offline mysql, joomla virtuemart database synchronization, database synchronization web service, vtiger database synchronization, offline online database synchronization, database synchronization vbnet pda

Về Bên Thuê:
( 122 nhận xét ) huntley, Canada

ID dự án: #24055414

Được trao cho:

coolguyinus2004

Since its happening randomly then the script has to be checked randomly too for issues. I dont think thsi is happening due to connectivity i guess there is something in the code which overrides the basic function of wh Thêm

$400 USD trong 2 ngày
(354 Đánh Giá)
7.7

18 freelancer đang chào giá trung bình $171 cho công việc này

OutsourceMan

Greetings Craig L., This is Raman. As you can check PHP is our core set of expertise. We have done more than twenty projects in past month alone. Trust me we are expert at Diagnose database synchronization iss Thêm

$157 USD trong 7 ngày
(398 Nhận xét)
8.2
gopalvora

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

$140 USD trong 7 ngày
(527 Nhận xét)
8.3
palindromeguy

Hi, I represent Cidrec Technologies Pvt. Ltd. We are a closed group of dynamic and versatile young individuals of different skill sets to make a complete team. For this particular project I want to briefly describe abo Thêm

$140 USD trong 7 ngày
(20 Nhận xét)
5.4
mtdevil369

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

$120 USD trong 2 ngày
(31 Nhận xét)
5.0
purplemaestro

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

$50 USD trong 3 ngày
(23 Nhận xét)
4.7
bestflancer

Hi I am a senior software engineer. I can suggest the following options a) Instead of deleting the record, we keep some flag (is_deleted) for deletion b) We can reconfirm the record before deletion from the destinatio Thêm

$250 USD trong 7 ngày
(13 Nhận xét)
4.8
milosjovanovic88

Hi, My name is Milos from Serbia who is specialized in Web Dev. I am familiar with PHP/SQL/MySQL and I have experience with similar projects. I will offer the best quality for your project based on your feedback. Feel Thêm

$100 USD trong 2 ngày
(2 Nhận xét)
4.1
RushService

Feel fee to contact me for Diagnose database synchronization issue .Shoot me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the [login to view URL] paym Thêm

$150 USD trong 3 ngày
(13 Nhận xét)
4.3
KherlenS

Dear Client! I am very happy to see your project detail. I think it is just my project. :) I read your requirement carefully and understood fully. I am sure I can do your project. I have much experience with 8+years. Thêm

$200 USD trong 2 ngày
(3 Nhận xét)
3.8
milosstankovic33

Hello, I read your description in detail. *** Very skilled, experienced developer and have been developing WEB for years. As a developer of good clients, all of my clients satisfaction is my greatest favor. I am also a Thêm

$200 USD trong 7 ngày
(2 Nhận xét)
2.9
matinict

Hi, I am 7 year+ Web Application Developer with LEMP/LAMP/Docker stack, Also Certified oracle database expert & Magento 2 . I am interested to work with you on this project, I would like to have a convenient time of yo Thêm

$244 USD trong 3 ngày
(6 Nhận xét)
2.9
azam72

I have gone through the above-mentioned details very well. I have got plenty of experience in php, sql, mysql, database programming kinds of works and I can assure you that I can reach your satisfaction level by provid Thêm

$117 USD trong 7 ngày
(1 Nhận xét)
1.4
AkramDumas

Hi I saw your project details and interested in that. I am PHP and MySql expert. if you hire me then you will see successful result. thank you!!

$30 USD trong 3 ngày
(1 Nhận xét)
0.8
wajahatalii88

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

$166 USD trong 5 ngày
(0 Nhận xét)
0.0
Rjnj

Hello Greetings from Hudson Agile Technologies LLC – A New Jersey Firm. Entity ID – 0450219485 We are head quartered in 317, George Street, 3rd Floor, New Brunswick, NJ, 08901 We are a Software Technology Outsourc Thêm

$200 USD trong 7 ngày
(1 Nhận xét)
1.2
drita3010

I am new comers .work hard Relevant Skills and Experience Medical field

$155 USD trong 3 ngày
(0 Nhận xét)
0.0
swapnilpj

Hi, I am Oracle Certified DBA with 15 years of experience working with Oracle E-business Suite 11i, R12, R12.2 and Databases 9i, 10g, 11g, 12c. Expertise in supporting, installing, administering, upgrade and migrate O Thêm

$250 USD trong 15 ngày
(0 Nhận xét)
0.0