Centos7.5 ClickHouse 使用Nginx进行负载均衡

编译安装Nginx

1. 安装依赖模块

yum -y install gcc gcc-c++ autoconf automake make

yum -y install zlib zlib-devel openssl openssl-devel pcre pcre-devel

 

2. 下载并解压
 

cd /usr/local/

wget http://nginx.org/download/nginx-1.18.0.tar.gz

tar -xvf nginx-1.18.0.tar.gz

cd nginx-1.18.0

 

3. 编译安装

不带用户模式

./configure --prefix=/usr/local/nginx --with-http_stub_status_module \
 --with-http_ssl_module --with-stream \
 --with-http_gzip_static_module \
 --with-http_sub_module

 

带用户模式

./configure --user=www --group=www --prefix=/usr/local/nginx \
--with-http_stub_status_module \
--with-http_ssl_module --with-stream \
--with-http_gzip_static_module \
--with-http_sub_module

 

make && make install

 

4.配置Nginx

创建配置目录

mkdir conf.d

 

修改 nginx.conf 配置

#user  nobody;
worker_processes  8;

error_log  /usr/local/nginx/logs/error.log;
#error_log  logs/error.log  notice;
#error_log  logs/error.log  info;

pid        logs/nginx.pid;


events {
    worker_connections  1024;
}


stream {


    log_format proxy '$remote_addr [$time_local] '
                 '$protocol $status $bytes_sent $bytes_received '
                 '$session_time "$upstream_addr" '
                 '"$upstream_bytes_sent" "$upstream_bytes_received" "$upstream_connect_time"';

    access_log /usr/local/nginx/logs/tcp-access.log proxy ;
    open_log_file_cache off;
    include /usr/local/nginx/conf.d/*.stream;
}

http {
    include       mime.types;
    default_type  application/octet-stream;

    log_format  main  '$remote_addr - $remote_user [$time_local] "$request" '
                      '$status $body_bytes_sent "$http_referer" '
                      '"$http_user_agent" "$http_x_forwarded_for"';

    access_log  /usr/local/nginx/logs/access.log  main;

    sendfile        on;
    #tcp_nopush     on;

    #keepalive_timeout  0;
    keepalive_timeout  60;

    gzip  on;

    server {
        listen       18080;
        server_name  localhost;

        #charset koi8-r;

        #access_log  logs/host.access.log  main;

        location / {
            root   html;
            index  index.html index.htm;
        }

        #error_page  404              /404.html;

        # redirect server error pages to the static page /50x.html
        #
        error_page   500 502 503 504  /50x.html;
        location = /50x.html {
            root   html;
        }
    }
}

cd conf.d

vim ck_prod.stream


upstream ck {
    server  192.168.1.110:8123 weight=25 max_fails=3 fail_timeout=60s;
    server  192.168.1.111:8123 weight=25 max_fails=3 fail_timeout=60s;
    server  192.168.1.112:8123 weight=25 max_fails=3 fail_timeout=60s;
    server  192.168.1.113:8123 weight=25 max_fails=3 fail_timeout=60s;
}

server {
    listen 18123;
    proxy_pass ck;
}

 

5.配置文件验证

ln -s /usr/local/nginx/sbin/nginx /usr/sbin/nginx


nginx -t

6.启动nginx服务

nginx

nginx -s reload