169 字
1 分钟
安装ClickHouse
必要条件
- CPU:SSE4.2指令集的x86_64架构的CPU
- RAM:至少4GB
- SWAP:禁用交换分区
- 磁盘空间:至少2GB
安装
推荐使用CentOS、RedHat和所有其他基于rpm的Linux发行版的官方预编译rpm
包。
yum install -y yum-utils
yum-config-manager --add-repo https://packages.clickhouse.com/rpm/clickhouse.repo
# 查看可安装版本
yum list --showduplicates clickhouse-server
# 安装指定版本
export clickhouse_version=23.8.12.13
yum install -y clickhouse-server-${clickhouse_version} clickhouse-client-${clickhouse_version}
systemctl start clickhouse-server.service
systemctl enable clickhouse-server.service
clickhouse-client
配置
/etc/clickhouse-server/config.xml
开放ipv4访问
<listen_host>0.0.0.0</listen_host>
开放Prometheus指标监控
<prometheus> <endpoint>/metrics</endpoint> <port>9363</port> <metrics>true</metrics> <events>true</events> <asynchronous_metrics>true</asynchronous_metrics> <status_info>true</status_info> </prometheus>
修改时区
<timezone>Asia/Shanghai</timezone>
防止SQL查询敏感数据泄漏到日志
<query_masking_rules> <rule> <name>hide encrypt/decrypt arguments</name> <regexp>((?:aes_)?(?:encrypt|decrypt)(?:_mysql)?)\s*\(\s*(?:'(?:\\'|.)+'|.*?)\s*\)</regexp> <replace>\1(???)</replace> </rule> </query_masking_rules>
/etc/clickhouse-server/users.xml
设置
default
密码<password>123456</password>
创建新用户
<users> <user1> <password>12345678</password> <networks> <ip>::/0</ip> </networks> </user1> </users>