Propagating commit times
First Claim
1. A machine-implemented method, comprising:
- maintaining, at a first server, a first value that reflects a most recent timestamp received from a second server; and
in response to the first server receiving a message that contains a timestamp from the second server, the first server performing the steps of;
determining whether the timestamp in the message reflects a time that is more recent than the time reflected by the first value, andif the timestamp in the message reflects a time that is more recent than the time reflected by the first value, then updating the first value to reflect the timestamp in the message.
0 Assignments
0 Petitions
Accused Products
Abstract
A method and mechanism for propagating commit times between a plurality of database servers is provided. A database server maintains a set of one or more values that indicate which timestamps have been exchanged with at least one other database server that shares access to a common database. The one or more values maintained by the database server include a first value describing the most recent timestamp that the database server has sent to another database server and a second value describing the most recent timestamp that the database server has received from the other database server. The database server determines whether to send a commit timestamp associated with a committing transaction to another database server based, at least in part, on the set of one or more values. These techniques may be utilized for propagating commit times between any number of database servers.
-
Citations
26 Claims
-
1. A machine-implemented method, comprising:
-
maintaining, at a first server, a first value that reflects a most recent timestamp received from a second server; and in response to the first server receiving a message that contains a timestamp from the second server, the first server performing the steps of; determining whether the timestamp in the message reflects a time that is more recent than the time reflected by the first value, and if the timestamp in the message reflects a time that is more recent than the time reflected by the first value, then updating the first value to reflect the timestamp in the message. - View Dependent Claims (2, 3, 4, 5, 6, 14, 15, 16, 17, 18, 19)
-
-
7. A machine-implemented method, comprising:
-
maintaining, at a first server, a first value that reflects a most recent timestamp sent to a second server; and in response to the first server sending a message that contains a timestamp to the second server, the first server performing the steps of; determining whether the timestamp in the message reflects a time that is more recent than the time reflected by the first value, and if the timestamp in the message reflects a time that is more recent than the time reflected by the first value, then updating the first value to reflect the timestamp in the message. - View Dependent Claims (8, 9, 20, 21, 22)
-
-
10. A machine-implemented method, comprising:
-
maintaining, at a first server, a first value that reflects a most recent timestamp received from a second server; maintaining, at said first server, a second value that reflects a most recent timestamp sent to said second server; and in response to committing a transaction, at said first server, the first database server determining whether to send a commit timestamp associated with said transaction to said second server based on said first value or said second value. - View Dependent Claims (11, 12, 13, 23, 24, 25, 26)
-
Specification