Systems and methods for use in replicating data

A non-transitory computer-readable storage medium including executable instructions, which when executed by at least one processor of a first data system in replicating data between different services used to update multiple databases, cause the at least one processor to:

• perform a first create, update or delete operation on data included in a first database of the first data system;
• post an entry representative of the first create, update or delete operation to an outbox data structure, which is stored in the first database of the first data system;
• retrieve the entry from the outbox data structure;
• determine whether the first create, update or delete operation in the entry is required to be performed in order, or not;
• in response to determining that the first create, update or delete operation is required to be performed in order, publish the entry from the outbox data structure as a first message to a message bus coupled in communication with the at least one processor, thereby informing a second data system of the first create, update or delete operation in the first database of the first data system;
• in response to determining that the first create, update or delete operation is not required to be performed in order, publish the entry from the outbox data structure as a first message to a second message bus, thereby informing a second data system of the first create, update or delete operation in the first database of the first data system;
• receive a second message from the message bus, the second message indicative of a second create, update or delete operation at a second database included in the second data system;
• and
• direct a persistence service of the first data system to perform the second create, update or delete operation of the second message, in order relative to one or more other messages, on the first database of the first data system.

A computer-implemented method for replicating data between different services used to update multiple databases, the method comprising:

• performing, by a computing device of a data system, a first create, update or delete operation on data included in a first database of the data system;
• posting, by the computing device, an entry representative of the first create, update or delete operation to an outbox data structure, which is stored in the first database of the data system;
• retrieving, by the computing device, the entry from the outbox data structure;
• determining whether the first create, update or delete operation from the entry is required to be performed in order, or not;
• in response to determining that the first create, update or delete operation is required to be performed in order, publishing, by the computing device, the entry from the outbox data structure as a first message to a first ordered message bus coupled in communication with a different data system, thereby informing the different data system of the first create, update or delete operation in the first database of the first data system;
• receiving, by the computing device, a second message from the first ordered message bus, the second message indicative of a second create, update or delete operation at a second database included in the different data system;
• and
• directing a persistence service of the first data system to perform the second create, update or delete operation of the second message, in order relative to one or more other messages, on the first database of the data system.