Clickhouse Database Instance Installation on Ubuntu 22.04.2

Refer to the direct link for more details: -

https://clickhouse.com/docs/en/install

Step 1: Downloaded the installation file.

vboxuser@ikkanalytics:~$ sudo curl https://clickhouse.com/ | sh

  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current

                                 Dload  Upload   Total   Spent    Left  Speed

100  2739    0  2739    0     0   2019      0 --:--:--  0:00:01 --:--:--  2021

Will download https://builds.clickhouse.com/master/amd64/clickhouse into clickhouse

  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current

                                 Dload  Upload   Total   Spent    Left  Speed

100  518M  100  518M    0     0  10.2M      0  0:00:50  0:00:50 --:--:-- 10.3M

Successfully downloaded the ClickHouse binary, you can run it as:

   ./clickhouse

You can also install it:

    sudo ./clickhouse install

Step 2: Run installer.

vboxuser@ikkanalytics:~$ sudo ./clickhouse install

Copying ClickHouse binary to /usr/bin/clickhouse.new

Renaming /usr/bin/clickhouse.new to /usr/bin/clickhouse.

Creating symlink /usr/bin/clickhouse-server to /usr/bin/clickhouse.

Creating symlink /usr/bin/clickhouse-client to /usr/bin/clickhouse.

Creating symlink /usr/bin/clickhouse-local to /usr/bin/clickhouse.

Creating symlink /usr/bin/clickhouse-benchmark to /usr/bin/clickhouse.

Creating symlink /usr/bin/clickhouse-copier to /usr/bin/clickhouse.

Creating symlink /usr/bin/clickhouse-obfuscator to /usr/bin/clickhouse.

Creating symlink /usr/bin/clickhouse-git-import to /usr/bin/clickhouse.

Creating symlink /usr/bin/clickhouse-compressor to /usr/bin/clickhouse.

Creating symlink /usr/bin/clickhouse-format to /usr/bin/clickhouse.

Creating symlink /usr/bin/clickhouse-extract-from-config to /usr/bin/clickhouse.

Creating symlink /usr/bin/clickhouse-keeper to /usr/bin/clickhouse.

Creating symlink /usr/bin/clickhouse-keeper-converter to /usr/bin/clickhouse.

Creating symlink /usr/bin/clickhouse-disks to /usr/bin/clickhouse.

Creating clickhouse group if it does not exist.

 groupadd -r clickhouse

Creating clickhouse user if it does not exist.

 useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse clickhouse

Will set ulimits for clickhouse user in /etc/security/limits.d/clickhouse.conf.

Creating config directory /etc/clickhouse-server.

Creating config directory /etc/clickhouse-server/config.d that is used for tweaks of main server configuration.

Creating config directory /etc/clickhouse-server/users.d that is used for tweaks of users configuration.

Data path configuration override is saved to file /etc/clickhouse-server/config.d/data-paths.xml.

Log path configuration override is saved to file /etc/clickhouse-server/config.d/logger.xml.

User directory path configuration override is saved to file /etc/clickhouse-server/config.d/user-directories.xml.

OpenSSL path configuration override is saved to file /etc/clickhouse-server/config.d/openssl.xml.

Creating log directory /var/log/clickhouse-server.

Creating data directory /var/lib/clickhouse.

Creating pid directory /var/run/clickhouse-server.

 chown -R clickhouse:clickhouse '/var/log/clickhouse-server'

 chown -R clickhouse:clickhouse '/var/run/clickhouse-server'

 chown  clickhouse:clickhouse '/var/lib/clickhouse'

Enter password for default user: 

Password for default user is saved in file /etc/clickhouse-server/users.d/default-password.xml.

Setting capabilities for clickhouse binary. This is optional.

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

The choice is saved in file /etc/clickhouse-server/config.d/listen.xml.

 chown -R clickhouse:clickhouse '/etc/clickhouse-server'

ClickHouse has been successfully installed.

Start clickhouse-server with:

 sudo clickhouse start

Start clickhouse-client with:

 clickhouse-client --password

Step 2: Start database instance.

vboxuser@ikkanalytics:~$ sudo clickhouse start

 chown -R clickhouse: '/var/run/clickhouse-server/'

Will run sudo -u 'clickhouse' /usr/bin/clickhouse-server --config-file /etc/clickhouse-server/config.xml --pid-file /var/run/clickhouse-server/clickhouse-server.pid --daemon

Waiting for server to start

Waiting for server to start

Server started

Step 2: Check status.

vboxuser@ikkanalytics:~$ sudo clickhouse status

/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 44057.

The process with pid = 44057 is running.

vboxuser@ikkanalytics:~