Guide to deploying ClickHouse® on Scaleway Instances
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
-
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
-
Download the ClickHouse installer:
curl https://clickhouse.com/ | sh
-
Install the ClickHouse binary:
./clickhouse install
-
Decide if you want to accept connections from the network:
Allow server to accept connections from the network (default is localhost only), [y/N]:
-
Start the ClickHouse server:
clickhouse start
-
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.
Visit our Help Center and find the answers to your most frequent questions.
Visit Help Center