What is a clear procedure to deploy ClickHouse on a Linux distribution for modest analytics workloads?

Installation Procedure

To deploy ClickHouse for a modest analytics workload, use the official repository packages to ensure systemd integration and dependency management.

1. Prerequisite Packages

• Ubuntu/Debian: wget gnupg lsb-release
• CentOS/RHEL: wget gnupg yum-utils

2. Repository Setup

Ubuntu/Debian:

# Import GPG key
sudo wget -O - https://packages.clickhouse.com/deb CLICKHOUSE-KEY.GPG | sudo apt-key add -
# Add repository
echo 'deb https://packages.clickhouse.com/deb stable main' | sudo tee /etc/apt/sources.list.d/clickhouse.list
sudo apt-get update

CentOS/RHEL:

# Import GPG key
sudo rpm --import https://packages.clickhouse.com/rpm CLICKHOUSE-KEY.GPG
# Add repository
sudo tee /etc/yum.repos.d/clickhouse.repo <

3. Installation and Service Startup

# Ubuntu/Debian
sudo apt-get install -y clickhouse-server clickhouse-client
# CentOS/RHEL
sudo yum install -y clickhouse-server clickhouse-client

# Enable and start service
sudo systemctl enable clickhouse-server
sudo systemctl start clickhouse-server

Configuration and Tuning

For modest workloads, modify /etc/clickhouse-server/config.xml or create a override file in /etc/clickhouse-server/config.d/ with these parameters:

• listen_host: Set to 0.0.0.0 for remote access or 127.0.0.1 for local-only access.
• max_concurrent_queries: Set to 16 to prevent resource exhaustion.
• max_memory_usage: Limit this to roughly 50% of total system RAM (e.g., 1000000000 for ~1GB on a 2GB machine) to avoid swapping.

Apply changes with: sudo systemctl restart clickhouse-server

Verification and Rollback

Verification Steps

1. Service Status: sudo systemctl status clickhouse-server (should be active/running).
2. Port Check: ss -tlnp | grep clickhouse (verify ports 9000 and 8123).
3. Connectivity: clickhouse-client --query 'SELECT version();'
4. Database Health: clickhouse-client --query 'SELECT * FROM system.tables LIMIT 5;'

Rollback Procedure

sudo systemctl stop clickhouse-server
# Ubuntu/Debian
sudo apt-get purge -y clickhouse-server clickhouse-client
# CentOS/RHEL
sudo yum remove -y clickhouse-server clickhouse-client
# Cleanup
sudo rm -f /etc/apt/sources.list.d/clickhouse.list /etc/yum.repos.d/clickhouse.repo

Deployment Comparison

Deb/RPM Packages: Recommended for most users. They automate systemd unit creation, user permission setup for /var/lib/clickhouse, and dependency resolution.

Binary Tarball: Provides a portable executable but requires manual configuration of ulimit (open files should be at least 262,144), manual systemd service file creation, and manual directory permission management.