Invention Grant
US08126848B2 Automated method for identifying and repairing logical data discrepancies between database replicas in a database cluster
有权
用于识别和修复数据库集群中数据库副本之间的逻辑数据差异的自动方法
- Patent Title: Automated method for identifying and repairing logical data discrepancies between database replicas in a database cluster
- Patent Title (中): 用于识别和修复数据库集群中数据库副本之间的逻辑数据差异的自动方法
-
Application No.: US12558922Application Date: 2009-09-14
-
Publication No.: US08126848B2Publication Date: 2012-02-28
- Inventor: Robert Edward Wagner
- Applicant: Robert Edward Wagner
- Agency: Dimock Stratton LLP
- Agent Alan Macek
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A method and system for monitoring and maintaining the consistency of replicated databases in a shared-nothing database cluster architecture is presented. The method involves the continuous monitoring of the database transaction logs that are maintained by the autonomous database managers that manage the individual database replicas in the cluster. In the event that data discrepancies are detected via the comparison of the transaction logs of the individual database replicas, remedial action is carried out according to configured rules in the main cluster controller. These remedial actions may include, but are not limited to, making a database node inactive within the cluster, or automatically repairing any data discrepancies that are detected among the database replicas in the cluster.
Public/Granted literature
Information query