要利用Nginx实现MYSQL端口转发,需要依赖stream模块,用来做tcp端口转发, Nginx在编译安装时需要加上 --with-stream --with-stream_ssl_module --with-http_ssl_module --with-http_stub_status_module 参数;
Nginx版本要在1.90版本以上。
编译安装后,在配置文件上添加如下配置:
worker_processes 1;
events {
worker_connections 1024;
}
stream {
upstream mysql {
server x.x.x.x:3306;
}
server {
listen 3306;
proxy_pass mysql;
}
}
或者:
worker_processes 1;
events {
worker_connections 1024;
}
stream {
server{
listen 1521 so_keepalive=on;
proxy_pass x.x.x.x:1521;
proxy_timeout 72h;
}
}