centos7 yum 安装 clickhouse

访问量:1783 创建时间:2021-12-31

检查系统是否支持

[root@aa ~]# grep -q sse4_2 /proc/cpuinfo && echo "SSE 4.2 supported" || echo "SSE 4.2 not supported"
SSE 4.2 supported

系统基本配置

[root@aa ~]# cat /etc/security/limits.conf
*           soft  core   unlimit
*           hard  core   unlimit
*           soft  fsize  unlimited
*           hard  fsize  unlimited
*           soft  data   unlimited
*           hard  data   unlimited
*           soft  nproc  65535
*           hard  nproc  63535
*           soft  stack  unlimited
*           hard  stack  unlimited
*           soft  nofile  409600
*           hard  nofile  409600

关闭防火墙与selinux,此过程省略，可以参考https://www.linuxsre.cn/wiki/linux/40

配置yum源

yum install yum-utils
rpm --import https://repo.clickhouse.com/CLICKHOUSE-KEY.GPG
yum-config-manager --add-repo https://repo.clickhouse.com/rpm/stable/x86_64

安装

yum install clickhouse-server clickhouse-client

修改数据存储目录(找个大磁盘，以免出现空间不足问题)

###查看数据目录
[root@aa ~]# grep -n path /etc/clickhouse-server/config.xml | grep -v '-' | grep var
361:    <path>/var/lib/clickhouse/</path>
364:    <tmp_path>/var/lib/clickhouse/tmp/</tmp_path>
378:    <user_files_path>/var/lib/clickhouse/user_files/</user_files_path>
478:            <path>/var/lib/clickhouse/access/</path>
1156:    <format_schema_path>/var/lib/clickhouse/format_schemas/</format_schema_path>

###移动老目录
[root@aa ~]# mkdir /hadoop/clickhouse
[root@aa ~]# mv /var/lib/clickhouse/*  /hadoop/clickhouse/
###修改配置文件，讲对应的目录改为你的磁盘空间较大的目录
[root@aa ~]# grep -n path /etc/clickhouse-server/config.xml | grep -v '-' | grep hadoop
361:    <path>/hadoop/clickhouse/</path>
364:    <tmp_path>/hadoop/clickhouse/tmp/</tmp_path>
378:    <user_files_path>/hadoop/clickhouse/user_files/</user_files_path>
478:            <path>/hadoop/clickhouse/access/</path>
1156:    <format_schema_path>/hadoop/clickhouse/format_schemas/</format_schema_path>
<listen_host>0.0.0.0</listen_host>
#####修改权限
[root@aa ~]# chown clickhouse.clickhouse -R /hadoop/clickhouse/

启动

[root@aa ~]# systemctl start clickhouse-server 
[root@aa ~]# systemctl status clickhouse-server 
● clickhouse-server.service - ClickHouse Server (analytic DBMS for big data)
   Loaded: loaded (/etc/systemd/system/clickhouse-server.service; enabled; vendor preset: disabled)
   Active: active (running) since Fri 2021-12-31 10:04:12 CST; 5s ago
###下面是其他启动命令，yum安装还是建议使用上面的systemctl 启动关闭
###clickhouse-server --config-file=/etc/clickhouse-server/config.xml
###/etc/init.d/clickhouse-server start

修改用户密码

[root@hdpprde03 ~]# vim /etc/clickhouse-server/users.xml
    <users>
        <default>
           <password>123456</password>
           ###其他内容省略

重启

<< 上一章节

登陆评论: 使用GITHUB登陆