【clickhouse】chproxy使用记录

安装

直接下载解压二进制包

运行

chproxy -config ./config.yml

配置

server:
  http:
      listen_addr: ":9090"
 
      # Networks with application servers.
      allowed_networks: ["192.168.1.0/24"]
 
users:
  - name: "test"
    to_cluster: "cluster"
    to_user: "default"
    password: "123456"
 
clusters:
  - name: "cluster"
 
    # Requests are spread in `round-robin` + `least-loaded` fashion among nodes.
    # Unreachable and unhealthy nodes are skipped.
    nodes: [
      "0:8123",
      "1:8123",
      "2:8123",
    ]
    users:
      - name: "default"
        password: "123"

请求

?user=test&password=123456&query=select... 像这样发送请求来执行query然后获取返回。

url 请求 /metrics可以获取metrics。

问题

invalid username or password for user "default"; query: ""

这里chproxy有两种密码设置，一个是server上的用于访问CH数据库的用户密码，一个是请求chproxy带的访问密码。

Read

Chproxy+Clickhouse高可用集群部署监控_clickhouse23.7_三思呐三思的博客-CSDN博客 

https://blog.csdn.net/iceyung/article/details/107524922