中间件(20) : nginx代理mysql

转载已于 2023-12-19 14:17:22 修改 · 469 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://blog.youkuaiyun.com/sg_knight/article/details/131961283

文章标签：

#中间件 #nginx #mysql #代理mysql

于 2023-12-19 10:59:31 首次发布

中间件专栏收录该内容

32 篇文章

订阅专栏

文章介绍了如何通过Nginx配置，使用stream模块实现外网对内网MySQL和Oracle数据库的反向代理，支持多个内网数据库端口的代理。

参考 : 如何通过nginx代理实现外网访问内网mysql或oracle数据库_nginx 代理mysql-优快云博客


user  nginx;
worker_processes  auto;

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


events {
    worker_connections  1024;
}

stream {
    upstream mysql {
        server 192.168.1.2:3306;
    }

    server {
        listen  3306;# 反向代理后监听的端口
        proxy_connect_timeout 1s;
        proxy_timeout 3s;
        proxy_pass mysql;
    }
}

http {
    include       /etc/nginx/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  /var/log/nginx/access.log  main;

    sendfile        on;
    #tcp_nopush     on;

    keepalive_timeout  65;

    #gzip  on;

    include /etc/nginx/conf.d/*.conf;
}

注 : 多个端口的话写多个server即可, docker部署记得放开端口, 如下多个端口


user  nginx;
worker_processes  auto;

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


events {
    worker_connections  1024;
}

stream {

    server {
        listen  3306;# 反向代理后监听的端口
        proxy_connect_timeout 1s;
        proxy_timeout 3s;
        proxy_pass 192.168.1.2:3306;
    }

    server {
        listen  3307;# 反向代理后监听的端口
        proxy_connect_timeout 1s;
        proxy_timeout 3s;
        proxy_pass 192.168.1.3:3307;
    }

    server {
        listen  3308;# 反向代理后监听的端口
        proxy_connect_timeout 1s;
        proxy_timeout 3s;
        proxy_pass 192.168.1.2:3308;
    }
}

http {
    include       /etc/nginx/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  /var/log/nginx/access.log  main;

    sendfile        on;
    #tcp_nopush     on;

    keepalive_timeout  65;

    #gzip  on;

    include /etc/nginx/conf.d/*.conf;
}