NavigationContentFooter
Suggest an edit

Guide to deploying ClickHouse® on Scaleway Instances

Reviewed on 17 June 2024Published on 01 December 2022
  • 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.

Docs APIScaleway consoleDedibox consoleScaleway LearningScaleway.comPricingBlogCarreer
© 2023-2024 – Scaleway