Patent ID: 8838539
Filing Date: 2014-09-16
Classification: G06F,H04L

Abstract:
1. A method for detecting data loss in a replicated database, comprising: receiving, at a database server, a request from a client application for performing a data transaction on persistent data storage; sending the request to a set of replication servers; receiving, from each replication server, an acknowledgement for the request, including a start sequence number and an end sequence number for data associated with the client application that is stored in local cache of the replication server, and a latest committed sequence number for data associated with the client application that was written to the persistent data storage by the replication server; determining a maximum value of latest committed sequence numbers received from the set of replication servers; examining, for each replication server, whether there is a gap between the start sequence number for data stored in local cache of the replication server and the maximum value of the latest committed sequence numbers; and based on the examining, determining whether there is an occurrence of loss of data associated with the client application.