CLICKHOUSE
1, CK概述
列式存储数据库;
适用场景:BI 领域,主要用于OLAP,数据分析类
不适用场景: 不适合OLTP方面,因为其不支持事物;不擅长按行删除的场景;
特点:
1, 支持完备的DBMS功能
2, 列式存储,支持压缩; 压缩率可以达到8:1;重复率越多,压缩率越高;
3, 向量化索引
4, 使用关系模型描述数据,并提供传统的库,表,视图,函数概念;
5, 多样化表引擎;
6, 多线程与分布式;
7, 多主架构
2, 安装
1, 安装前准备:
系统:
centos 7以上
3台机器;
a, centos取消打开文件数限制
/etc/security/limits.conf , /etc/security/limits.d/90-nproc.conf 末尾加入内容:
* soft nofile 65536
* hard nofile 65536
* soft nproc 131072
* hard nproc 131072
重启机器生效;
b, Centos 取消SELINUX
修改/etc/selinux/config中 SELINUX=disable
c, 关闭防火墙
service iptables stop
service ip6tables stop
d, 安装依赖包
yum install -y libtool
yum install -y *unixODBC*
2, 下载https://clickhouse.tech/
wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-server-common-20.5.4.40-1.el7.x86_64.rpm/download.rpm
wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-server-20.5.4.40-1.el7.x86_64.rpm/download.rpm
wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-client-20.5.4.40-1.el7.x86_64.rpm/download.rpm
wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-common-static-20.5.4.40-1.el7.x86_64.rpm/download.rpm
或者访问web,下载想要的版本; https://packagecloud.io/Altinity/clickhouse/
3, 单机安装:
rpm -ivh click*
[root@ab334aff-57da-4683-928c-556bb62658f9 clickhouse]# ll
总用量 90452
-rw-r--r-- 1 root root 6376 8月 12 18:23 clickhouse-client-20.5.4.40-1.el7.x86_64.rpm
-rw-r--r-- 1 root root 57490408 8月 12 18:23 clickhouse-common-static-20.5.4.40-1.el7.x86_64.rpm
-rw-r--r-- 1 root root 35102796 8月 12 18:23 clickhouse-server-20.5.4.40-1.el7.x86_64.rpm
-rw-r--r-- 1 root root 12988 8月 12 18:23 clickhouse-server-common-20.5.4.40-1.el7.x86_64.rpm
[root@ab334aff-57da-4683-928c-556bb62658f9 clickhouse]# rpm -ivh clickhouse-*
准备中... ################################# [100%]
正在升级/安装...
1:clickhouse-server-common-20.5.4.4################################# [ 25%]
2:clickhouse-common-static-20.5.4.4################################# [ 50%]
3:clickhouse-server-20.5.4.40-1.el7################################# [ 75%]
Create user clickhouse.clickhouse with datadir /var/lib/clickhouse
4:clickhouse-client-20.5.4.40-1.el7################################# [100%]
Create user clickhouse.clickhouse with datadir /var/lib/clickhouse
[root@ab334aff-57da-4683-928c-556bb62658f9 clickhouse]#
4, 启动/停止/重启
clickhouse的启动命令:service clickhouse-server start/stop/restart
5, 登陆
[root@ab334aff-57da-4683-928c-556bb62658f9 ~]# clickhouse-client
ClickHouse client version 20.5.4.40.
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 20.5.4 revision 54435.
ab334aff-57da-4683-928c-556bb62658f9 :) show databases;
SHOW DATABASES
┌─name───────────────────────────┐
│ _temporary_and_external_tables │
│ default │
│ system │
└────────────────────────────────┘
3 rows in set. Elapsed: 0.002 sec.