ClickHouse 安装部署
本文档为clickhouse学习笔记,安装部署作为学习一个数据库的第一步,将安装验证过程整理供大家参考
1. 环境检查
ClickHouse可以在任何具有x86_64,AArch64或PowerPC64LE CPU架构的Linux,FreeBSD或Mac OS X上运行。
官方预构建的二进制文件通常针对x86_64进行编译,并利用SSE 4.2指令集,因此,除非另有说明,支持它的CPU使用将成为额外的系统需求。下面是检查当前CPU是否支持SSE 4.2的命令:
[root@VM_0_6_centos ~]# grep -q sse4_2 /proc/cpuinfo && echo "SSE 4.2 supported" || echo "SSE 4.2 not supported" SSE 4.2 supported
要在不支持SSE 4.2或AArch64,PowerPC64LE架构的处理器上运行ClickHouse,您应该通过适当的配置调整从源代码构建ClickHouse。
请参考:从源代码构建ClickHouse
2. 部署安装
2.1 RPM 安装
推荐使用CentOS、RedHat和所有其他基于rpm的Linux发行版的官方预编译rpm包。
通过github下载官方最新stable版本rpm安装包:下载。
下载版本示例:

然后运行命令安装:
rpm -ivh clickhouse-common-static-21.2.5.5-2.x86_64.rpm
rpm -ivh clickhouse-common-static-dbg-21.2.5.5-2.x86_64.rpm
rpm -ivh clickhouse-server-21.2.5.5-2.noarch.rpm
rpm -ivh clickhouse-client-21.2.5.5-2.noarch.rpm
rpm -ivh clickhouse-test-21.2.5.5-2.noarch.rpm
## 启动
sudo clickhouse start
## 登录
clickhouse-client
2.2 Tgz安装包
存储库https://repo.clickhouse.tech/tgz/ 的版本更新较慢,建议通过github进行下载
下载地址:https://github.com/ClickHouse/ClickHouse/tags
二进制安装使用配置文件在clickhouse-server-21.2.5.5/etc/clickhouse-server目录下,users.xml和config.xml关于配置文件后续再学习后再详细整理。
下载后解压缩下载资源文件并使用安装脚本进行安装。以下是一个v21.2.5.5-stable的安装示例:
## 解压并且安装
tar -xzvf clickhouse-common-static-21.2.5.5.tgz
sudo clickhouse-common-static-21.2.5.5/install/doinst.sh
tar -xzvf clickhouse-common-static-dbg-21.2.5.5.tgz
sudo clickhouse-common-static-dbg-21.2.5.5/install/doinst.sh
tar -xzvf clickhouse-server-21.2.5.5.tgz
sudo clickhouse-server-21.2.5.5/install/doinst.sh
## sudo /etc/init.d/clickhouse-server start
## 启动
[root@VM_0_6_centos clickhouse]# clickhouse start
chown --recursive clickhouse '/var/run/clickhouse-server/'
Will run su -s /bin/sh 'clickhouse' -c '/usr/bin/clickhouse-server --config-file /etc/clickhouse-server/config.xml --pid-file /var/run/clickhouse-server/clickhouse-server.pid --daemon'
Waiting for server to start
Waiting for server to start
Server started
## 解压安装client
tar -xzvf clickhouse-client-21.2.5.5.tgz
sudo clickhouse-client-21.2.5.5/install/doinst.sh
对于生产环境,建议使用最新的stable版本。你可以在GitHub页面https://github.com/ClickHouse/ClickHouse/tags找到它,它以后缀-stable标志。
2.3 Docker安装
部署:
$ docker run -d --name clickhouse-262144 --ulimit nofile=262144:262144 -p 9000:9000 --volume=/clickhouse/clickhouse-262144:/var/lib/clickhouse yandex/clickhouse-server
## 本地未下载docker镜像
Unable to find image 'yandex/clickhouse-server:latest' locally
latest: Pulling from yandex/clickhouse-server
83ee3a23efb7: Pull complete
db98fc6f11f0: Pull complete
f611acd52c6c: Pull complete
de92c1af01f1: Pull complete
92602470923f: Pull complete
cb2326b425ee: Pull complete
1608898e4db5: Pull complete
4c93998f2279: Pull complete
ce30359f0a9c: Pull complete
dba7bbc30c2a: Pull complete
Digest: sha256:146bbcba67e399233e03307468247a8e05010aafb31a2f985aab4b8ea4251e60
Status: Downloaded newer image for yandex/clickhouse-server:latest
b48a09f0fb749b6ddbc63276f4a098e10e2ef0edd9afadb6a7583b8f118e0975
## 如果要将主机指定目录用于数据存储,请使用以下命令启动服务器:
$ mkdir $HOME/some_clickhouse_database
$ docker run -d --name clickhouse-262144 --ulimit nofile=262144:262144 --volume=$HOME/some_clickhouse_database:/var/lib/clickhouse yandex/clickhouse-server
$ docker run -it --rm --link clickhouse-262144:clickhouse-server yandex/clickhouse-client --host clickhouse-server




