公开(公告)号：US20250045083A1

公开(公告)日：2025-02-06

申请号：US18362587

申请日：2023-07-31

Applicant: Snowflake Inc.

Inventor： Daniel Geoffrey Karp ,  Themistoklis Melissaris ,  Kunal Prafulla Nabar ,  Samir Rehmtulla

IPC: G06F9/455

Abstract: Provided herein are systems and methods for distributed control plane enablement in a development environment of a database system. A first provisioning request for configuring a control plane environment at a computing node of a database system is decoded. The control plane environment corresponds to a control plane of the database system. A first VM cluster and a second VM cluster are instantiated at the computing node based on the first provisioning request. A cluster manager VM is instantiated within the first VM cluster. The cluster manager VM is configured with at least one control plane management function of the control plane environment. At least one foreground VM is instantiated within the first VM cluster. The at least one foreground VM is configured with at least one query processing function. A query received by the computing node is processed using the at least one query processing function.

公开(公告)号：US20230325362A1

公开(公告)日：2023-10-12

申请号：US18326645

申请日：2023-05-31

Applicant: Snowflake Inc.

Inventor： Johan Harjono ,  Daniel Geoffrey Karp ,  Rares Radut ,  Samir Rehmtulla ,  Arthur Kelvin Shi ,  Thanakul Wattanawong

IPC: G06F16/182 ,  G06F16/28

CPC classification number: G06F16/1824 ,  G06F16/285

Abstract: The subject technology selects a particular zone among multiple zones based on a target skew to meet a global balancing of cluster instances. The subject technology deploys a particular type of cluster instance to the particular zone. The subject technology, for each zone from the multiple zones, determines a respective number of cluster instances. The subject technology identifies a second particular type of cluster instance to add based on a total number of the second particular type of cluster instance in the multiple zones and a second total number of the particular type of cluster instance in the multiple zones. The subject technology adds the second particular type of cluster instance to a second particular zone to meet the global balancing of cluster instances in the multiple zones.

公开(公告)号：US11537566B1

公开(公告)日：2022-12-27

申请号：US17806852

申请日：2022-06-14

Applicant: Snowflake Inc.

Inventor： Johan Harjono ,  Daniel Geoffrey Karp ,  Rares Radut ,  Samir Rehmtulla ,  Arthur Kelvin Shi ,  Thanakul Wattanawong

IPC: G06F16/00 ,  G06F16/182 ,  G06F16/28

Abstract: The subject technology determines an availability zone skew among multiple zones. The subject technology, based on the availability zone skew, determines a target skew to meet a global balancing of cluster instances. The subject technology, based on the target skew, selects a particular zone among multiple zones. The subject technology deploys a particular type of cluster instance to the particular zone. The subject technology, for each zone from the multiple zones, determining a respective number of cluster instances. The subject technology identifies a first zone that includes a highest number of cluster instances based on the respective number of cluster instances from each zone. The subject technology identifies a second zone that includes a lowest number of cluster instances based on the respective number of cluster instances from each zone.

公开(公告)号：US11372820B1

公开(公告)日：2022-06-28

申请号：US17461169

申请日：2021-08-30

Applicant: Snowflake Inc.

Inventor： Johan Harjono ,  Daniel Geoffrey Karp ,  Rares Radut ,  Samir Rehmtulla ,  Arthur Kelvin Shi ,  Thanakul Wattanawong

IPC: G06F16/00 ,  G06F16/182 ,  G06F16/28

Abstract: The subject technology determines, after a period of time elapses over a periodic segment of time, an imbalance of cluster instances deployed in multiple zones based on a threshold value, the cluster instances including different types of clusters associated with compute service manager instances. The subject technology identifies a particular type of cluster instance to include in a particular zone from the multiple zones. The subject technology adds the particular type of cluster instance to the particular zone to meet a global balancing of cluster instances in the multiple zones. The subject technology determines, after a second period of time elapses over the periodic segment of time, that a number of cluster instances deployed in the multiple zones is below the threshold value indicating a current balance of cluster instances in the multiple zones.

公开(公告)号：US11966368B2

公开(公告)日：2024-04-23

申请号：US18326645

申请日：2023-05-31

Applicant: Snowflake Inc.

Inventor： Johan Harjono ,  Daniel Geoffrey Karp ,  Rares Radut ,  Samir Rehmtulla ,  Arthur Kelvin Shi ,  Thanakul Wattanawong

IPC: G06F16/00 ,  G06F16/182 ,  G06F16/28

CPC classification number: G06F16/1824 ,  G06F16/285

Abstract: The subject technology selects a particular zone among multiple zones based on a target skew to meet a global balancing of cluster instances. The subject technology deploys a particular type of cluster instance to the particular zone. The subject technology, for each zone from the multiple zones, determines a respective number of cluster instances. The subject technology identifies a second particular type of cluster instance to add based on a total number of the second particular type of cluster instance in the multiple zones and a second total number of the particular type of cluster instance in the multiple zones. The subject technology adds the second particular type of cluster instance to a second particular zone to meet the global balancing of cluster instances in the multiple zones.

公开(公告)号：US11698886B2

公开(公告)日：2023-07-11

申请号：US17936169

申请日：2022-09-28

Applicant: Snowflake Inc.

Inventor： Johan Harjono ,  Daniel Geoffrey Karp ,  Rares Radut ,  Samir Rehmtulla ,  Arthur Kelvin Shi ,  Thanakul Wattanawong

IPC: G06F16/00 ,  G06F16/182 ,  G06F16/28

CPC classification number: G06F16/1824 ,  G06F16/285

Abstract: The subject technology selects a particular zone among multiple zones based on a target skew to meet a global balancing of cluster instances. The subject technology deploys a particular type of cluster instance to the particular zone. The subject technology, for each zone from the multiple zones, determines a respective number of cluster instances. The subject technology identifies a second particular type of cluster instance to remove based on a total number of the second particular type of cluster instance in the multiple zones and a second total number of the particular type of cluster instance in the multiple zones. The subject technology removes the second particular type of cluster instance from a second particular zone to meet the global balancing of cluster instances in the multiple zones.

公开(公告)号：US20230069578A1

公开(公告)日：2023-03-02

申请号：US17936169

申请日：2022-09-28

Applicant: Snowflake Inc.

Inventor： Johan Harjono ,  Daniel Geoffrey Karp ,  Rares Radut ,  Samir Rehmtulla ,  Arthur Kelvin Shi ,  Thanakul WATTANAWONG

IPC: G06F16/182 ,  G06F16/28

Abstract: The subject technology selects a particular zone among multiple zones based on a target skew to meet a global balancing of cluster instances. The subject technology deploys a particular type of cluster instance to the particular zone. The subject technology, for each zone from the multiple zones, determines a respective number of cluster instances. The subject technology identifies a second particular type of cluster instance to remove based on a total number of the second particular type of cluster instance in the multiple zones and a second total number of the particular type of cluster instance in the multiple zones. The subject technology removes the second particular type of cluster instance from a second particular zone to meet the global balancing of cluster instances in the multiple zones.