Guide to deploying ClickHouse® on Scaleway Instances

• clickhouse
• big-data

ClickHouse® is an open-source column-oriented database management system that allows you to generate analytical data reports in real-time. It uses a user-friendly SQL query dialect, provides built-in analytics capabilities, and its performance exceeds all other column-oriented database management systems.

Before you start

To complete the actions presented below, you must have:

• A Scaleway account logged into the console
• Owner status or IAM permissions allowing you to perform actions in the intended Organization
• An SSH key
• An Instance running on Ubuntu or Debian

Installing ClickHouse

1. Log into your Instance using SSH.

2. Update the apt package cache and upgrade the software already installed on the Instance to the latest version available in the distribution repositories.

   apt update && apy upgrade -y
   

3. Download the ClickHose installer:

   curl https://clickhouse.com/ | sh
   

4. Install the ClickHouse binary:

   ./clickhouse install
   

   Note

   Enter the password for the default user when prompted:

   Enter password for default user:
   

5. Decide if you want to accept connections from the network:

   Allow server to accept connections from the network (default is localhost only), [y/N]:
   

6. Start the ClickHouse server:

   clickhouse start
   

7. Start the clickhouse-client with:

   clickhouse-client --password
   

   Enter the password when prompted:

   root@scw-epic-chatelet:~# clickhouse-client --password
   ClickHouse client version 24.6.1.3936 (official build).
   Password for user (default):
   Connecting to localhost:9000 as user default.
   Connected to ClickHouse server version 24.6.1.
   

ClickHouse provides a wide range of demo datasets and tutorials to load and test the application. Visit the official website and documentation for more information.