Manage your Managed ClickHouse® service

Day-to-day operations on a Managed ClickHouse® service.

Prerequisites

• Exoscale CLI version 1.97 or later. Earlier releases expose no ClickHouse commands at all, and every command on this page fails as an unknown command.

Inspect a service

Read the full service description, including state, version, plan, components and backups:

exo x get-dbaas-service-clickhouse my-clickhouse -z ch-gva-2

Monitor a service

Expose your service metrics to your own monitoring stack with an external endpoint. See Managed ClickHouse® metrics available via Prometheus and Managed ClickHouse® metrics available via Datadog.

Query level statistics are available in the service itself, see Fetch query statistics.

Resize a service

Change the plan of a running service to add capacity. See Scaling a managed service:

echo '{"plan":"startup-32"}' | \
  exo x update-dbaas-service-clickhouse my-clickhouse -z ch-gva-2

Schedule maintenance updates

Set the weekly window during which Exoscale applies maintenance:

echo '{"maintenance":{"dow":"sunday","time":"04:00:00"}}' | \
  exo x update-dbaas-service-clickhouse my-clickhouse -z ch-gva-2

Apply the pending maintenance updates immediately, without waiting for the next window:

exo x start-dbaas-clickhouse-maintenance my-clickhouse -z ch-gva-2

Maintenance replaces the service nodes, so expect a short interruption, longer on single-node plans. Some features expect a fully updated service: for example, all maintenance updates must be applied before you enable tiered storage.

See Maintenance window for the platform behavior.

Fork a service

Create a new service from a backup of an existing one, see Fork and restore from Managed ClickHouse® backups.

Delete a service

exo x delete-dbaas-service-clickhouse my-clickhouse -z ch-gva-2

If the service is protected against termination, the deletion is refused until you disable the protection, see Secure a Managed ClickHouse® service.