ALTER CLUSTER changes the configuration of a cluster. To rename a
ALTER ... RENAME.
|The size of the resource allocations for the cluster. See Size for details.
|The number of replicas to provision for the cluster. See Replication factor for details.
|The interval at which to collect introspection data. See Troubleshooting for details about introspection data. The special value
0 entirely disables the gathering of introspection data.
|Indicates whether to introspect the gathering of the introspection data.
IDLE ARRANGEMENT MERGE EFFORT
|Unstable. This option may be changed or removed at any time.
The amount of effort the replica should exert on compacting arrangements during idle periods.
|Whether to automatically manage the cluster’s replicas based on the configured size and replication factor. If
FALSE, enables the use of the deprecated
CREATE CLUSTER REPLICA command.
Alter cluster to two replicas:
ALTER CLUSTER c1 SET (REPLICATION FACTOR 2);
Alter cluster to size
ALTER CLUSTER c1 SET (SIZE 'xsmall');
Converting unmanaged to managed clusters
Unmanaged clusters are a deprecated feature of Materialize that required manual management of cluster replicas.
We recommend converting any unmanaged clusters to managed clusters by following the instructions below.
managed status of a cluster to managed:
ALTER CLUSTER c1 SET (MANAGED);
Materialize permits converting an unmanged cluster to a managed cluster if the following conditions are met:
- The cluster replica names are
- All replicas have the same size.
- If there are no replicas,
SIZEneeds to be specified.
- If specified, the replication factor must match the number of replicas.
Note that the cluster will not have settings for the availability zones, and compute-specific settings. If needed, these can be set explicitly.
The privileges required to execute this statement are:
- Ownership of the cluster.