nginx 代理mysql

nginx 代理mysql

https://www.cnblogs.com/heruiguo/p/8962243.html

user root;
worker_processes 8;
worker_rlimit_nofile  40960;

events {
    use epoll;
    worker_connections 102400;
}

http {


    sendfile on;
    tcp_nopush on;
    tcp_nodelay on;
    keepalive_timeout 120;
    types_hash_max_size 2048;
    server_tokens off;
        fastcgi_buffers 8 128k;
        send_timeout 60;
    proxy_headers_hash_max_size 51200;
    proxy_headers_hash_bucket_size 6400;

    include /usr/local/openresty/nginx/conf/mime.types;
    default_type application/octet-stream;


    ssl_prefer_server_ciphers on;

    proxy_ignore_client_abort on;
    #access_log /var/log/nginx/access.log;
    #error_log /var/log/nginx/error.log;


    gzip on;
    gzip_disable "msie6";



    include /usr/local/openresty/nginx/sites-enabled/*;
}

stream {

    upstream cloudsocket {
       hash $remote_addr consistent;
      # $binary_remote_addr;
       server 133.64.36.129:21 weight=5 max_fails=3 fail_timeout=30s;
    }
    server {
       listen 21;#数据库服务器监听端口
       proxy_connect_timeout 10s;
       proxy_timeout 300s;#设置客户端和代理服务之间的超时时间，如果5分钟内没操作将自动断开。
       proxy_pass cloudsocket;
    }
}