System for synchronizing replicas of a database
First Claim
Patent Images
1. A database system comprising:
- a first server site comprising a first replica of a database;
a second server site coupled to the first server site, the second server site comprising a second replica of the database; and
a client coupled to the first replica wherein the client is operable to;
send update data from a first replica to a second replica, the first replica being associated with a first acquire server unit and a first acquire client unit, the second replica being associated with a second acquire server unit and a second acquire client unit;
automatically detect a failure of the update data from the first replica to be applied to the second replica wherein the detecting comprises;
requesting, by the first acquire client unit from the second acquire server unit, metadata comprising export parameters; and
receiving, by the first acquire client unit from the second acquire server unit, the metadata;
automatically determine a cause of the failure and where the cause of failure occurred, wherein the determining comprises;
determining, by the first acquire client unit, if the failure was due to a packet being lost, wherein the packet contains the update data, wherein the first acquire client unit determines if the failure was due to a packet being lost by requesting from the second acquire server unit, the result of the last failed import to confirm that the packet was actually lost;
parsing, by the first acquire client, the metadata received from the second acquire server unit, wherein the parsed metadata indicates if an account is locked out; and
determining, by the first acquire client unit, if the second replica is updated with current update data;
automatically resolve the cause of the failure, wherein the resolving comprises;
requesting, by the first acquire client unit, for a packet to be resent if the cause of the failure is due to the packet being lost;
resending, by the first acquire client unit, a packet containing the update data if the second replica is not updated with current update data;
unlocking, by the first acquire client unit, an account if the cause of the failure is due to the account being locked out;
deleting, by the first acquire client unit, an object if the cause of the failure is due to the object not being deleted during a previous export;
notifying, by the first acquire client unit, an appropriate authority of the failure if corrective actions need to be taken by the appropriate authority;
resending the update data;
applying the update data to the second replica; and
recording update data in an operations log.
1 Assignment
0 Petitions
Accused Products
Abstract
A system for synchronizing replicas of a database. The system detects a failure of update data from a first replica to be applied to a second replica and determines a cause of the failure. The system also resolves the cause of the failure. According to the system disclosed herein, the present invention synchronizes the replicas of the database without requiring manual intervention.
-
Citations
4 Claims
-
1. A database system comprising:
-
a first server site comprising a first replica of a database; a second server site coupled to the first server site, the second server site comprising a second replica of the database; and a client coupled to the first replica wherein the client is operable to; send update data from a first replica to a second replica, the first replica being associated with a first acquire server unit and a first acquire client unit, the second replica being associated with a second acquire server unit and a second acquire client unit; automatically detect a failure of the update data from the first replica to be applied to the second replica wherein the detecting comprises; requesting, by the first acquire client unit from the second acquire server unit, metadata comprising export parameters; and receiving, by the first acquire client unit from the second acquire server unit, the metadata; automatically determine a cause of the failure and where the cause of failure occurred, wherein the determining comprises; determining, by the first acquire client unit, if the failure was due to a packet being lost, wherein the packet contains the update data, wherein the first acquire client unit determines if the failure was due to a packet being lost by requesting from the second acquire server unit, the result of the last failed import to confirm that the packet was actually lost; parsing, by the first acquire client, the metadata received from the second acquire server unit, wherein the parsed metadata indicates if an account is locked out; and determining, by the first acquire client unit, if the second replica is updated with current update data; automatically resolve the cause of the failure, wherein the resolving comprises; requesting, by the first acquire client unit, for a packet to be resent if the cause of the failure is due to the packet being lost; resending, by the first acquire client unit, a packet containing the update data if the second replica is not updated with current update data; unlocking, by the first acquire client unit, an account if the cause of the failure is due to the account being locked out; deleting, by the first acquire client unit, an object if the cause of the failure is due to the object not being deleted during a previous export; notifying, by the first acquire client unit, an appropriate authority of the failure if corrective actions need to be taken by the appropriate authority; resending the update data; applying the update data to the second replica; and recording update data in an operations log. - View Dependent Claims (2, 3)
-
-
4. A computer-readable storage medium containing program instructions for synchronizing replicas of a database, the program instructions which when executed by a computer system cause the computer system to execute a method comprising:
-
sending update data from a first replica to a second replica, the first replica being associated with a first acquire server unit and a first acquire client unit, the second replica being associated with a second acquire server unit and a second acquire client unit; automatically detecting a failure of the update data from the first replica to be applied to the second replica wherein the detecting comprises; requesting, by the first acquire client unit from the second acquire server unit, metadata comprising export parameters; and receiving, by the first acquire client unit from the second acquire server unit, the metadata; automatically determining a cause of the failure and where the cause of failure occurred, wherein the determining comprises; determining, by the first acquire client unit, if the failure was due to a packet being lost, wherein the packet contains the update data, wherein the first acquire client unit determines if the failure was due to a packet being lost by requesting from the second acquire server unit, the result of the last failed import to confirm that the packet was actually lost; parsing, by the first acquire client, the metadata received from the second acquire server unit, wherein the parsed metadata indicates if an account is locked out; and determining, by the first acquire client unit, if the second replica is updated with current update data; automatically resolve the cause of the failure, wherein the resolving comprises; requesting, by the first acquire client unit, for a packet to be resent if the cause of the failure is due to the packet being lost; resending, by the first acquire client unit, a packet containing the update data if the second replica is not updated with current update data; unlocking, by the first acquire client unit, an account if the cause of the failure is due to the account being locked out; deleting, by the first acquire client unit, an object if the cause of the failure is due to the object not being deleted during a previous export; notifying, by the first acquire client unit, an appropriate authority of the failure if corrective actions need to be taken by the appropriate authority; resending the update data; applying the update data to the second replica; and recording update data in an operations log.
-
Specification