推荐订阅源

一、系统环境配置

vim /etc/security/limits.conf 
* soft nofile 65536
* hard nofile 131072
* soft nproc 30000 #ClickHouse推荐不小于30000
* hard nproc 30000
* soft memlock unlimited
* hard memlock unlimited

echo "kernel.task_delayacct = 1" >>  /etc/sysctl.conf #启用延迟统计
echo never > /sys/kernel/mm/transparent_hugepage/enabled #禁用透明大页
echo never > /sys/kernel/mm/transparent_hugepage/defrag

reboot #重启

二、配置yum仓库及安装clickhouse

yum install -y yum-utils
yum-config-manager --add-repo https://packages.clickhouse.com/rpm/clickhouse.repo
yum repolist
yum install -y clickhouse-server-25.5.2.47-1 clickhouse-client-25.5.2.47-1
cd /etc/clickhouse-server/
total 104
dr-x------ 2 clickhouse clickhouse  4096 2025-06-11 10:45 config.d #在该目录下自定义配置，可覆盖config.xml中的配置
-r-------- 1 clickhouse clickhouse 88163 2025-06-03 00:46 config.xml #服务的主要配置，包含监听端口、路径设置、日志配置等核心参数，不建议修改此文件，而是在config.d/ 中自定义配置文件覆盖设置，如下面的cusom.xml
dr-x------ 2 clickhouse clickhouse  4096 2025-06-11 10:35 users.d  #在该目录下自定义配置，覆盖users.xml中的配置
-r-------- 1 clickhouse clickhouse  5724 2025-06-03 00:46 users.xml #定义用户、权限、配额和配置文件，包含用户密码、访问权限、内存限制等设置。同config.xml配置文件，不建议直接修改
cd config.d/
vim custom.xml
<yandex>
    <listen_host>0.0.0.0</listen_host>
</yandex>


systemctl start clickhouse-server.service
systemctl status clickhouse-server.service  #如果有报错，日志在/var/log/clickhouse-server/ 
systemctl enable clickhouse-server.service

netstat -tnlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    
tcp        0      0 0.0.0.0:9009            0.0.0.0:*               LISTEN      50748/clickhouse-se 
tcp        0      0 0.0.0.0:9004            0.0.0.0:*               LISTEN      50748/clickhouse-se 
tcp        0      0 0.0.0.0:9005            0.0.0.0:*               LISTEN      50748/clickhouse-se 
tcp        0      0 0.0.0.0:9000            0.0.0.0:*               LISTEN      50748/clickhouse-se 
tcp        0      0 0.0.0.0:8123            0.0.0.0:*               LISTEN      50748/clickhouse-se #web页面，可以通HTTP写访问

三、验证

[root@clickhouse01 clickhouse-server]# clickhouse-client -m #兼容大部分SQL语句 
clickhouse01 :) show databases;
   ┌─name───────────────┐
1. │ INFORMATION_SCHEMA │
2. │ default            │
3. │ information_schema │
4. │ system             │
   └────────────────────┘
clickhouse01 :) use system;
USE system
clickhouse01 :) show tables;

     ┌─name───────────────────────────┐
  1. │ aggregate_function_combinators │
  2. │ asynchronous_inserts           │
  3. │ asynchronous_loader            │
  ......
clickhouse01 :) exit;

参考文档：https://clickhouse.com/docs/zh/starter-guides