Granted Patent B2

US 12,235,868 · App. 18/323,155 · Granted Feb 25, 2025

Inventors: Robert Bengt Benedikt Gernhardt (Seattle, WA); Mikhail Kazhamiaka (Bellevue, WA); Nithin Mahesh (Redmond, WA); Laxman Mamidi (Redwood City, CA); Subramanian Muralidhar (Mercer Island, WA); Vishnu Dutt Paladugu (Seattle, WA); Sahaj Saini (Seattle, WA)

Assignee: Snowflake Inc.

G06F16/27G06F11/1461G06F11/1464G06F11/2023G06F11/2097G06F16/128G06F16/137G06F16/1787G06F16/1827G06F16/184G06F16/1844G06F16/256

Abstract

Claims (96)

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.

2. The system of claim 1 , wherein the instructions further cause the at least one hardware processor to perform operations comprising:

initiating replication of the one or more data object types from the new source account to a new target account of the database system user based on the promoting of the target account.

3. The system of claim 1 , wherein the instructions further cause the at least one hardware processor to perform operations comprising:

detecting the manifest of the RGO includes an allowed failover property, the allowed failover property indicating one or more additional accounts of the database system user that are authorized for configuration as the new source account based on the detecting of the network failure.

4. The system of claim 3 , wherein the instructions further cause the at least one hardware processor to perform operations comprising:

updating a manifest of the FGO to indicate the target account is a replica of the source account, the updating based on a completion of the promoting of the target account.

5. The system of claim 1 , wherein the instructions further cause the at least one hardware processor to perform operations comprising:

updating the manifest to configure replication of the RGO as a second FGO within a second target account based on the detecting of the network failure.

6. The system of claim 1 , wherein the instructions further cause the at least one hardware processor to perform operations comprising:

performing the replicating of the RGO as the FGO within the target account of the database system user at a first replication schedule specified by the manifest.

7. The system of claim 6 , wherein the instructions further cause the at least one hardware processor to perform operations comprising:

performing a replication of the RGO as a second FGO within a second target account based on the detecting of the network failure, the replication of the RGO as the second FGO performed at a second replication schedule specified by the manifest.

8. The system of claim 1 , wherein the one or more data object types comprise at least one of:

a users account object type, wherein a users account object of the users account object type lists users authorized to access the target account;

a roles account object type, wherein a roles account object of the roles account object type configures one or more access privileges for accessing the target account;

a warehouse object type, wherein a warehouse object of the warehouse object type indicates compute resources for executing a workload associated with the one or more databases;

a resource monitor object type, wherein a resource monitor object of the resource monitor object type configures monitoring usage of the compute resources; and

a database account object type, wherein a database account object of the database account object type indicates the one or more databases.

9. The system of claim 1 , wherein the instructions further cause the at least one hardware processor to perform operations comprising:

detecting one or more access privileges associated with the second geographic location and specified by at least one of the data objects of the one or more data object types listed in the manifest;

granting at least one computing device at the first geographic location, access to the data objects replicated into the target account based on the one or more access privileges;

performing a refresh operation of the FGO at the target account based on a refresh command for the FGO; and

generating a notification based on the refresh operation.

10. A method comprising:

performing by at least one hardware processor:

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.

11. The method of claim 10 , further comprising:

initiating replication of the one or more data object types from the new source account to a new target account of the database system user based on the promoting of the target account.

12. The method of claim 10 , further comprising:

detecting the manifest of the RGO includes an allowed failover property, the allowed failover property indicating one or more additional accounts of the database system user that are authorized for configuration as the new source account based on the detecting of the network failure.

13. The method of claim 12 , further comprising:

updating a manifest of the FGO to indicate the target account is a replica of the source account, the updating based on a completion of the promoting of the target account.

14. The method of claim 10 , further comprising:

updating the manifest to configure replication of the RGO as a second FGO within a second target account based on the detecting of the network failure.

15. The method of claim 10 , further comprising:

performing the replicating of the RGO as the FGO within the target account of the database system user at a first replication schedule specified by the manifest.

16. The method of claim 15 , further comprising:

performing a replication of the RGO as a second FGO within a second target account based on the detecting of the network failure, the replication of the RGO as the second FGO performed at a second replication schedule specified by the manifest.

17. The method of claim 10 , wherein the one or more data object types comprise at least one of:

a users account object type, wherein a users account object of the users account object type lists users authorized to access the target account;

a roles account object type, wherein a roles account object of the roles account object type configures one or more access privileges for accessing the target account;

a warehouse object type, wherein a warehouse object of the warehouse object type indicates compute resources for executing a workload associated with the one or more databases;

a resource monitor object type, wherein a resource monitor object of the resource monitor object type configures monitoring usage of the compute resources; and

a database account object type, wherein a database account object of the database account object type indicates the one or more databases.

18. The method of claim 10 , further comprising:

detecting one or more access privileges associated with the second geographic location and specified by at least one of the data objects of the one or more data object types listed in the manifest;

granting at least one computing device at the first geographic location, access to the data objects replicated into the target account based on the one or more access privileges;

performing a refresh operation of the FGO at the target account based on a refresh command for the FGO; and

generating a notification based on the refresh operation.

19. A computer-storage medium comprising instructions that, when executed by one or more processors of a machine, configure the machine 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.

20. The computer-storage medium of claim 19 , the operations further comprising:

initiating replication of the one or more data object types from the new source account to a new target account of the database system user based on the promoting of the target account.

21. The computer-storage medium of claim 19 , the operations further comprising:

detecting the manifest of the RGO includes an allowed failover property, the allowed failover property indicating one or more additional accounts of the database system user that are authorized for configuration as the new source account based on the detecting of the network failure.

22. The computer-storage medium of claim 21 , the operations further comprising:

updating a manifest of the FGO to indicate the target account is a replica of the source account, the updating based on a completion of the promoting of the target account.

23. The computer-storage medium of claim 19 , the operations further comprising:

updating the manifest to configure replication of the RGO as a second FGO within a second target account based on the detecting of the network failure.

24. The computer-storage medium of claim 19 , the operations further comprising:

performing the replicating of the RGO as the FGO within the target account of the database system user at a first replication schedule specified by the manifest.

25. The computer-storage medium of claim 24 , the operations further comprising:

performing a replication of the RGO as a second FGO within a second target account based on the detecting of the network failure, the replication of the RGO as the second FGO performed at a second replication schedule specified by the manifest.

26. The computer-storage medium of claim 19 , wherein the one or more data object types comprise at least one of:

a users account object type, wherein a users account object of the users account object type lists users authorized to access the target account;

a roles account object type, wherein a roles account object of the roles account object type configures one or more access privileges for accessing the target account;

a warehouse object type, wherein a warehouse object of the warehouse object type indicates compute resources for executing a workload associated with the one or more databases;

a resource monitor object type, wherein a resource monitor object of the resource monitor object type configures monitoring usage of the compute resources; and

a database account object type, wherein a database account object of the database account object type indicates the one or more databases.

27. The computer-storage medium of claim 19 , the operations further comprising:

detecting one or more access privileges associated with the second geographic location and specified by at least one of the data objects of the one or more data object types listed in the manifest;

granting at least one computing device at the first geographic location, access to the data objects replicated into the target account based on the one or more access privileges;

performing a refresh operation of the FGO at the target account based on a refresh command for the FGO; and

generating a notification based on the refresh operation.

Assignments (1)

Continuity (3)

References Cited (80)