ClikHouse安装部署-Centos7

偏执的太偏执、 2022-03-02 12:17 405阅读 0赞

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  
果然是它  
\---------------------   
作者：周子青   
来源：CSDN   
原文：https://blog.csdn.net/qq\_37674858/article/details/88688730   
版权声明：本文为博主原创文章，转载请附上博文链接！

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行，放开注释即可，修改之后的内容如下：   
 ![20190403111305676.png][]  
这里写图片描述   
3.2.2 内存限制设置   
vi /etc/clickhouse-server/users.xml

![201904031113219.png][]

这里写图片描述   
3.2.3 设置数据目录   
vi /etc/clickhouse-server/config.xml   
 ![20190403111331111.png][]

[20190403111305676.png]: /images/20220302/2aeb680521214ced889c609161110349.png
[201904031113219.png]: /images/20220302/77e4c8ebeded49f29c559e26f0b03e44.png
[20190403111331111.png]: /images/20220302/38fe9f6c29b44d8ab6ec3b3c66b6ea85.png