ClickHouse初级 - 第二章ClickHouse 的安装

川长思鸟来 2024-02-05 15:07 40阅读 0赞

#### 文章目录 ####

*   *  一、准备工作
     *   *  1.1 确定防火墙处于关闭状态
         *  1.2 CentOS取消打开文件数限制
         *  1.3 安装依赖
         *  1.4 CentOS取消SELINUX
     *  二、单机安装

### 一、准备工作 ###

#### 1.1 确定防火墙处于关闭状态 ####

#### 1.2 CentOS取消打开文件数限制 ####

> 1）在hadoop102的 /etc/security/limits.conf 文件的末尾加入以下内容  
> ![请添加图片描述][8c4ad6ab2a7d42209ad680ebf03f5bab.png]  
> 2）在 hadoop102 的/etc/security/limits.d/20-nproc.conf 文件的末尾加入以下内容  
> ![请添加图片描述][142816905f444fb6866987d211e0c820.png]  
> 3）执行同步操作（此次是单机安装，便于后续集群安装，所以将三台服务器的配置都同步一下）  
> ![请添加图片描述][fc4e5e1b6d2d440094ee5859d2a3af49.png]  
> ![请添加图片描述][cf80c23f6a38491f98397680d463ceb8.png]

#### 1.3 安装依赖 ####

> \[atguigu@hadoop102 ~\]$ sudo yum install -y libtool  
> ![请添加图片描述][e8a60f2ee58d421086cf10db05d949ce.png]  
> \[atguigu@hadoop102 ~\]$ sudo yum install -y *unixODBC*  
> ![请添加图片描述][e291f4131ed449f5a16fcf120026b065.png]  
> ps:在hadoop103、hadoop104上执行以上操作

#### 1.4 CentOS取消SELINUX ####

> (1)修改/etc/selinux/config 中的SELINUX=disabled  
> ![请添加图片描述][56f67486652e43baa9a5c0bf3c4b0f47.png]  
> (2)执行同步操作  
> ![请添加图片描述][4fa6499a26334d49886a5d62b62828b0.png]  
> (3)重启三台服务器

### 二、单机安装 ###

> 官网:https://clickhouse.tech/  
> 下载地址:http://repo.red-soft.biz/repos/clickhouse/stable/el7/

2.1 在 hadoop102 的/opt/software 下创建 clickhouse 目录

> \[atguigu@hadoop102 software\]$ mkdir clickhouse![请添加图片描述][caf096dbfb0a45af832043ef34a2e3b7.png]

2.2 将/2.资料/ClickHouse 下 4 个文件上传到 hadoop102 的 software/clickhouse 目录下  
![请添加图片描述][e6373897f7d24bcaa1ad2d0637ddfafd.png]

2.3 将安装文件同步到 hadoop103、hadoop104

> \[atguigu@hadoop102 software\]$ xsync clickhouse

2.4 分别在三台机子上安装这 4 个 rpm 文件

> \[atguigu@hadoop102 clickhouse\]$ sudo rpm -ivh \*.rpm  
> ![请添加图片描述][6728975ff53747ba992c9cb7a1cc749d.png]  
> sudo rpm -qa|grep clickhouse 查看安装情况

2.5 修改配置文件

> \[atguigu@hadoop102 clickhouse\]$ sudo vim /etc/clickhouse-server/config.xml  
> ![请添加图片描述][38f8f5ea83f6438aa6fa0b8e624280bd.png]

2.6 启动Server

> \[atguigu@hadoop102 clickhouse\]$ sudo systemctl start clickhouse-server  
> ![请添加图片描述][300a9f0bedb54860aff996308bd41e21.png]

2.7 三台机器上关闭开机自启

> \[atguigu@hadoop102 clickhouse\]$sudo systemctl disable clickhouse-server

2.8 使用 client 连接 server

> \[atguigu@hadoop102 clickhouse\]$ clickhouse-client -m  
> ![请添加图片描述][effe714286694738a76bb2b4d06de816.png]  
> \-m :可以在命令窗口输入多行命令

**ps：便于操作，所以基于docker来搭建clickhouse的环境**

[8c4ad6ab2a7d42209ad680ebf03f5bab.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/acd974b23d1643a5a9a244036825197f.png
[142816905f444fb6866987d211e0c820.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/447ab13b61b54f8598bf4d417cc19c28.png
[fc4e5e1b6d2d440094ee5859d2a3af49.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/03d375a4bc4449109cc49981bb03f256.png
[cf80c23f6a38491f98397680d463ceb8.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/7ac076a3efa54298bffbc6bff1fd1a80.png
[e8a60f2ee58d421086cf10db05d949ce.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/351a274620b3400ebfe92e13b966a22c.png
[e291f4131ed449f5a16fcf120026b065.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/3586480ac7114c178128e70698eebed3.png
[56f67486652e43baa9a5c0bf3c4b0f47.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/58ea177ebac0486bb603dd444b4f8b04.png
[4fa6499a26334d49886a5d62b62828b0.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/84c4bd82889c40ef855fe460f8799c00.png
[caf096dbfb0a45af832043ef34a2e3b7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/101bdef710b8478b95d321f078d16375.png
[e6373897f7d24bcaa1ad2d0637ddfafd.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/ba5f021172c843ffaa0f30ab4425abe8.png
[6728975ff53747ba992c9cb7a1cc749d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/19b4cbf1c7fb4127a95b556ab12dd048.png
[38f8f5ea83f6438aa6fa0b8e624280bd.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/03e09694106448719e74d73c488e6758.png
[300a9f0bedb54860aff996308bd41e21.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/b8f1bd99520e46e5b22affc097a53232.png
[effe714286694738a76bb2b4d06de816.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/fa40c8b78f784a8f81b74a2dca5bc34a.png