clickhouse容器部署 | 堂吉哈哈德的博客

直接docker启动

docker run -d \
  -p 8123:8123 -p 9000:9000 \
  -v /home/clickhouse/lib/:/var/lib/clickhouse/ \
  -v /home/clickhouse/log/:/var/log/clickhouse-server/ \
  --ulimit nofile=262144:262144 \
  --cpus 2 -m 4096M \
  -e CLICKHOUSE_DB=user1 -e CLICKHOUSE_USER=vking -e CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT=0 -e CLICKHOUSE_PASSWORD=123 \
  --name clickhouse-server \
  clickhouse/clickhouse-server

docker-compose部署

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34


version: '3.0'
services:
  clickhouse-server:
    container_name: clickhouse-server
    image: 'clickhouse/clickhouse-server'
    restart: always
    ulimits:
      nofile:
        soft: 262144
        hard: 262144
    logging:
      driver: json-file
      options:
        max-size: 5g
    environment:
      CLICKHOUSE_DB: vking_space
      CLICKHOUSE_USER: vking
      CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT: 1
      CLICKHOUSE_PASSWORD: vking123
      TZ: Asia/Shanghai
    volumes:
      - "./clickhouse/lib/:/var/lib/clickhouse/"
      - './clickhouse/log/:/var/log/clickhouse-server/'
    ports:
      - '8123:8123'
      - '9000:9000'
    networks:
      vking:
        ipv4_address: 172.20.0.5
networks:
  vking:
    ipam:
      config:
        - subnet: 172.20.0.0/16

8123端口： HTTP API，用于HTTP请求的JDBC, ODBC和web接口 9000端口： clickhouse-client连接用的接口

连接工具 dbm: http://dbm-zh.edurt.io/ DBeaver: https://dbeaver.io/download/