超详细线上安装clickhouse教程

ck安装

检查系统是否支持SSE 4.2：

grep -q sse4_2 /proc/cpuinfo && echo "SSE 4.2 supported" || echo "SSE 4.2 not supported"

1. 使用脚本下载yum源

curl -s https://packagecloud.io/install/repositories/altinity/clickhouse/script.rpm.sh | sudo bash

2. yum 安装 server 以及 client

sudo yum install -y clickhouse-server clickhouse-client

提示无可用包

//安装epel源
sudo yum install epel-release或者yum install -y epel-release
//更新
yum update -y

还不行就换源，替换掉sources.lis

vim /etc/apt/sources.list或者sudo gedit /etc/apt/sources.list

deb http://mirrors.aliyun.com/ubuntu/ bionic main restricted universe multiverse
deb http://mirrors.aliyun.com/ubuntu/ bionic-security main restricted universe multiverse
deb http://mirrors.aliyun.com/ubuntu/ bionic-updates main restricted universe multiverse
deb http://mirrors.aliyun.com/ubuntu/ bionic-proposed main restricted universe multiverse
deb http://mirrors.aliyun.com/ubuntu/ bionic-backports main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ bionic main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ bionic-security main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ bionic-updates main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ bionic-proposed main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ bionic-backports main restricted universe multiverse

提示yum repolist all就运行

vim /etc/sysconfig/network-scripts/ifcfg-ens33
修改

DNS1=8.8.8.8
DNS2=223.5.5.5

再运行

wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo或者curl -o /etc/yum.repos.d/CentOS-Base.repo

1.清除旧缓存

yum clean all

2.创建新缓存

yum makecache

3.更新yum

yum update -y

最后运行

1.yum-config-manager --add-repo https://repo.clickhouse.tech/rpm/stable/x86_64
2.yum install clickhouse-server clickhouse-client即可

3. 查看安装是否完成

sudo yum list installed 'clickhouse*

4. 启动server端clickhouse-server

systemctl start clickhouse-server

查看server端服务开启/关闭状态

systemctl status clickhouse-server

停止server端clickhouse-server

sudo systemctl stop clickhouse-server

外部http://ui.tabix.io/#!/login连接不到ck

config.xml #配置服务器信息
users.xml #配置用户信息

1.开放防火墙

firewall-cmd --add-port=8123/tcp --permanent --zone=public
firewall-cmd --reload
firewall-cmd --add-port=9000/tcp --permanent --zone=public
firewall-cmd --reloadconfig.xml  #配置服务器信息

2.开放config.xml文件的<listen_host>::</listen_host>