Synchronization of database changes among multiple devices

A computer program product, encoded on a non-transitory computer-readable medium, operable to cause data processing apparatus to perform operations comprising:

• determining, by a primary device, one or more primary differences between a primary database and a local synchronization database;
• receiving, from a secondary device, one or more secondary differences associated with a secondary database;
• detecting, with the primary device, at least one conflict between the primary differences and the secondary differences;
• resolving, by the primary device, the at least one conflict resolution based on a primary database timestamp and a secondary database timestamp;
• merging the primary differences and the secondary differences to generate a set of merged differences;
• providing the set of merged differences to the secondary device;
• determining whether an acknowledgement indicating receipt of the set of merged differences is received within a threshold period of time;
• updating the primary database in accordance with the set of merged differences in the event that the acknowledgment is received within the threshold period of time;
• and
• initiating an error recovery mechanism in the event that the acknowledgement is not received within the threshold period of time, wherein the error recovery mechanism determines a first portion of the merged differences that were received by the secondary device and schedules retransmission of a second portion of the merged differences that were not received.

A system comprising:

• a secondary device including a secondary database stored on a storage device;
• and
• a primary device communicatively coupled to the secondary device and including a primary database and a local synchronization database stored on a storage device, wherein the primary device further includes processor electronics configured to perform operations comprising:
• determining one or more primary differences between the primary database and the local synchronization database;
• receiving, from the secondary device, one or more secondary differences associated with the secondary database;
• detecting, with the primary device, at least one conflict between the primary differences and the secondary differences;
• resolving, by the primary device, the at least one conflict resolution based on a primary database timestamp and a secondary database timestamp;
• merging the primary differences and the secondary differences to generate a set of merged differences;
• transmitting the set of merged differences to the secondary device;
• determining whether an acknowledgement indicating receipt of the set of merged differences is received within a threshold period of time;
• updating the primary database in accordance with the set of merged differences in the event that the acknowledgment is received within the threshold period of time;
• and
• initiating an error recovery mechanism in the event that the acknowledgement is not received within the threshold period of time, wherein the error recovery mechanism determines a first portion of the merged differences that were received by the secondary device and schedules retransmission of a second portion of the merged differences that were not received.