Nginx反代代理MySQL配置实例

225次阅读

共计 2493 个字符，预计需要花费 7 分钟才能阅读完成。

案例：一个朋友要用 Nginx 代理 MySQL（MySQL 局域网），不用 NAT 映射等，好吧，做个笔记。

Nginx 版本：1.9.x（持 tcp 的负载均衡，nginx_tcp_proxy_module（姚伟斌阿里团队也可以实现））

Nginx 官方模块：ngx_stream_core_module –with-stream_ssl_module（ssl 协议支持，比如 MySQL ssl）
官网：http://nginx.org/en/docs/stream/ngx_stream_core_module.html

1、查看现有编译

–user=nginx –group=nginx –prefix=/usr/local/nginx –with-http_stub_status_module –with-http_ssl_module –with-http_realip_module –with-http_flv_module –with-http_mp4_module –with-http_gzip_static_module

2、重新编译：
–user=nginx –group=nginx –prefix=/usr/local/nginx –with-http_stub_status_module –with-http_ssl_module –with-http_realip_module –with-http_flv_module –with-http_mp4_module –with-http_gzip_static_module –with-stream –with-stream_ssl_module

注意：–with-stream –with-stream_ssl_module

3、配置、检测、重启 nginx：
配置：
stream {
upstream mysql {
zone myapp1 64k;
server localhost:3306 weight=1 max_fails=3 fail_timeout=30s;
#server 192.168.1.221:3306 weight=1 max_fails=2 fail_timeout=30s;
}
server {
listen 2188;
proxy_connect_timeout 1s;
proxy_timeout 3s;
proxy_pass mysql;
}
}

检测：
[root@autoCentOS67X64 conf]# nginx -t
nginx: the configuration file /usr/local/nginx/conf/nginx.conf syntax is ok
nginx: configuration file /usr/local/nginx/conf/nginx.conf test is successful
[root@autoCentos67X64 conf]#

启动：
[root@autoCentos67X64 conf]# netstat -atupn|grep nginx
tcp 0 0 0.0.0.0:2188 0.0.0.0:* LISTEN 2359/nginx
[root@autoCentos67X64 conf]#

4、验证：
[root@log~]# mysql -uroot -prenzhiyuan -h 192.168.1.11 -P2188
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.21-log MySQL Community Server (GPL)
Copyright (c) 2000, 2013, 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>

Nginx 反代代理 MySQL 配置实例