RECONCILIATION OF GEO-REPLICATED DATABASE CLUSTERS

摘要

A database associated with a primary database cluster may be replicated in a backup database cluster located in a different location in order to provide a highly-available fault tolerant database service. The databases are reconciled through a cluster management module distributed in each database cluster. The cluster management module uses a set of reconciliation data structures to track locally the reconciled states of each database in each database cluster, the operations made locally to the databases in each database cluster, and the author of the operations. The cluster management module in each database cluster engages in a stateless messaging protocol using the set of reconciliation data structures to determine whether or not the databases may be reconciled.

主权项

1. A computer-implemented method, the method comprising:
configuring a primary database in a primary database cluster to be replicated in a secondary database in a secondary database cluster; tracking, at the primary database cluster, a current statename and previous statename of the primary database, the current statename representing a current state, the previous statename representing a state immediately prior to the current state; tracking, at the secondary database cluster, a current statename and a previous statename of the secondary database; generating a new statename of the primary database when a user performs an operation on the primary database; receiving, at the secondary database cluster, a current statename and a new statename of the primary database; and determining, at the secondary database cluster, whether to reconcile the primary database to the secondary database based on a current statename of the secondary database, the current statename of the primary database, and the new statename of the primary database, and a previous statename of the secondary database.