检查系统是否支持SSE 4.2:
grep -q sse4_2 /proc/cpuinfo && echo "SSE 4.2 supported" || echo "SSE 4.2 not supported"
安装命令:
默认安装地址:/etc/clickhouse-server
# 使用脚本下载yum源
curl -s https://packagecloud.io/install/repositories/altinity/clickhouse/script.rpm.sh | sudo bash
# yum 安装 server 以及 client
sudo yum install -y clickhouse-server clickhouse-client
# 查看是否安装完成
sudo yum list installed 'clickhouse*'
# 启动server端clickhouse-server
sudo systemctl start clickhouse-server
# 停止server端clickhouse-server
sudo systemctl stop clickhouse-server
# 查看server端服务开启/关闭状态
sudo systemctl status clickhouse-server
# 重启服务
sudo systemctl restart clickhouse-server
# 进入client端clickhouse-client
clickhouse-client
配置文件:
config.xml #配置服务器信息
users.xml #配置用户信息
(1)SHA256加密
例如对密码123456
进行SHA256加密
# echo -n 123456 | openssl dgst -sha256
(stdin)= 8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92
客户端连接工具:
dbeaver
连接时候回报错,因为dbeaver 连接clickhouse端口是8123
而clickhouse 命令:clickhouse-client 连接的地址是:localhost:9000 端口
此时需要对config.xml
配置: <listen_host>::</listen_host>
卸载安装包:
# 卸载及删除安装文件(需root权限)
yum list installed | grep clickhouse
yum remove -y clickhouse-common-static
yum remove -y clickhouse-server-common
rm -rf /var/lib/clickhouse
rm -rf /etc/clickhouse-*
rm -rf /var/log/clickhouse-server
卸载报错时强制删除:
# 删除rpm包的时候不调用卸载脚本
sudo rpm -e clickhouse-server.x86_64 --noscripts