1、clickhouse 安装
ClickHouse1 版本安装包clickhouse-client-24.9.3.128.x86_64.rpmclickhouse-common-static-24.9.3.128.x86_64.rpmclickhouse-common-static-dbg-24.9.3.128.x86_64.rpmclickhouse-server-24.9.3.128.x86_64.rpm下载地址https://mirrors.aliyun.com/clickhouse/rpm/stable/clickhouse-client-24.9.3.128.x86_64.rpmhttps://mirrors.aliyun.com/clickhouse/rpm/stable/clickhouse-common-static-24.9.3.128.x86_64.rpmhttps://mirrors.aliyun.com/clickhouse/rpm/stable/clickhouse-common-static-dbg-24.9.3.128.x86_64.rpmhttps://mirrors.aliyun.com/clickhouse/rpm/stable/clickhouse-server-24.9.3.128.x86_64.rpm2 安装1.下载clickhouse相关安装包放到/app/clickhouse下2.执行命令安装cd/app/clickhouse# 安装过程需要输入 default 用户的密码直接输入 ClickhouseBoyi365rpm-ivhclickhouse-*.rpm3 配置ClickHouse 中的配置项很多默认会在/etc下生成clickhouse-server和clickhouse-client两个目录我们需要去修改clickhouse-server下的配置文件/etc/clickhouse-server/config.xmllogger修改日志的存放路径默认为/var/log/clickhouse-server/clickhouse-server.loghttp_port修改浏览器访问的端口默认为8123tcp_port修改 tcp 协议的传输端口默认为9000改成9900listen_host如果我们要对外使用服务的话此处需要修改成0.0.0.0openSSL一些 ssl 的认证配置文件暂时不做 ssl 认证暂时不做处理4 启动sudo-uclickhouse clickhouse-server--daemon--config-file/etc/clickhouse-server/config.xml5 调试[rootproduct-test-server clickhouse]# clickhouse-client -h 192.168.20.96 --port 9900ClickHouse client version24.9.3.128(official build). Connecting to192.168.20.96:9900 as user default. Passwordforuser(default): Connecting to192.168.20.96:9900 as user default. Connected to ClickHouse server version24.9.3. Warnings: * Linux transparent hugepages aresettoalways.Check /sys/kernel/mm/transparent_hugepage/enabled product-test-server:)