Deployment Overview of ClickHouse on Server¶

Prerequisites and Basic Requirements¶

Operating System: Ubuntu (compatible with versions supporting apt and python3-pexpect for Ubuntu 24.x).
User Privileges: Root access is required to execute installation scripts and manage services.
Package Manager: The system must have apt configured to install dependencies.
Dependencies: The python3-pexpect package is required on Ubuntu 24.x systems to handle interactive installation prompts.

File and Directory Structure¶

Installation Script: The ClickHouse installation script is downloaded to /root/clickhouse.
Execution Directory: The download and initial setup commands are executed within the /root directory.

Application Installation Process¶

The application is installed using an official installer script downloaded directly from the ClickHouse website. The process involves the following steps:

Update the local package index using apt-get update.
Download the installation script using curl.
Execute the installation script with non-interactive prompts for the default user password and connection permissions.

The installation is performed by running the following command sequence from the /root directory:

curl https://clickhouse.com/ | sh

Following the script download, the specific installation command is executed to handle the setup wizard:

/root/clickhouse install

During the installation, the following configurations are applied:

The default user password is set to the root user's current SSH password.
The server is configured to accept external connections (Allow server to accept connections is set to y).

Starting, Stopping, and Updating¶

After the installation is complete, the ClickHouse services are started manually. The specific command used to initiate the service is:

clickhouse start

The clickhouse command-line interface is used for service management operations.

Access Rights and Security¶

The installation script configures the server to accept incoming connections immediately upon setup.
The default user password is established during the installation phase based on the root user credentials provided during the setup.
All installation and service management tasks are performed with root privileges.