docker-compose安装clickhouse

1、编写docker-compose配置文件

version: '2'
 
services:
  clickhouse:
    image: yandex/clickhouse-server
    hostname: clickhouse
    container_name: clickhouse
    expose:
      - "9000"
    user: root
    privileged: true
    ports:
      - "8133:8123"
      - "9011:9000"
    volumes:
      - ./data:/var/lib/clickhouse
      - ./log/:/var/log/clickhouse-server/
      - ./etc/:/etc/clickhouse-server/
    environment:
      - TZ=Asia/Shanghai
    ulimits:
      nofile:
        soft: 262144
        hard: 262144

2、目录结构查询

[root@otcdatabases-postgresql-test-192-168-1-48 clickhouse]# ls
data  docker-compose.yml  etc  log
[root@otcdatabases-postgresql-test-192-168-1-48 clickhouse]# ls etc/
config.d  config.xml  users.d  users.xml
[root@otcdatabases-postgresql-test-192-168-1-48 clickhouse]# ls data/
access  dictionaries_lib  format_schemas  metadata_dropped      status  tmp           user_files    uuid
data    flags             metadata        preprocessed_configs  store   user_defined  user_scripts

3、更改配置
1）更改用户名密码,更改配置文件/etc/clickhouse-server/users.xml
中users标签下的账号及密码，将原来的用户名default改成clickhouse

2）将配置数据库密码
密文配置

PASSWORD=$(base64 < /dev/urandom | head -c8); echo "$PASSWORD"; 
echo -n "$PASSWORD" | sha256sum | tr -d '-'

明文配置

3) 配置IP访问
更改更改用户名密码,更改配置文件/etc/clickhouse-server/config.xml下
<listen_host>::</listen_host>

4、测试远程登陆

root@clickhouse:/# clickhouse-client --user clickhouse --password
ClickHouse client version 22.1.3.7 (official build).
Password for user (clickhouse): 
Connecting to localhost:9000 as user clickhouse.
Connected to ClickHouse server version 22.1.3 revision 54455.

clickhouse :) show databases;

SHOW DATABASES

Query id: 8cba836e-f7bc-43aa-826c-c37ecf189ccc

┌─name───────────────┐
│ INFORMATION_SCHEMA │
│ default            │
│ information_schema │
│ system             │
└────────────────────┘

4 rows in set. Elapsed: 0.003 sec. 

clickhouse :)