chproxy的安装教程

chproxy是clickhouse的代理点，代替clickhouse的客户端

安装包链接：

链接：https://pan.baidu.com/s/1aJbcQSmpr5j_qolBQEjkng
提取码：bcs5
--来自百度网盘超级会员V1的分享

1、上传到服务器，先创建一个文件夹，然后把软件解压到那个文件夹里面

mkdir -p /usr/local/chproxy

tar -zxvf chproxy-linux-amd64-v1.14.0.tar.gz -C /usr/local/chproxy/  && cd /usr/local/chproxy/

ln -s /usr/local/chproxy/ /usr/local/

2、设置配置文件

cd /usr/local/chproxy/

vi config.yml

hack_me_please: true
log_debug: true

# chproxy的访问接口，你会通过这里配置的ip:port来访问你的chproxy
server:
  http:
    listen_addr: ":9090"
    # 允许访问的网络评断
    # allowed_networks: ["10.0.0.0/8", "146.0.0.0/100"]
    read_timeout: 3m
# 一组发送请求到clickhouse的参数设置
param_groups:
  - name: "qfq"
    params:
      - key: "max_query_size"
        value: "10000000000"
      - key: "max_ast_elements"
        value: "1000000000"
      - key: "max_expanded_ast_elements"
        value: "1000000000"

# 连接到clickhouse的集群配置
clusters:
  # 这个clickhouse的连接的集群是支持写操作
  - name: "writer-cluster"
    # clickhouse的集群的地址，如果是全分布式集群，那么多个节点之间使用逗号隔开即可
    nodes: ["192.168.10.101:8123"]
    # clickhouse的用户配置
    users:
      - name: "default"
        password: "qwert"
  # 这个clickhouse的连接集群只读操作      
  - name: "readonly-cluster"
    # clickhouse的集群的地址，如果是全分布式集群，那么多个节点之间使用逗号隔开即可
    nodes: ["192.168.10.101:8123"]
    # clickhouse的用户配置
    users:
      - name: "readonly"
        password: "qwert"

# 缓存方案
caches:
  - name: "longterm"
    dir: "/usr/local/chproxy/cache/"
    max_size: 950Mb
    expire: 30s
  - name: "shortterm"
    dir: "/usr/local/chproxy/cache-shot/"
    max_size: 950Mb
    expire: 30s

# chproxy调用clickhouse的账户
users:
  # 用户[写入权限]，使用此用户连接clickhouse可以进行写入操作
  - name: "qf-insert"
    password: "qf-001"
    to_cluster: "writer-cluster"
    to_user: "default"
    params: "qfq"
    allow_cors: true
    cache: "longterm"
    
  - name: "qf-readonly"
    password: "qf-001-ro"
    to_cluster: "readonly-cluster"
    to_user: "readonly"
    params: "qfq"
    allow_cors: true
    cache: "shortterm"

3、启动

service clickhouse-server start

./chproxy -config config.yml

 上面是在/usr/local/chproxy目录下启动