clickhouse手记-优快云博客

本文链接：https://blog.youkuaiyun.com/cxs812760493/article/details/131599612

该文档展示了如何使用Docker配置两个ClickHouse节点（ck-node-1和ck-node-2）进行负载均衡，并利用clickhouse-bulk工具进行数据的批量导入。环境变量设置了服务器地址，而端口映射确保了服务的访问。此外，还提到了ClickHouse的数据查询（如表结构查询）和数据导入导出的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ClickHouse-Bulk 负载均衡

  ck-node-1:
    image: yandex/clickhouse-server
    container_name: mkt-ck-node-1
    restart: always
    volumes:
      - "./docker-data/ck-node-1/data/:/var/lib/clickhouse"
      - "./docker/ck-node-1/config.xml:/etc/clickhouse-server/config.xml"
      - "./docker/ck-node-1/users.xml:/etc/clickhouse-server/users.xml"
      - "./docker-data/ck-node-1/log:/var/log/clickhouse-server"
    ports:
      - "8124:8123"
      - "19001:9000"
      - "19009:9009"

  ck-node-2:
    image: yandex/clickhouse-server
    container_name: mkt-ck-node-2
    restart: always
    volumes:
      - "./docker-data/ck-node-2/data/:/var/lib/clickhouse"
      - "./docker/ck-node-2/config.xml:/etc/clickhouse-server/config.xml"
      - "./docker/ck-node-2/users.xml:/etc/clickhouse-server/users.xml"
      - "./docker-data/ck-node-2/log:/var/log/clickhouse-server"
    ports:
      - "8125:8123"
      - "19002:9000"
      - "19010:9009"

  chbulk:
    image: nikepan/clickhouse-bulk
    container_name: mkt-bulk
    ports:
      - "18124:8124"
    environment:
      - "CLICKHOUSE_SERVERS=http://ck-node-1:8123,http://ck-node-2:8123"
    volumes:
      - "./docker-data/ckbulk/dumps:/app/dumps"

第三方 - 代理 - 《ClickHouse v20.3 使用教程》 - 书栈网 · BookStack

GitHub - nikepan/clickhouse-bulk: Collects many small inserts to ClickHouse and send in big inserts

clickhouse导入导出

# 查询表结构
SHOW CREATE TABLE db_name.table_name FORMAT CSVWithNames;

clickhouse导入和导出 - 码农教程

https://wenku.youkuaiyun.com/answer/6cba10f7799f431f94b76c09aa0ba37c