部署

1.安装

1. 更新系统依赖

   sudo apt update
   sudo apt install -y apt-transport-https ca-certificates dirmngr gnupg

2. 添加官方GPG-key (用于apt安装时校验包是不是clickhouse官网发的)

   sudo install -m 0755 -d /etc/apt/keyrings
   sudo mkdir -p /root/.gnupg
   sudo chmod 700 /root/.gnupg
   
   sudo gpg --no-default-keyring \
   --keyring /etc/apt/keyrings/clickhouse-keyring.gpg \
   --keyserver keyserver.ubuntu.com \
   --recv-keys 3A9EA1193A97B548BE1457D48919F6BD2B48D754

3. 往apt的软件源列表添加clickhouse官方仓库

   echo \
   "deb [signed-by=/etc/apt/keyrings/clickhouse-keyring.gpg] \
   https://packages.clickhouse.com/deb stable main" | \
   sudo tee /etc/apt/sources.list.d/clickhouse.list > /dev/null

4. 安装clickhouse

   sudo apt update
   sudo apt install -y clickhouse-server clickhouse-client   #会让设置密码

2.配置

1. 修改监听地址

   sudo chmod +w /etc/clickhouse-server/config.xml
   sudo vim /etc/clickhouse-server/config.xml
   <listen_host>0.0.0.0</listen_host>

2. 设置开机启动

   sudo systemctl enable clickhouse-server
   sudo systemctl start clickhouse-server

3. 常见目录

   cfg:/etc/clickhouse-server/ 主要文件:config.xml users.xml
   data:/var/lib/clickhouse/
   log:/var/log/clickhouse-server/

4. 修改用户/用户组限制上限 重新登录生效

   sudo vim /etc/security/limits.conf   #/etc/security/limits.d/文件夹里面有配置会覆盖生效
   * soft nofile 65536                  #打开文件上限
   * soft nproc  65535                  #打开进程上限
   * hard nofile 65535                  #硬限制
   * hard nproc  65535

3.账号密码

1. 查看账号

   SELECT name, storage FROM system.users;                      --storage账号的来源 users_xml:配置文件 local_directory:库

2. 修改default账号密码 账号来源配置文件

   echo -n 'cc123321.' | sha256sum                               //生成密码
   sudo vim /etc/clickhouse-server/users.d/default-password.xml  //修改密码
   <clickhouse>
    <users>
        <default>
            <password remove='1' />
            <password_sha256_hex>a2ab854b07188dae5483575f8fe0ad084aeca1adab3347b8291f61fd314220a5</password_sha256_hex>
        </default>
    </users>
   </clickhouse>

3. 创建账号 账号来源库

   CREATE USER svr IDENTIFIED WITH sha256_password BY 'cc123321.'               --创建账号
   GRANT SELECT, INSERT, ALTER, CREATE, DROP, SHOW, SYSTEM ON *.* TO svr        --给账号权限