ClickHouse安装部署 外网访问，性能测试

CLICKHOUSE安装部署使用

修改仓库源

yum -y install wget
cd /etc/yum.repos.d
mv -f ./CentOS-Base.repo ./CentOS-Base.repo.bak
wget http://mirrors.163.com/.help/CentOS7-Base-163.repo
mv -f CentOS7-Base-163.repo /etc/yum.repos.d/CentOS-Base.repo
yum clean all;yum makecache

安装

sudo yum install -y yum-utils
sudo rpm --import https://repo.clickhouse.tech/CLICKHOUSE-KEY.GPG
sudo yum-config-manager --add-repo https://repo.clickhouse.tech/rpm/stable/x86_64
sudo yum install -y clickhouse-server clickhouse-client

 修改配置文件

vi /etc/clickhouse-server/config.xml
把<listen_host>0.0.0.0</listen_host>注释去掉

修改文件权限

chown -R clickhouse:clickhouse /var/lib/clickhouse
chown -R clickhouse:clickhouse /var/log/clickhouse-server

启动服务端

sudo -u clickhouse clickhouse-server --config-file=/etc/clickhouse-server/config.xml