How to create a ClickHouse cluster

Objective

ClickHouse is an open-source, columnar analytical database system designed for real-time processing of massive data volumes, providing high performance, scalability, and low latency.

This guide explains how to create a ClickHouse cluster via the OVHcloud Control Panel.

Requirements

• Access to the OVHcloud Control Panel.
• A Public Cloud project in your OVHcloud account.

Instructions

Subscribing to the service

Log in to the OVHcloud Control Panel and switch to Public Cloud in the top navigation bar. After selecting your Public Cloud project, click on Data Streaming in the left-hand navigation bar under Databases & Analytics.

Click the Create a service button.

Selecting your Analytics service

Click on the type of Analytics service you want to use and its version.

A random name is generated for your service. You can change it at this step or later.

Selecting a datacentre

Choose the geographical region of the datacentre where your service will be hosted and the deployment mode (1-AZ vs 3-AZ).

Selecting a plan

In this step, choose an appropriate service plan. If needed, you can upgrade or downgrade the plan after creation.

Visit the capabilities page of your selected Analytics service for detailed information on each plan's properties.

Selecting the instance

Choose the instance type for the nodes of your service. You can change it afterward. The number of nodes depends on the plan previously chosen.

Selecting the storage

Storage can be scaled up to 3 times the base storage.

Configuring your options

Choose the network options and whitelist the IP addresses that will access your service.

Reviewing and confirming

A summary of your order is displayed to help you review your service configuration.

The components of the price are also summarized with a monthly estimation.

Click the API and Terraform equivalent button to open the following window:

Use this information to automate service creation with the OVHcloud API or the OVHcloud Terraform Provider.

When you are ready, click the Order button to create your service.

In a matter of minutes, your new ClickHouse service will be deployed.

Messages in the OVHcloud Control Panel will inform you when the ClickHouse cluster is ready to use.

We want your feedback!

We would love to help answer questions and appreciate any feedback you may have.

If you need training or technical assistance to implement our solutions, contact your sales representative or click on this link to get a quote and ask our Professional Services experts for a custom analysis of your project.

Are you on Discord? Connect to our channel at https://discord.gg/ovhcloud and interact directly with the team that builds our Analytics service!

Join our community of users.