Install ClickHouse on Debian/Ubuntu

Before installing ClickHouse, review the following 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.

Estimating storage requirements

To estimate the disk space needed for your data:

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.

For more detailed hardware requirements, see “Sizing and hardware recommendations”

To install ClickHouse run the following commands:

# Install prerequisite packages
sudo apt-get install -y apt-transport-https ca-certificates curl gnupg

# Download the ClickHouse GPG key and store it in the keyring
curl -fsSL 'https://packages.clickhouse.com/rpm/lts/repodata/repomd.xml.key' | sudo gpg --dearmor -o /usr/share/keyrings/clickhouse-keyring.gpg

# Get the system architecture
ARCH=$(dpkg --print-architecture)

# Add the ClickHouse repository to apt sources
echo "deb [signed-by=/usr/share/keyrings/clickhouse-keyring.gpg arch=${ARCH}] https://packages.clickhouse.com/deb stable main" | sudo tee /etc/apt/sources.list.d/clickhouse.list

# Update apt package lists
sudo apt-get update

• 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.

# Install prerequisite packages
sudo apt-get install apt-transport-https ca-certificates dirmngr

# Add the ClickHouse GPG key to authenticate packages
sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv 8919F6BD2B48D754

# Add the ClickHouse repository to apt sources
echo "deb https://packages.clickhouse.com/deb stable main" | sudo tee \
    /etc/apt/sources.list.d/clickhouse.list
    
# Update apt package lists
sudo apt-get update

# Install ClickHouse server and client packages
sudo apt-get install -y clickhouse-server clickhouse-client

# Start the ClickHouse server service
sudo service clickhouse-server start

# Launch the ClickHouse command line client
clickhouse-client # or "clickhouse-client --password" if you set up a password.

To start the ClickHouse server, run:

sudo service clickhouse-server start

To start ClickHouse client, run:

clickhouse-client

If you set up a password for your server, then you will need to run:

clickhouse-client --password

To install clickhouse-keeper on standalone ClickHouse Keeper servers, run:

sudo apt-get install -y clickhouse-keeper