CLUSTER BALANCING FOR ZONES OF A DATABASE SYSTEM

    公开(公告)号:US20230325362A1

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

    申请号:US18326645

    申请日:2023-05-31

    Applicant: Snowflake Inc.

    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.

    Cluster balancing for zones of a database system

    公开(公告)号:US11966368B2

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

    申请号:US18326645

    申请日:2023-05-31

    Applicant: Snowflake Inc.

    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.

    Cluster instance balancing of a database system across zones

    公开(公告)号:US11698886B2

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

    申请号:US17936169

    申请日:2022-09-28

    Applicant: Snowflake Inc.

    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.

    Zone balancing in a multi cluster database system

    公开(公告)号:US11537566B1

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

    申请号:US17806852

    申请日:2022-06-14

    Applicant: Snowflake Inc.

    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.

    Zone balancing in a multi cluster database system

    公开(公告)号:US11372820B1

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

    申请号:US17461169

    申请日:2021-08-30

    Applicant: Snowflake Inc.

    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.

Patent Agency Ranking