rpm -ivh clickhouse-server-common-19.4.0-2.noarch.rpmrpm -ivh clickhouse-common-static-19.4.0-2.x86_64.rpmrpm -ivh clickhouse-server-19.4.0-2.noarch.rpmrpm -ivh clickhouse-client-19.4.0-2.noarch.rpm
如果有冲突:
rpm -ivh —replacefiles clickhouse-server-common-19.4.0-2.noarch.rpm
rpm -ivh —replacefiles clickhouse-common-static-19.4.0-2.x86_64.rpm
rpm -ivh —replacefiles clickhouse-server-19.4.0-2.noarch.rpm
rpm -ivh —replacefiles clickhouse-client-19.4.0-2.noarch.rpm
mkdir /home/clickhouse-19.4.0.2
mkdir /home/clickhouse-19.4.0.2/data
mkdir /home/clickhouse-19.4.0.2/tmp
mkdir /home/clickhouse-19.4.0.2/log
配置:
vim /etc/clickhouse-server/config.xml
修改:
修改为:
修改为:
修改为:
修改为:
修改为(防止与hdfs的默认端口冲突):
放开注释,开启监听其它主机。
修改脚本:
vim /etc/init.d/clickhouse-server
修改:
CLICKHOUSE_USER=root
修改系统服务配置:
vim /etc/systemd/system/clickhouse-server.service
修改:
User=root
Group=root
scp config.xml 10.10.195.54:/etc/clickhouse-server/
scp config.xml 10.10.195.55:/etc/clickhouse-server/
scp config.xml 10.10.195.56:/etc/clickhouse-server/
复制缺少的文件:
cp /etc/rc.d/init.d/functions /etc/init.d/
mkdir /var/log/clickhouse-server
启动:
systemctl daemon-reload
systemctl start clickhouse-server.service
service clickhouse-server start
service clickhouse-server status
service clickhouse-server condstop
service clickhouse-server restart
测试:
clickhouse-client -m -h 10.10.195.53 —port 19000
clickhouse-client -m -h 10.10.195.54 —port 19000
clickhouse-client -m -h 10.10.195.55 —port 19000
clickhouse-client -m -h 10.10.195.56 —port 19000
20版本,需要修改/var/lib/clickhouse/user_files路径
mkdir /home/clickhouse-20.1.6.30/user_files
mkdir /home/clickhouse-20.1.6.30/format_schemas
vim /etc/clickhouse-server/config.xml
/var/lib/clickhouse/user_files/
替换成:
/home/clickhouse-20.1.6.30/user_files/
/var/lib/clickhouse/format_schemas/
替换成:
/home/clickhouse-20.1.6.30/format_schemas/
clickhouse-client -m -h 10.10.195.126 —port 19000
clickhouse-client -m -h 10.10.195.127 —port 19000
clickhouse-client -m -h 10.10.195.128 —port 19000
clickhouse-client -m -h 10.10.195.129 —port 19000
