​

Review recommendations

• Swap: Disable the operating system’s swap file in production environments.
• Disk space: The ClickHouse binary requires at least 2.5 GB of disk space for installation.
• Network: For distributed deployments (clustering), use at least 10 Gbit network connectivity. Network bandwidth is critical for processing distributed queries with large amounts of intermediate data, as well as for replication.

1. Estimate data volume: Take a sample of your data and calculate the average row size, then multiply by the number of rows you plan to store.
2. Apply the compression coefficient: Load a sample into ClickHouse and compare the original data size with the stored table size. Clickstream data, for example, is typically compressed 6-10x.
3. Account for replicas: If you plan to store data in multiple replicas, multiply the estimated volume by the number of replicas.

​

Set up the RPM repository

sudo yum install -y yum-utils
sudo yum-config-manager --add-repo https://packages.clickhouse.com/rpm/clickhouse.repo

sudo zypper addrepo -r https://packages.clickhouse.com/rpm/clickhouse.repo -g
sudo zypper --gpg-auto-import-keys refresh clickhouse-stable

​

Install ClickHouse server and client

sudo yum install -y clickhouse-server clickhouse-client

• You can replace stable with lts to use different release kinds based on your needs.
• You can download and install packages manually from packages.clickhouse.com/rpm.
• To specify a particular version, add -$version to the end of the package name, for example:

sudo yum install clickhouse-server-22.8.7.34

​

Start ClickHouse server

sudo systemctl enable clickhouse-server
sudo systemctl start clickhouse-server
sudo systemctl status clickhouse-server

clickhouse-client

clickhouse-client --password

​

Install standalone ClickHouse Keeper

sudo yum install -y clickhouse-keeper

​

Enable and start ClickHouse Keeper

sudo systemctl enable clickhouse-keeper
sudo systemctl start clickhouse-keeper
sudo systemctl status clickhouse-keeper