US 12,235,868 B2
Failover configuration using replication group objects
Robert Bengt Benedikt Gernhardt, Seattle, WA (US); Mikhail Kazhamiaka, Bellevue, WA (US); Nithin Mahesh, Redmond, WA (US); Laxman Mamidi, Redwood City, CA (US); Subramanian Muralidhar, Mercer Island, WA (US); Vishnu Dutt Paladugu, Seattle, WA (US); and Sahaj Saini, Seattle, WA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on May 24, 2023, as Appl. No. 18/323,155.
Application 18/323,155 is a continuation of application No. 17/457,751, filed on Dec. 6, 2021, granted, now 11,748,374.
Claims priority of provisional application 63/264,699, filed on Nov. 30, 2021.
Prior Publication US 2023/0297590 A1, Sep. 21, 2023
Int. Cl. G06F 16/00 (2019.01); G06F 11/14 (2006.01); G06F 11/20 (2006.01); G06F 16/11 (2019.01); G06F 16/13 (2019.01); G06F 16/178 (2019.01); G06F 16/182 (2019.01); G06F 16/25 (2019.01); G06F 16/27 (2019.01)
CPC G06F 16/27 (2019.01) [G06F 11/1461 (2013.01); G06F 11/1464 (2013.01); G06F 11/2023 (2013.01); G06F 11/2097 (2013.01); G06F 16/128 (2019.01); G06F 16/137 (2019.01); G06F 16/1787 (2019.01); G06F 16/1827 (2019.01); G06F 16/184 (2019.01); G06F 16/1844 (2019.01); G06F 16/256 (2019.01)] 27 Claims
OG exemplary drawing
 
1. A system comprising:
at least one hardware processor; and
at least one memory storing instructions that cause the at least one hardware processor to perform operations comprising:
generating at a source account of a database system user at a first geographic location, a replication group object (RGO) based on a replication request received from a client device of the database system user, the RGO comprising a manifest listing one or more data object types and one or more databases identified by the replication request to be replicated together as a replication unit;
performing a replication of data objects of the one or more data object types from the one or more databases at the first geographic location to a target account of the database system user at a second geographic location, the replication of the data objects being performed at a same time as the replication unit;
replicating the RGO as a failover group object (FGO) within the target account of the database system user at the second geographic location, the replicating as the FGO based on the manifest;
detecting a network failure at a first computing node associated with the source account of the database system user at the first geographic location;
promoting the target account of the database system user at the second geographic location as a new source account based on the detecting of the network failure at the first geographic location;
granting at least a second computing node seeking access to the source account at the first geographic location, access to the new source account at the second geographic location based on the promoting; and
updating the manifest of the source account to indicate failover to the target account and replication of the source account to at least one additional account of the database system user are authorized based on the detecting of the network failure.