分享知识，分享快乐

0%

nginx代理clickhouse

发表于

下载编译源码包

下载源码包到指定的目录，

1
wget http://nginx.org/download/nginx-1.20.2.tar.gz

解压并编译源码

1
2
tar -zxvf  nginx-1.20.2.tar.gz
cd nginx-1.20.2/

1）配置Nginx编译文件参数

1
./configure --with-stream

2）编译、安装，make && make install

1
make & make install

vim /usr/local/nginx/conf/nginx.conf

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
worker_processes auto;

error_log /var/log/nginx/error.log info;

events {
    worker_connections  1024;
}

stream{
  upstream clickhouse8123{
    server 172.20.85.141:8123 weight=1;
    server 172.20.85.142:8123 weight=1;
  }

  server{
    listen 8123;
    proxy_pass clickhouse8123;
  }

  upstream clickhouse9002{
    server 172.20.85.141:9002 weight=1;
    server 172.20.85.142:9002 weight=1;
  }

  server{
    listen 9002;
    proxy_pass clickhouse9002;
  }
}

添加到环境变量

1、编辑/etc/profile

vim /etc/profile
2、在最后一行添加配置，:wq保存

PATH=$PATH:/usr/local/nginx/sbin
export PATH
3、使配置立即生效

source /etc/profile

– 查看帮助

nginx -h

遇到的问题

[root@bigdata-3 nginx-1.20.2]# nginx -s reload
nginx: [error] open() “/usr/local/nginx/logs/nginx.pid” failed (2: No such file or directory)

1
2
mkdir -p /var/logs/nginx/
nginx -c /usr/local/nginx/conf/nginx.conf