Preventing database replication conflicts in a distributed environment

摘要

A distributed system of data centers is configured to ensure that all data operations involving specific accounts are performed within a given time frame at only one data center. Once a data center has begun accessing data that is associated with an account, all requests to access or manipulate data for that account are redirected to that data center for a period of time. Thus, the data center becomes not only the “owner” of all data associated with the account for that period of time, but also the servicer of all requests associated with the account. The data center then asynchronously replicates changes to the data associated with the account to the other data centers. Since none of the other data centers are permitted to change the data associated with the account, conflicts in the replicated data are minimized.

主权项

1. A method comprising:
receiving, at a first server of a plurality of servers, a request to sign-in to a particular account associated with account data that is replicated asynchronously across the plurality of servers; responsive to the request, the first server determining whether another server in the plurality of servers stores session data describing an active session involving the particular account; when it is determined that no other server in the plurality of servers stores session data describing an active session involving the particular account, the first server performing:
generating new session data describing a new session involving the particular account;conducting the new session involving the particular account; andwhile the new session remains active, servicing any redirected requests associated with the particular account;wherein the first server manipulates the account data associated with the particular account within a local copy of the account data that is local to the first server; when it is determined that a second server of the plurality of servers stores session data describing an active session involving the particular account, the first server redirecting the request to the second server; wherein the method is performed by one or more computing devices.