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 |
+--------------------+