安装
直接下载解压二进制包
运行
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://uudwc.com/A/y53z6
https://blog.csdn.net/iceyung/article/details/107524922文章来源地址https://uudwc.com/A/y53z6