Create a Managed ClickHouse® cluster
-
Go to the Clusters overview
-
Click Create cluster in the upper-right corner of the page.
-
Select ClickHouse®.
-
Choose a provider and a region.
-
Under Resources:
-
Select the
s1-c2-m4
preset for CPU, RAM capacity, and storage space to create a cluster with minimal configuration.Understand your ClickHouse® resource presetA resource preset has the following structure:
<CPU platform> - C<number of CPU cores> - M<number of gigabytes of RAM>
There are three available CPU platforms:
-
g
- ARM Graviton -
i
- Intel (x86) -
s
- AMD (x86)
For example, the
i1-c2-m8
preset means that it's an Intel platform 2-core CPU with 8 gigabytes of RAM.You can see the availability of CPU platforms across our Managed Service for ClickHouse® areas and regions.
-
-
Choose the number of replicas. Let's keep it as is with a single replica.
-
Select the number of shards. Keep a single shard.
Understand shards and replicas
Shards refer to the servers that contain different parts of the data (to read all the data, you must access all the shards). Replicas are duplicating servers (to read all the data, you can access the data on any of the replicas).
-
-
Under Basic settings:
-
Enter the cluster Name, in this scenario -
tutorial-cluster
. -
From the Version drop-down list, select the ClickHouse® version the Managed ClickHouse® cluster will use. For most clusters, we recommend using the latest version.
-
-
Under Advanced:
-
Under Maintenance settings, select the scheduling type:
-
Arbitrary to delegate maintenance window selection to DoubleCloud. Usually, your cluster will perform maintenance procedure at the earliest available time slot.
Warning
We suggest not to use this scheduling type with single-host clusters, as it can lead to your cluster becoming unavailable at random.
-
By schedule to set the weekday and time (UTC) when DoubleCloud may perform maintenance on your cluster.
-
-
Under Networking → VPC, specify in which DoubleCloud VPC to locate your cluster. Use the
default
value in the previously selected region if you don't need to create this cluster in a specific network. -
Select the allocation for the ClickHouse Keeper service -
embedded
ordedicated
.We recommend using dedicated hosts for high-load production clusters. Dedicated ClickHouse Keeper hosts ensure that your production cluster's performance remains unaffected under heavy loads - they don't use its CPU or memory.
ClickHouse Keeper host location is irreversible
After creating the cluster, you won't be able to change the ClickHouse Keeper deployment type.
For dedicated ClickHouse Keeper hosts, select the appropriate resource preset. Please note that this resource preset will apply to all three hosts and will be billed accordingly.
-
Specify or adjust your cluster's DBMS settings. For more information, see the Settings reference.
-
-
Click Submit.
Your cluster will appear with the Creating
status on the Clusters page in the console. Setting everything up may take some time. When the cluster is ready, it changes its state to Alive
.
Click on the cluster to open its information page:
Tip
The DoubleCloud service creates the superuser admin
and its password automatically. You can find both the User and the Password in the Overview tab on the cluster information page.
To create users for other roles, see Manage ClickHouse® users
To create a ClickHouse® cluster, use the ClusterService
create method. The required parameters to create a functional cluster:
-
project_id
- the ID of your project. You can get this value on your project's information page. -
cloud_type
- currently, you can use only the defaultaws
type. -
region_id
- for the list of available regions and their region codes, see Areas and regions for Managed Service for ClickHouse®. -
name
- your cluster's name. It must be unique within the project. -
resources
- specify the following from the doublecloud.clickhouse.v1.ClusterResources model:-
resource_preset_id
- specify the name of the hardware resource preset for your cluster. For the list of available presets for ClickHouse® clusters, see DoubleCloud hardware instances. -
disk_size
- the storage size for your cluster in bytes. We recommend allocating no less than34359738368
bytes (32 GB). -
replica_count
- specify the number of replicas between1
and3
. -
shard_count
- specify the number of shards.
-
import json
import logging
from google.protobuf.wrappers_pb2 import Int64Value
import doublecloud
from doublecloud.clickhouse.v1.cluster_pb2 import ClusterResources
from doublecloud.clickhouse.v1.cluster_service_pb2 import CreateClusterRequest
from doublecloud.clickhouse.v1.cluster_service_pb2_grpc import ClusterServiceStub
def create_cluster(sdk, project_id, region_id, name, network_id):
cluster_service = sdk.client(ClusterServiceStub)
operation = cluster_service.Create(
CreateClusterRequest(
project_id="<your_project_id>",
cloud_type="aws",
region_id="<resource_preset>",
name="<cnew_cluster_name>",
resources=ClusterResources(
clickhouse=ClusterResources.Clickhouse(
resource_preset_id="s1-c2-m4",
disk_size=Int64Value(value=<Storage_size_in_bytes>),
replica_count=Int64Value(value=<number_of_replicas>),
)
),
network_id=network_id,
)
)
logging.info("Creating initiated")
return operation
package main
import (
"context"
"flag"
"fmt"
"log"
"github.com/doublecloud/go-genproto/doublecloud/clickhouse/v1"
dc "github.com/doublecloud/go-sdk"
"google.golang.org/protobuf/types/known/wrapperspb"
"github.com/doublecloud/go-sdk/iamkey"
"github.com/doublecloud/go-sdk/operation"
)
func createCluster(ctx context.Context, dc *dc.SDK, flags *cmdFlags) (*operation.Operation, error) {
x, err := dc.ClickHouse().Cluster().Create(ctx, &clickhouse.CreateClusterRequest{
ProjectId: *flags.projectID,
CloudType: "aws",
RegionId: *flags.region,
Name: *flags.name,
Resources: &clickhouse.ClusterResources{
Clickhouse: &clickhouse.ClusterResources_Clickhouse{
ResourcePresetId: "s1-c2-m4",
DiskSize: wrapperspb.Int64(32 * 2 << 30),
ReplicaCount: wrapperspb.Int64(1),
},
},
NetworkId: *flags.networkID,
})
if err != nil {
return nil, err
}
log.Println("Creating clickhouse cluster ...")
log.Println("https://app.double.cloud/clickhouse/" + x.ResourceId + "/operations")
op, err := dc.WrapOperation(x, err)
if err != nil {
panic(err)
}
err = op.Wait(ctx)
return op, err
}
For more in-depth examples, check out DoubleCloud API Go SDK repository