ezgh warehouse warehouses update <warehouse> [flags] [--wait]Change a warehouse. Only what’s given changes. --shards and --replicas add shards or replicas; existing data stays on the current shards, and rows inserted through a Distributed table spread across all shards by its sharding key. --keeper switches the Keeper mode. A new instance type changes one replica of each shard at a time. --engine-version upgrades to a newer ClickHouse version, one-way; it asks first on a terminal, and --yes confirms otherwise. Shards and replicas, --keeper and --engine-version each change on their own. --tag replaces all its tags and --clear-tags removes them. --wait waits until it’s done and prints it.
Part of ezgh warehouse warehouses.
Examples
ezgh warehouse warehouses update analytics --shards 4 --wait
ezgh warehouse warehouses update analytics --engine-version 26.8 --yes --waitFlags
| Flag | Type | Default | Description |
|---|---|---|---|
--allowed-source-cidr |
string, repeatable | an IPv4 CIDR that may connect; repeat for more, at most 20; replaces them all | |
--backup-retention-days |
int | how long backups are kept, 1 to 35 days (default 7) | |
--backup-window |
string | when the daily backup is taken, HH:MM-HH:MM UTC | |
--backups |
boolean | true |
daily backups (--backups=false turns them off) |
--clear-tags |
boolean | remove its tags | |
--deletion-protection |
boolean | refuse deletes (--deletion-protection=false allows them again) |
|
--description |
string | a new description | |
--engine-version |
string | a newer ClickHouse version (one-way) | |
--instance-type |
string | a new instance type | |
--keeper |
string | the Keeper mode: dedicated or colocated | |
--maintenance-window |
string | when maintenance happens, ddd:HH:MM-ddd:HH:MM UTC | |
--name |
string | a new name | |
--plaintext-port |
boolean | serve 8123 and 9000 without TLS inside the VPC (--plaintext-port=false turns them off) |
|
--replicas |
int | how many replicas of each shard, up to 3 | |
--shards |
int | how many shards, up to 8 | |
--storage-size-gib |
int | each node’s storage, in GiB | |
--tag |
string, repeatable | a tag, key=value; repeat for more; replaces them all | |
--wait |
boolean | wait until it’s done, and print it then | |
--wait-timeout |
duration | 10m0s |
how long --wait waits |
-y, --yes |
boolean | don’t ask for confirmation of an upgrade |
This command also takes the global flags.