当前位置： 首页 >> ClickHouse >> 单机部署

---

单机部署

2020-10-07 15:17:48 星期三  阅读：1815

---

####单机部署方式 >源码包自己编译部署 预编译部署 Docker镜像部署 RPM包部署 完整的安装方法见官方文档，写的非常详细：https://clickhouse.tech/docs/en/getting-started/install/ ###单机部署流程 如果是Linux操作系统，推荐使用tar.gz包安装 （官网原话：*It is recommended to use official pre-compiled tgz archives for all Linux distributions*） ####环境准备 操作系统：CentOS7.8 ClickHouse版本(截止当前的最新稳定版)：20.3.10.75 验证服务器的CPU是否支持SSE4.2指令集 ``` grep -q sse4_2 /proc/cpuinfo && echo "SSE 4.2 supported" || echo "SSE 4.2 not supported" # 输出结果 SSE 4.2 supported ``` 关闭防火墙 ``` systemctl status firewalld.service # Active: inactive (dead) # 永久关闭（禁止开机自启） systemctl disable firewalld.service ``` ####下载安装包 官网下载链接(最新稳定版本)https://repo.clickhouse.tech/tgz/stable/ 官网下载很慢，可到我的百度云下载【链接: https://pan.baidu.com/s/1r74hT-KaaHjc0zTxrKvnGQ 密码: n2o2】 下载命令(总共需要下载4个包) ``` cd /tmp wget https://repo.clickhouse.tech/tgz/stable/clickhouse-common-static-20.3.10.75.tgz wget https://repo.clickhouse.tech/tgz/stable/clickhouse-common-static-dbg-20.3.10.75.tgz wget https://repo.clickhouse.tech/tgz/stable/clickhouse-server-20.3.10.75.tgz wget https://repo.clickhouse.tech/tgz/stable/clickhouse-client-20.3.10.75.tgz ``` 创建安装目录、数据和日志存储目录 ``` mkdir -p /opt/service/clickhouse/ mkdir -p /data/clickhouse/data mkdir -p /data/clickhouse/tmp mkdir -p /data/clickhouse/server-logs mkdir -p /data/clickhouse/client-logs ``` ####配置环境变量 ``` vim /etc/profile # 添加如下内容 # CLICKHOUSE export CH_HOME=/opt/service/clickhouse source /etc/profile ``` 解压到安装路径并改名 ``` cd $CH_HOME tar -xzvf /tmp/clickhouse-common-static-20.3.10.75.tgz -C . mv clickhouse-common-static-20.3.10.75 common-static $CH_HOME/common-static/install/doinst.sh tar -xzvf /tmp/clickhouse-common-static-dbg-20.3.10.75.tgz -C /opt/service/clickhouse/ mv clickhouse-common-static-dbg-20.3.10.75 common-static-dbg $CH_HOME/common-static-dbg/install/doinst.sh tar -xzvf /tmp/clickhouse-server-20.3.10.75.tgz -C /opt/service/clickhouse/ mv clickhouse-server-20.3.10.75 server $CH_HOME/server/install/doinst.sh tar -xzvf /tmp/clickhouse-client-20.3.10.75.tgz -C /opt/service/clickhouse/ mv clickhouse-client-20.3.10.75 client $CH_HOME/client/install/doinst.sh ``` ####修改配置文件 修改配置文件指定数据和日志存储目录为上面创建的（不修改也可以，但是要保证默认配置的目录空间下有足够的磁盘空间） ``` cd $CH_HOME/server/etc/clickhouse-server vim config.xml 分别修改log、errorlog、path标签的值 <log>/data/clickhouse/server-logs/clickhouse-server.log</log> <errorlog>/data/clickhouse/server-logs/clickhouse-server.err.log</errorlog> <path>/data/clickhouse/data</path> <tmp_path>/data/clickhouse/tmp</tmp_path> ``` ####启动server ``` $CH_HOME/server/install/doinst.sh $CH_HOME/server/etc/init.d/clickhouse-server start Start clickhouse-server service: Path to data directory in /etc/clickhouse-server/config.xml: /data/clickhouse/data DONE ``` 看到DONE即为启动成功 ####验证端口是否启动 ``` # TCP监听端口 lsof -i:9000 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME clickhous 7063 clickhouse 30u IPv6 215249 0t0 TCP localhost:cslistener (LISTEN) clickhous 7063 clickhouse 34u IPv4 215253 0t0 TCP localhost:cslistener (LISTEN) # HTTP监听端口 lsof -i:8123 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME clickhous 7063 clickhouse 29u IPv6 215248 0t0 TCP localhost:8123 (LISTEN) clickhous 7063 clickhouse 33u IPv4 215252 0t0 TCP localhost:8123 (LISTEN) ``` ####启动命令行客户端 ```mysql clickhouse-client ClickHouse client version 20.3.10.75 (official build). Connecting to localhost:9000 as user default. Connected to ClickHouse server version 20.3.10 revision 54433. libins.cn :) show databases; SHOW DATABASES ┌─name────┐ │ default │ │ system │ └─────────┘ 2 rows in set. Elapsed: 0.003 sec. ``` 能看到两个系统DB即为部署成功