nginx 端口代理

1、软件下载

http://nginx.org/en/download.html

  yum -y install pcre-devel

./configure --prefix=/data/nginx --with-stream --with-stream_ssl_module  

make  & make install 
[root@ conf]# cat  nginx.conf
stream {

   upstream dizhi {
       server 72.17.10.58:11856;
   }

  server {
   listen 3306;               
   proxy_connect_timeout 10s;
   proxy_timeout 300s;     
   proxy_pass dizhi;
   }

upstream dizhi2 {
       server 72.17.10.58:11857;
   }

 server {
   listen 3307;
   proxy_connect_timeout 10s;
   proxy_timeout 300s;
   proxy_pass dizhi2;
   }

}

 

参数说明

stream {

   upstream dizhi {
       server 72.17.106.4:11858;
   }
   server {
   listen 3306;               #数据库服务器监听端口,即代理ip的port
   proxy_connect_timeout 10s;
   proxy_timeout 300s;        #设置客户端和代理服务之间的超时时间，如果5分钟内没操作将自动断开。
   proxy_pass dizhi;
   }
}  

  启动服务
[root@ conf]# /ane/nginx/sbin/nginx  

动态加载服务
[root@ conf]# /ane/nginx/sbin/nginx  -s reload

[root@ conf]# netstat -antp|grep 3307
tcp        0      0 0.0.0.0:3307                0.0.0.0:*                   LISTEN      2877/nginx 

登录验证：

[root@ bin]# ./mysql -uboswll -pboswll -h72.17.103.225 -P3307

ysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1626255
Server version: 5.7.24-26-log Percona Server (GPL), Release 26, Revision c8fe767

Copyright (c) 2009-2018 Percona LLC and/or its affiliates
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
+--------------------+