US 12,423,323 B2
Data replication and data failover in data storage systems
Benoit Dageville, Seattle, WA (US); Eric Robinson, Sammamish, WA (US); and Martin Hentschel, Seattle, WA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Sep. 6, 2024, as Appl. No. 18/827,377.
Application 18/827,377 is a continuation of application No. 16/700,958, filed on Dec. 2, 2019, granted, now 12,105,734.
Application 16/700,958 is a continuation of application No. 16/392,258, filed on Apr. 23, 2019, granted, now 11,151,161, issued on Oct. 19, 2021.
Claims priority of provisional application 62/694,656, filed on Jul. 6, 2018.
Prior Publication US 2024/0427801 A1, Dec. 26, 2024
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/27 (2019.01); G06F 16/245 (2019.01); H04L 67/1097 (2022.01)
CPC G06F 16/273 (2019.01) [G06F 16/245 (2019.01); H04L 67/1097 (2013.01)] 24 Claims
OG exemplary drawing
 
12. A method comprising:
replicating data stored in a primary deployment such that the data is further stored in a secondary deployment;
executing, by a processor, one or more transactions on the data at the primary deployment to cause a change to the data to be stored in the primary deployment;
determining that the primary deployment transitioned from an available state to an unavailable state;
propagating the one or more transactions on the data to the secondary deployment to perform a failover to the secondary deployment while the change to the data is absent from the secondary deployment; and
adhering to a user-defined maximum acceptable time period for the secondary deployment to become available for executing queries on the data after the primary deployment is determined to be unavailable.