Creating a ClickHouse Cluster

7 May 2023 · Read time 2 min

Creating a ClickHouse Cluster

These section covers how to use the Altinity Cloud Manager to create a ClickHouse cluster your your Google GKE Kubernetes environment.

To create a cluster (see Figure 1 for reference):

1. Use the The top left Environment menu to selects where your Google GKE environment is located. In this example as shown in Figure 1, the environment name is gkeanywhere.

2. Select Clusters from the navigation menu.

3. Select the LAUNCH CLUSTER blue button to launch the wizard.

4. The cluster panel is created, called test-gcp-anyw.

5. When the cluster has started, the status indicators shown in green will appear. These are nodes online and checks passed.

Figure 1 - The Clusters dashboard showing the ClickHouse cluster named test-gcp-anyw created in your Google GKE Kubernetes environment.

First time creating a cluster

If this is the first time you are viewing the Altinity Cloud Manager Clusters page, there will be no clusters, the screen will appear as in shown in Figure 2. The following steps lead you through the screens displayed by the Cluster Wizard. To create a new ClickHouse Cluster using the Launch Cluster wizard):

Figure 2 - The Clusters dashboard showing the ClickHouse cluster named test-gcp-anyw created in your Google GKE Kubernetes environment.

NOTE: Each of the 6 steps in the Wizard you can navigate back forth between the previously filled-in screens by selecting the title links on the left, or using the BACK and NEXT buttons.

To create a new ClickHouse cluster:

1. From your web browser in the Altinity Cloud Manager, select Clusters.
2. Select the LAUNCH CLUSTERS blue button.
3. In step 1, the ClickHouse Setup screen, fill in the following and select the blue NEXT button:
   • Name = test-gcp-anyw (15-character limit, lower-case letters only)
   • ClickHouse Version = ALTINITY BUILDS: 22.8.15 Stable Build
   • ClickHouse User Name = admin
   • ClickHouse User Password = admin-password (example password) then select NEXT.
4. In step 2, the Resources Configuration screen, fill in the following then select NEXT button:
   • Node Type = n2-standard-4 (CPU x4, RAM 13 GB)
   • Node Storage = 50 GB
   • Volume Type = premium-rwo
   • Number of Shards = 1 then select NEXT.
5. In step 3, the High Availability Configuration screen, fill in the following then select NEXT:
   • Number of Replicas = 1
   • Zookeeper Configuration = Dedicated
   • Zookeeper Node Type = default
   • Backup Schedule = Monthly, Day of Week/Month = 1, Time (GMT) = 05:00 AM, Backups to Keep = 7
   • Number of Backups to keep = 0 (leave blank) then select NEXT.
6. In step 4, Connection Configuration screen, fill in the following then select NEXT:
   • Endpoint = test-gcp-anyw.aws-environment-name.altinity.cloud (autofilled)
   • Use TLS = Checked
   • Load Balancer Type = Altinity Edge Ingress
   • Protocols: Binary Protocol (port:9440) - is checked ON
   • Protocols: HTTP Protocol (port:8443) - is checked ON
   • Datadog integration = disabled (greyed out, ask Altinity to enable)
   • IP restrictions = OFF (Enabled is unchecked)
7. In step 5, Uptime Schedule screen, select ALWAYS ON then select NEXT.
8. In step 6, the final screen Review & Launch, select the green LAUNCH button.

Your new ClickHouse Cluster will start building, and will complete with the green boxes under your cluster name test-gcp-anyw;

• 1 / 1 nodes online
• Health: 6/6 checks passed