ClikHouse安装部署-Centos7-摩杜云开发者社区

Centos7安装clickhouse

1.下载安装包

wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-test-18.12.14-1.el7.x86_64.rpm/download.rpm

wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-server-common-18.12.14-1.el7.x86_64.rpm/download.rpm

wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-server-18.12.14-1.el7.x86_64.rpm/download.rpm

wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-debuginfo-18.12.14-1.el7.x86_64.rpm/download.rpm

wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-common-static-18.12.14-1.el7.x86_64.rpm/download.rpm

wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-client-18.12.14-1.el7.x86_64.rpm/download.rpm

2.安装顺序

rpm -ivh clickhouse-server-common-18.12.14-1.el7.x86_64.rpm

root@localhost 7]# rpm -ivh clickhouse-common-static-18.14.13-1.el7.x86_64.rpm
错误：依赖检测失败：
libicudata.so.50()(64bit) 被 clickhouse-common-static-18.14.13-1.el7.x86_64 需要
libicui18n.so.50()(64bit) 被 clickhouse-common-static-18.14.13-1.el7.x86_64 需要
libicuuc.so.50()(64bit) 被 clickhouse-common-static-18.14.13-1.el7.x86_64 需要
[root@localhost 7]# yum search libicu-last-50.1.2-17.el6.remi.x86_64.rpm
上网查了一下，都什么玩意儿

安装不是目的目的是找到这个依赖到底是谁

[root@localhost 7]# yum search libicu
[root@localhost 7]# yum install libicu.x86_64
果然是它
---------------------
作者：周子青

rpm -ivh clickhouse-common-static-18.12.14-1.el7.x86_64.rpm

rpm -ivh clickhouse-server-18.12.14-1.el7.x86_64.rpm

rpm -ivh clickhouse-debuginfo-18.12.14-1.el7.x86_64.rpm

rpm -ivh clickhouse-test-18.12.14-1.el7.x86_64.rpm

rpm -ivh clickhouse-client-18.12.14-1.el7.x86_64.rpm

3.1服务起停

停止：
service clickhouse-server stop

启动：
service clickhouse-server start

用clickhouse-client连接本机clickhouse-server服务器：
clickhouse-client

用本机clickhouse-client连接远程clickhouse-server服务器：
clickhouse-client –host 192.168.3.54 –port 9000 –database default–user default –password “”

show databases;

3.2 参数配置

3.2.1 放开远程访问

vi /etc/clickhouse-server/config.xml

修改服务器的配置文件/etc/clickhouse-server/config.xml，第65行，放开注释即可，修改之后的内容如下：

ClikHouse安装部署-Centos7_下载安装

这里写图片描述

3.2.2 内存限制设置

vi /etc/clickhouse-server/users.xml

ClikHouse安装部署-Centos7_下载安装_02

这里写图片描述

3.2.3 设置数据目录

vi /etc/clickhouse-server/config.xml

ClikHouse安装部署-Centos7_下载安装_03