Skip to navigationSkip to main contentSkip to footerScaleway Docs

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:

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 && apt upgrade -y
  3. Download the ClickHouse 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.

Questions?

Visit our Help Center and find the answers to your most frequent questions.

Visit Help Center
No Results