Nginx configuration WebService, MySQL, SQL Server, Oracle and other agents

Nginx Configuration WebService

#user nobody;worker_processes4; #error_log logs/Error.log, #error_log logs/error.log notice; #error_log logs/error.log info; #pid logs/nginx.pid;events {worker_connections1024x768;}    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_timeout0; Keepalive_timeout $; Upstream Esbserver {server127.0.0.1:8083weight=1max_fails=2fail_timeout=30s;    } #gzip on; server {Listen8081;        server_name localhost; #charset Koi8-0; #access_log logs/Host.access.log Main; Location/ladder_web {proxy_set_header X-real-IP $remote _addr; Proxy_pass http://Esbserver;        }           }}

Nginx config MySQL proxy--based on nginx1.9 above stream module
The stream module is used for general TCP proxies and load balancing.

#user nobody;worker_processes1; #error_log logs/Error.log, #error_log logs/error.log notice; #error_log logs/error.log info; #pid logs/nginx.pid;events {worker_connections1024x768;} Stream {Upstream SQL {server172.16.10.229:3306weight=1max_fails=2fail_timeout=30s; } Server {Listen3333;        Proxy_connect_timeout 1s;        Proxy_timeout 3s;    Proxy_pass SQL; }}

Nginx Configuration SQL Server service Proxy

#user nobody;worker_processes1; #error_log logs/Error.log, #error_log logs/error.log notice; #error_log logs/error.log info; #pid logs/nginx.pid;events {worker_connections1024x768;} stream {Upstream SQL Server {server172.16.10.167:1433weight=1max_fails=2fail_timeout=30s; } Server {Listen3334;        Proxy_connect_timeout 1s;        Proxy_timeout 3s;    Proxy_pass SQL Server; }}

Nginx Configuration Oracle Proxy

#user nobody;worker_processes1; #error_log logs/Error.log, #error_log logs/error.log notice; #error_log logs/error.log info; #pid logs/nginx.pid;events {worker_connections1024x768;} Stream {Upstream Oracle {server172.16.10.222:1521weight=1max_fails=2fail_timeout=30s; } Server {Listen3335;        Proxy_connect_timeout 1s;        Proxy_timeout 3s;    Proxy_pass Oracle; }}

Nginx configuration WebService, MySQL, SQL Server, Oracle and other agents