docker安装OLAP数据库ClickHouse

240 阅读1分钟

安装

docker run -d --name clickhouse4 --ulimit nofile=262144:262144 \
-p 8123:8123 -p 9000:9000 -p 9009:9009 --privileged=true \
-v /mydata/docker/clickhouse/log:/var/log/clickhouse-server \
-v /mydata/docker/clickhouse/data:/var/lib/clickhouse yandex/clickhouse-server

端口

  • http端口是8123
  • tcp端口是9000
  • 同步端口9009

进入容器

docker exec -it 容器id /bin/bash

连接

clickhouse-client --host 容器ip
clickhouse-client --host localhost

image.png

查看数据库

show databases;

image.png