Deployment Overview of ClickHouse on Server¶

Prerequisites and Basic Requirements¶

To ensure a successful installation, the server must meet the following requirements:

Operating System: Ubuntu (versions prior to 24.04 or version 24.04).
Privileges: Root access or sudo privileges are required for package management and service configuration.
Dependencies: For Ubuntu 24.04, the python3-pexpect package is required during the installation process to handle interactive prompts.
Network Access: The server must have outbound internet access to download the ClickHouse installation script from https://clickhouse.com/.

The application is installed using an official installation script provided by the developer. The process follows these steps:

System Update: The package lists are updated via apt-get update to ensure all dependencies are current.
Script Acquisition: An installation script is downloaded from https://clickhouse.com/ and stored in the /root directory.
Automated Installation: The installer is executed using the command:
```
/root/clickhouse install
```
During this process, the following configurations are applied automatically:
A password for the default user is set.
Remote connections are enabled to allow the server to accept external requests.
Service Initialization: Once the installation is complete, the ClickHouse services are started using the clickhouse start command.

User Authentication: The default user is configured with a specific password during the installation phase to secure database access.
Network Security: The installer configures the server to accept remote connections; ensure that your local firewall (e.g., ufw) is configured to allow traffic only on required ClickHouse ports.

To update the ClickHouse application, you must re-run the installation script to apply any new versions or patches:

While specific ports may vary based on custom configuration, ClickHouse typically utilizes the following default port for client connections: