需要下载三个包clickhouse-client-24.9.2.42-arm64.tgz 提供客户端clickhouse-server-24.9.2.42-amd64.tgz 提供配置文件clickhouse-common-static-24.9.2.42-amd64.tgz 提供程序资源下载地址我设置的是0积分https://download.csdn.net/download/weixin_41809435/93080194?spm1001.2014.3001.5501创建基本目录mkdir -p /opt/clickhouse/{app,data,bin,logs,config,scripts}使用一下命令查看自己服务器是什么版本的适合使用什么类型的压缩包[rootlocalhost system]# uname -mx86_64解压[rootlocalhost clickhouse]# tar -zxvf clickhouse-client-xxxx说明是X86的系统需要下载amd压缩包执行以下命令 正常执行说明能用file clickhouse-common-static-24.9.2.42-amd64.tgz把解压包中他们三个对应的bin目录下的执行文件 复制一份 到我们自己的bin目录下cp clickhouse-common-static-24.9.2.42/usr/bin/clickhouse /opt/clickhouse/bin/创建软连接也就类似于windows中的配置环境变量到path中一样最后可以直接使用命令clickhouseln -s /opt/clickhouse/bin/clickhouse /usr/bin/clickhouse服务层配置文件复制cp -r clickhouse-server-24.9.2.42/etc/clickhouse-server/* /opt/clickhouse/config/配置一个用户groupadd clickhouseuseradd -g clickhouse clickhouse并授权目录chown -R clickhouse:clickhouse /opt/clickhousechmod -R 755 /opt/clickhouse修改配置文件vi /opt/clickhouse/config/config.xml找到path/var/lib/clickhouse//path内容修改为path/opt/clickhouse/data//path按照类似的操作修改配置文件总结所有关于 /var/lib/clickhouse的目录都改成自己定义的/opt/clickhouse比如一下这些但是最好是自己一个个搜索自己去一个个修改tmp_path/var/lib/clickhouse/tmp//tmp_path 改为tmp_path/opt/clickhouse/tmp//tmp_pathuser_files_path/var/lib/clickhouse/user_files//user_files_path 改为后面会新建这个目录user_files_path/opt/clickhouse/data/user_files//user_files_pathlog/var/log/clickhouse-server/clickhouse-server.log/log 改为log/opt/clickhouse/logs/clickhouse-server.log/logerrorlog/var/log/clickhouse-server/clickhouse-server.err.log/errorlog 改为errorlog/opt/clickhouse/logs/clickhouse-server.err.log/errorloglisten_host::1/listen_hostlisten_host127.0.0.1/listen_host 这俩改为一个listen_host0.0.0.0/listen_hostusers.xmlpassword/password 改为自己想要的密码password123456/password这个有可能本来就是需要的值不需要改看版本networksip::1/ipip127.0.0.1/ip/networks改为networksip::/0/ip/networks新建刚配置的文件mkdir -p /opt/clickhouse/data/user_files放开防火墙并重载firewall-cmd --permanent --add-port8123/tcpfirewall-cmd --permanent --add-port9000/tcpfirewall-cmd --reload创建systemd服务文件内容vi /etc/systemd/system/clickhouse.service内容如下[Unit]DescriptionClickHouse ServerAfternetwork.target[Service]TypesimpleUserclickhouseGroupclickhouseExecStart/opt/clickhouse/bin/clickhouse server \--config-file/opt/clickhouse/config/config.xmlRestartalwaysRestartSec5LimitNOFILE500000[Install]WantedBymulti-user.target重新加载systemdsystemctl daemon-reload设置为开机启动systemctl enable clickhouse启动systemctl start clickhouse查看状态systemctl status clickhouse用DBeaver连接xxx.xxx.xxx.xxx 你自己虚拟机的IP8123default123456
