Zuora, Inc.
System and method for real-time cloud data synchronization using a database binary log

Abstract:

A system synchronizes change-data in a multi-tenant system with one or more external service provider systems. The system comprises a system interface configured to receive transaction events; a write-optimized transactional database for recording the transaction events; a replicated read-optimized transactional database; a transaction log of change-data generated from the read-optimized transactional database; a first change-data processor configured to identify the change-data in the transaction log that is relevant to at least one external service provider system, and to generate an aggregate relevant change-data log; a second change-data processor configured to identify aggregate relevant change-data that is relevant to a particular external service provider system, and to generate a service provider relevant change-data log; a service provider connector configure to await a real-time trigger condition, and to, in response to the trigger condition, perform a synchronization session to synchronize the service provider relevant change-data with the particular external service provider system.