Data replication and data failover in database systems
AssigneeSnowflake Inc.
InventorsBenoit Dageville, Eric Robinson, Martin Hentschel
Life of this patent
Estimating the term…
Abstract
Replication and failover of database data is disclosed. A method includes replicating database data stored in a primary deployment such that the database data is further stored in a secondary deployment. The method includes executing one or more updates to the database data at the secondary deployment when the primary deployment is unavailable and propagating the one or more updates to the primary deployment when the primary deployment becomes available again. The method includes executing queries on the database data at the primary deployment when the primary deployment is available.
Claims30
A system comprising:
- a cache memory to store database data;
- and
- a processor, operatively coupled with the cache memory, to:
- copy the database data stored in a primary deployment to a first region of the secondary deployment to cause the secondary deployment to copy the database data stored in the first region to a second region of the secondary deployment;
- determine that the primary deployment is unavailable;
- and
- execute one or more transactions on the database data at the secondary deployment in response to determining that the primary deployment is unavailable.
A method, comprising:
- copying database data stored in the primary deployment to a first region of the secondary deployment to cause the secondary deployment to copy the database data stored in the first region to a second region of the secondary deployment;
- determining that the primary deployment is unavailable;
- and
- executing one or more transactions on the database data at the secondary deployment in response to determining that the primary deployment is unavailable.
A non-transitory computer readable storage media comprising instructions that, when executed by a processor, cause the processor to:
- copy the database data stored in the primary deployment to a first region of the secondary deployment to cause the secondary deployment to copy the database data stored in the first region to a second region of the secondary deployment;
- determine that the primary deployment is unavailable;
- and
- execute one or more transactions on the database data at the secondary deployment in response to determining that the primary deployment is unavailable.
Dependencies are inferred from the claim text.