Electronic Arts Inc.
LOW LATENCY CACHE SYNCHRONIZATION IN DISTRIBUTED DATABASES

Abstract:

An example distributed database includes a first instance and a second instance. The first instance is configured to: responsive to performing, within a scope of a database update transaction, a first database update operation, invalidate a cache entry residing in the first database cache maintained by the first instance, wherein the first database update operation is reflected by a transaction log maintained by the first instance; perform, within the scope of the database update transaction, a second database update operation to insert an identifier of the cache entry into a predetermined table of the distributed database, wherein the second database update operation is reflected by the transaction log; and responsive to committing the database update transaction, transmit the transaction log to the second instance. The second instance is configured responsive to receiving the transaction log, to: perform the first database update operation specified by the transaction log; and invalidate the cache entry in the second database cache maintained by the second instance.