国内免费服务器地址_中国空间站设计在轨飞行多少年_百度最容易收录的网站_十大永久免费的软件下载

Clickhouse 安装部署说明手册

准备工作

操作系统

CentOS Linux release 7.5.1804

详细信息：

LSB Version: :core-4.1-amd64:core-4.1-noarch:cxx-4.1-amd64:cxx-4.1-noarch:desktop-4.1-amd64:desktop-4.1-noarch:languages-4.1-amd64:languages-4.1-noarch:printing-4.1-amd64:printing-4.1-noarch

Distributor ID: CentOS

Description: CentOS Linux release 7.5.1804 (Core)

Release: 7.5.1804

Codename: Core

软件

clickhouse-server-common-1.1.54236-4.el7.x86_64.rpm

clickhouse-compressor-1.1.54236-4.el7.x86_64.rpm

clickhouse-debuginfo-1.1.54236-4.el7.x86_64.rpm

clickhouse-server-1.1.54236-4.el7.x86_64.rpm

clickhouse-client-1.1.54236-4.el7.x86_64.rpm

集群架构

可以看出来3个节点每个节点的tcp 9000对外提供服务，9001提供副本，其中2提供1的备份，3提供2的备份，1提供3的备份，这样假设挂掉1个节点，集群也可以正常使用，但是挂掉2个几点，就不正常了，这样的话是机器越多越稳定一些。

Clickhouse 安装

安装工作

1. 安装依赖包

yum install libltdl* libodbc* unixODBC*

1. 创建目录

mkdir -p /data/ck/{clickhouse,logs,tmp,task_queue} mkdir –p /usr/ck

3）上传安装介质

上传安装包 clickhouse-server-common-1.1.54236-4.el7.x86_64.rpm

clickhouse-compressor-1.1.54236-4.el7.x86_64.rpm

clickhouse-debuginfo-1.1.54236-4.el7.x86_64.rpm

clickhouse-server-1.1.54236-4.el7.x86_64.rpm

clickhouse-client-1.1.54236-4.el7.x86_64.rpm

上传到/usr/ck目录下

1. 安装

rpm -ivh clickhouse-server-common-1.1.54236-4.el7.x86_64.rpm rpm -ivh clickhouse-compressor-1.1.54236-4.el7.x86_64.rpm rpm -ivh clickhouse-debuginfo-1.1.54236-4.el7.x86_64.rpm rpm -ivh clickhouse-server-1.1.54236-4.el7.x86_64.rpm rpm -ivh clickhouse-client-1.1.54236-4.el7.x86_64.rpm

配置文件

1. vim /etc/metrika.xml

house_remote_servers> ftest_3shards_1replicas> hard> internal_replication>trueternal_replication> replica> hadoop-master 9008 shard> hard> replica> trueinternal_replication> hadoop-slave01 9008 shard> hard> internal_replication>trueternal_replication> replica> hadoop-slave02 9008 shard> rftest_3shards_1replicas> khouse_remote_servers> eper-servers> e index="1"> ost>hadoop-master ort>2181 e index="2"> ost>hadoop-slave01 ort>2181 e index="3"> ost>hadoop-slave02 ort>2181 eeper-servers> s> lica>hadoop-master os> rks> ::/0 orks> house_compression> e> in_part_size>10000000000part_size> in_part_size_ratio>0.01art_size_ratio> ethod>lz4 khouse_compression> >

2）进入/etc/clickhouse-server：vi config.xml

:: ::1> 127.0.0.1n_host>

Vi users.xml

e="replace"> ::1 127.0.0.1 readonly default readonly>

小结

安装过程中问题：

1）权限问题

2）免密登录配置