Skip to main content

Deploy ClickHouse

ClickHouse is an open-source column-oriented database management system that allows generating analytical data reports in real-time. It is optimized for high performance and can handle hundreds of millions of rows and tens of gigabytes of data. ClickHouse is used by companies like Cloudflare, eBay, and Yandex.

Deploy ClickHouse

Considerations

  • Size: The size of the instance that you want to deploy. You can see the available sizes here. The size of the instance will affect the performance of your queries. You will want to choose the size that fits your needs.

  • Region: The region where you want to deploy your instance. You can see the available regions here. This is important because the region will affect the latency of your queries. You will want to deploy your instance in the region that is closer to your users and yours data sources.

Deploy ClickHouse

Deploying a new ClickHouse instance is very easy. You just need to run the following command:

exy deploy \
--cloud aws \
--database clickhouse \
--org_id your-org_id \
--token your-awesome-token \
--plan professional \
--region us-east-1

The response will be a JSON object with the following properties:

{
  "cloud": "aws",
  "resource_id": "5c9f5b5c",
  "database": "clickhouse",
  "org_id": "your-org_id",
  "plan": "professional",
  "region": "us-east-1",
  "created_at": "2019-03-27T12:34:56.789Z",
}

You will receive an email with the information that you need to start to use the service.

The resource_id is the identifier of your ClickHouse instance. You will need it to manage your instance.

Access your ClickHouse instance

You can access your ClickHouse instance using ClickHouse Command-Line Tool. You can install it using the following command (Linux):

Visit ClickHouse download page to download the latest version of the ClickHouse Command-Line Tool.

Once you have installed the ClickHouse Command-Line Tool, you can connect to your ClickHouse instance using the following command:

clickhouse-client --host <HOSTNAME> \
                  --secure \
                  --port 9000 \
                  --user <USERNAME> \
                  --password <PASSWORD>

You will be prompted to enter your password. Once you have entered your password, you will be connected to your ClickHouse instance.

Manage your ClickHouse instance

You can manage your ClickHouse instance using the ClickHouse Command-Line Tool or any other ClickHouse client.

Change the password of your ClickHouse instance

Is highly recommended that you change the password of your ClickHouse instance. You can do it using the following command:

clickhouse-client --host <HOSTNAME> \
                  --secure \
                  --port 9000 \
                  --user <USERNAME> \
                  --password <PASSWORD>

ALTER USER <USERNAME> IDENTIFIED BY '<NEW_PASSWORD>';

Ready to roll?

Now that you have your ClickHouse instance up and running, you can start to use it. You can find more information about how to use ClickHouse in the ClickHouse documentation.

If you have any questions, please contact us at support@exy.com or sign up to the Time Series Community Slack.