nginx 配置 代理mysql postgres redis

user  root;
worker_processes  4;
events {
    worker_connections  1024;
}

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

    server_names_hash_bucket_size 512;
    client_header_buffer_size 32k;
    large_client_header_buffers 4 32k;
    client_max_body_size 50m;
        
    sendfile   on;
    tcp_nopush on;

    keepalive_timeout  65;
    
    tcp_nodelay on;

    fastcgi_connect_timeout 300;
    fastcgi_send_timeout 300;
    fastcgi_read_timeout 300;
    fastcgi_buffer_size 64k;
    fastcgi_buffers 4 64k;
    fastcgi_busy_buffers_size 128k;
    fastcgi_temp_file_write_size 256k;
    fastcgi_intercept_errors on;
    
    gzip on;
    gzip_min_length  1k;
    gzip_buffers     4 16k;
    gzip_http_version 1.1;
    gzip_comp_level 2;
    gzip_types     text/plain application/javascript application/x-javascript text/javascript text/css application/xml;
    gzip_vary on;
    gzip_proxied   expired no-cache no-store private auth;
    gzip_disable   "MSIE [1-6]\.";

    server {
        listen       80;
        server_name  localhost;
        client_max_body_size 512M;

        #charset koi8-r;

        #access_log  logs/host.access.log  main;
        location / {
            root   html;
            index  index.html index.htm;
        }
        # 192.168.142.128:1111/xxl-job-admin
        location /xxl-job-admin/ {
            proxy_pass http://localhost:8888/xxl-job-admin/;
        }

        error_page   500 502 503 504  /50x.html;
        location = /50x.html {
            root   html;
        }
    }
    
    # 客户端请求服务器最大允许大小-不限（文件大小）
    #client_max_body_size 0; 
    ## 服务端
    upstream minioServer {
        ##minio服务器1，权重越高被分配到的几率越大
        server localhost:9000 weight=1;
        ##minio服务器2
        server localhost:9000 weight=1;
    }
    server{
        listen       99;
        server_name  localhost;
        location /minio {
                proxy_pass http://minioServer;
                # 添加websocket支持
                proxy_http_version      1.1;
                proxy_set_header Upgrade $http_upgrade;
                proxy_set_header Connection "upgrade";
                proxy_next_upstream     http_500 http_502 http_503 http_504 error timeout invalid_header;
                proxy_set_header        Host  $http_host;
                proxy_set_header        X-Forwarded-For $proxy_add_x_forwarded_for;
        }

    }
    #include /www/server/panel/vhost/nginx/*.conf;
}

stream {
    #使用stream 代理postgres
    upstream postgres_backend {
        hash $remote_addr consistent;
        server localhost:5432 weight=5 max_fails=3 fail_timeout=30s;
        server localhost:5432 weight=6 max_fails=3 fail_timeout=30s;
    }
    server {
        listen 5401 so_keepalive=on; #so_keepalive,会话保持，防止查询飘走  
        proxy_pass postgres_backend;
        proxy_connect_timeout 1s;
    }
    #使用stream 代理mysql
    upstream mysql3306 {
        hash $remote_addr consistent;
        server localhost:3306 weight=5 max_fails=3 fail_timeout=30s;
        server localhost:3306 weight=6 max_fails=3 fail_timeout=30s;
    }
    server {
        listen 3301 so_keepalive=on; #so_keepalive,会话保持，防止查询飘走  
        proxy_connect_timeout 10s;
        proxy_timeout 200s;
        proxy_pass mysql3306;       
    }
    upstream mysql3307 {
        hash $remote_addr consistent;
        server localhost:3307 weight=5 max_fails=3 fail_timeout=30s;
        server localhost:3307 weight=6 max_fails=3 fail_timeout=30s;
    }
    server {
        listen 3302 so_keepalive=on; #so_keepalive,会话保持，防止查询飘走  
        proxy_connect_timeout 10s;
        proxy_timeout 200s;
        proxy_pass mysql3307;       
    }
    upstream redis6379 {
        hash $remote_addr consistent;
        server localhost:6379 weight=5 max_fails=3 fail_timeout=30s;
        server localhost:6379 weight=6 max_fails=3 fail_timeout=30s;
    }
    server {
        listen 6301 so_keepalive=on; #so_keepalive,会话保持，防止查询飘走  
        proxy_connect_timeout 10s;
        proxy_timeout 200s;
        proxy_pass redis6379;       
    }
}
#添加防火墙端口
#firewall-cmd --zone=public --add-port=99/tcp --permanent
#firewall-cmd --reload

 origin config：

#user  nobody;
worker_processes  1;

#error_log  logs/error.log;
#error_log  logs/error.log  notice;
#error_log  logs/error.log  info;

#pid        logs/nginx.pid;


events {
    worker_connections  1024;
}


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  logs/access.log  main;

    sendfile        on;
    #tcp_nopush     on;

    #keepalive_timeout  0;
    keepalive_timeout  65;

    #gzip  on;

    server {
        listen       80;
        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;
        }

        # proxy the PHP scripts to Apache listening on 127.0.0.1:80
        #
        #location ~ \.php$ {
        #    proxy_pass   http://127.0.0.1;
        #}

        # pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000
        #
        #location ~ \.php$ {
        #    root           html;
        #    fastcgi_pass   127.0.0.1:9000;
        #    fastcgi_index  index.php;
        #    fastcgi_param  SCRIPT_FILENAME  /scripts$fastcgi_script_name;
        #    include        fastcgi_params;
        #}

        # deny access to .htaccess files, if Apache's document root
        # concurs with nginx's one
        #
        #location ~ /\.ht {
        #    deny  all;
        #}
    }


    # another virtual host using mix of IP-, name-, and port-based configuration
    #
    #server {
    #    listen       8000;
    #    listen       somename:8080;
    #    server_name  somename  alias  another.alias;

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


    # HTTPS server
    #
    #server {
    #    listen       443 ssl;
    #    server_name  localhost;

    #    ssl_certificate      cert.pem;
    #    ssl_certificate_key  cert.key;

    #    ssl_session_cache    shared:SSL:1m;
    #    ssl_session_timeout  5m;

    #    ssl_ciphers  HIGH:!aNULL:!MD5;
    #    ssl_prefer_server_ciphers  on;

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

}