【Linux合集】clickhouse单机部署

clickhouse单机部署
1、前言

之前由于设置安装clickhouse默认安装最新版本发现每次时隔两天都会因为打满内存导致clickhouse崩溃，
先由于观察发现24版本稳定，现将版本定格在24.2.1.2248版本

2、安装clickhouse

sudo yum install -y yum-utils
sudo yum-config-manager --add-repo https://packages.clickhouse.com/rpm/clickhouse.repo
sudo yum clean all
sudo yum makecache -y
sudo yum install -y clickhouse-server clickhouse-client
sudo yum install clickhouse-server-24.2.1.2248 clickhouse-client-24.2.1.2248

3、配置项修改

## config文件修改
sudo cp /etc/clickhouse-server/config.xml /etc/clickhouse-server/config.xml.back
sudo chmod 600 /etc/clickhouse-server/config.xml
sudo vi /etc/clickhouse-server/config.xml
# 添加远程访问
<listen_host>0.0.0.0</listen_host>    #注释取消掉
数据存储目录
<path>/data/applications/clickhouse/</path>
<tmp_path>/data/applications/clickhouse/tmp/</tmp_path>
​
## users文件修改
sudo mkdir -pv /data/applications/clickhouse/tmp
sudo chown clickhouse.clickhouse -R /data/applications/clickhouse/
sudo chmod 600 /etc/clickhouse-server/users.xml
# 设置密码： 
sudo vi /etc/clickhouse-server/users.xml
<password>defaultpass</password>

4、测试连接
二进制部署测试连接：
clickhouse-client -h 127.0.0.1 --port 9000 -u test_user --password test_password