Skip to content

Scaling

Add shards and replicas, change the Keeper mode and the size, and grow storage.

Updated View as Markdown

Every change here is an update to the warehouse, which is modifying until it’s done. In the console, use the warehouse’s Configuration tab.

Add replicas

ezgh warehouse warehouses update whs_4k2m9x0a7qpe --replicas 3 --wait

Every shard gets the new replicas, which copy the shard’s tables and data from the existing ones. The update is done once they’ve caught up.

Add shards

ezgh warehouse warehouses update whs_4k2m9x0a7qpe --shards 4 --wait

Existing data stays on the current shards. Rows inserted through a Distributed table spread across all shards by its sharding key. The new shards get every database and table. See Sharding.

Keeper mode

ezgh warehouse warehouses update whs_4k2m9x0a7qpe --keeper colocated --wait

A warehouse with 3 or more nodes whose instance type has at least 8 vCPUs and 32 GiB of memory, and isn’t a shared vCPU type (gs-1), can use colocated; otherwise a warehouse with more than one node is dedicated. A change to a smaller instance type that’s below that while colocated is refused with 409 keeper_colocation_needs_larger_nodes, and one to a shared vCPU type with 400 invalid_request: switch to dedicated first. See Keeper mode.

Change the size

ezgh warehouse warehouses update whs_4k2m9x0a7qpe --instance-type gp-1.xlarge --wait

The warehouse moves one replica of each shard at a time.

Grow storage

ezgh warehouse warehouses update whs_4k2m9x0a7qpe --storage-size-gib 1000 --wait

Every node’s storage grows while it serves.

Navigation

Type to search…

↑↓ navigate↵ selectEsc close