Linux/Mac 使用Docker安装Click House

665 阅读1分钟

mac上无法裸部署click house,需要借助docker安装click house。

# 客户端
docker pull yandex/clickhouse-client
# 服务端
docker pull yandex/clickhouse-server

# 创建用于clickhouse的网络给docker用
docker network create ck_net
# 查看网络
docker network ls

# 运行
docker run -d --name clickhouse-server --network=ck_net --ulimit nofile=262144:262144 --volume=/Users/${username}/Documents/workspace/software/clickhouse-database:/var/lib/clickhouse yandex/clickhouse-server

docker exec -it clickhouse-server /bin/bash

clickhouse-client

show databases;

CREATE TABLE default.user_table(id UInt16, name String, age UInt16 ) ENGINE = TinyLog();

SELECT * FROM default.user_table;


# 宿主机连接docker中的clickhouse
docker cp clickhouse-server:/etc/clickhouse-server/ /Users/woxingwosu0100/clickhouse/etc
# 修改配置 65行 注释去掉<listen_host>::</listen_host>
vim /etc/clickhouse-server/config.xml

docker run -d --name clickhouse-server --network=ck_net --ulimit nofile=262144:262144 -p 8123:8123 -p 9000:9000 -p 9009:9009 --volume=/Users/${username}/Documents/workspace/software/clickhouse-database:/var/lib/clickhouse -v /Users/${username}/Documents/workspace/software/clickhouse/etc/config.xml:/etc/clickhouse-server/config.xml yandex/clickhouse-server