Nginx TCP Load balancing for Mysql(3306)

gistfile1.md

TCP LOAD BALANCING

user  nginx;
worker_processes  1;

error_log  /var/log/nginx/error.log warn;
pid        /var/run/nginx.pid;


events {
    worker_connections  1024;
}

stream {
        upstream stream_backend {
            least_conn;
            server 172.17.0.34:3306 max_fails=2 fail_timeout=30s;
            #server backend2.example.com:12345 max_fails=2 fail_timeout=30s;
            #server backend3.example.com:12346 max_conns=3;
        }

        server {
            listen 3306;
            proxy_connect_timeout 1s;
            proxy_timeout 3s;
            proxy_pass stream_backend;
        }
}