Sign inSign up

hylink/clickhouse

By hylink

Updated 8 months ago

Image
0

909

hylink/clickhouse repository overview

clickhouse 定制镜像

features

  • 修改默认连接数 10240
  • 开启控制台日志打印
  • 内存使用量限制: 0.9
  • 内置四种角色账户:
    • hlk_admin(超级管理员)
    • hlk_dba(DBA)
    • hlk_data(数据开发)
    • hlk_readonly(只读账号)

如何使用

使用镜像 hylink/clickhouse:v1.0.0-23.3.8.21
  • http 端口: 8123
  • tcp 端口: 9000
  • mysql 协议端口: 9004
  • postgresql 协议端口: 9005
设置必要的环境变量: ADMIN_PASSWORD (管理员账号, 兼容原有参数 CLICKHOUSE_PASSWORD)**
DBA_PASSWORD      hlk_dba  密码      (可选, 为空则继承 ADMIN_PASSWORD)
DATA_PASSWORD     hlk_data 密码      (可选, 为空则继承 DBA_PASSWORD)
READONLY_PASSWORD hlk_readonly 密码  (可选, 为空则继承 DATA_PASSWORD)
保存日志

挂载路径: /var/log/clickhouse-server 至宿主机即可

如何修改默认的四种角色账号名称

设置下面四种环境变量即可

CUSTOM_ADMIN_USER_NAME    "hlk_admin"
CUSTOM_DBA_USER_NAME      "hlk_dba"
CUSTOM_DATA_USER_NAME     "hlk_data"
CUSTOM_READONLY_USER_NAME "hlk_readonly"
docker-compose 示例
# Use root/example as user/password credentials
version: '3.1'
services:
  clickhouse:
    container_name: clickhouse
    image: hylink/clickhouse:v1.0.0-23.3.8.21
    restart: unless-stopped
    cap_add:
    - SYS_NICE
    - NET_ADMIN
    - IPC_LOCK
    ports:
      - "9000:9000"
      - "8123:8123"
    environment:
      - CLICKHOUSE_DB=hylink
      # ADMIN_PASSWORD 为管理员账号, 兼容原有参数 CLICKHOUSE_PASSWORD
      - ADMIN_PASSWORD=admin
      - DBA_PASSWORD=admin1
      - DATA_PASSWORD=admin2
      - READONLY_PASSWORD=admin3
    ulimits:
      nofile:
        soft: 262144
        hard: 262144
    #volumes:
      # 数据库文件
      #- ./var/lib/clickhouse/:/var/lib/clickhouse/
      # 日志文件
      #- ./var/log/clickhouse-server/:/var/log/clickhouse-server/

Tag summary

Content type

Image

Digest

sha256:3be0385f3

Size

165.8 MB

Last updated

8 months ago

docker pull hylink/clickhouse