https:\/\/www.cnblogs.com\/echohye\/p\/18289809<\/p>\n
\u4f7f\u7528 Nginx \u4f5c\u4e3a\u53cd\u5411\u4ee3\u7406\u670d\u52a1\u5668，\u53ef\u4ee5\u4ee3\u7406 MySQL\u3001PostgreSQL\u3001Redis \u53ca\u591a\u4e2a TCP \u670d\u52a1\u3002\u8fd9\u9700\u8981\u914d\u7f6e Nginx \u7684 stream \u6a21\u5757\u3002<\/p>\n
\u4ee5\u4e0b\u662f\u8be6\u7ec6\u7684\u914d\u7f6e\u6b65\u9aa4：<\/p>\n
\u9996\u5148，\u786e\u4fdd Nginx \u5df2\u7ecf\u7f16\u8bd1\u5e76\u652f\u6301 stream \u6a21\u5757\u3002\u8fd0\u884c\u4ee5\u4e0b\u547d\u4ee4\u68c0\u67e5：<\/p>\n
nginx -V <\/p>\n
\u5728\u8f93\u51fa\u4e2d\u67e5\u627e –with-stream \u548c –with-stream_ssl_module\u3002\u5982\u679c\u6ca1\u6709，\u9700\u8981\u91cd\u65b0\u7f16\u8bd1\u6216\u5b89\u88c5\u652f\u6301 stream \u6a21\u5757\u7684 Nginx \u7248\u672c\u3002<\/p>\n
\u7f16\u8f91 Nginx \u914d\u7f6e\u6587\u4ef6（\u901a\u5e38\u4f4d\u4e8e \/etc\/nginx\/nginx.conf \u6216 \/etc\/nginx\/conf.d\/default.conf），\u6dfb\u52a0 stream \u5757\u914d\u7f6e：<\/p>\n
stream {
\n # MySQL \u4ee3\u7406\u914d\u7f6e
\n upstream mysql_upstream {
\n server 127.0.0.1:3306; # \u66ff\u6362\u4e3a\u4f60\u7684 MySQL \u670d\u52a1\u5668\u5730\u5740\u548c\u7aef\u53e3
\n }<\/p>\n
server {
\n listen 3306; # \u4ee3\u7406\u76d1\u542c\u7684\u7aef\u53e3，\u53ef\u4ee5\u4e0e MySQL \u7684\u7aef\u53e3\u76f8\u540c\u6216\u4e0d\u540c
\n proxy_pass mysql_upstream;
\n }<\/p>\n
# PostgreSQL \u4ee3\u7406\u914d\u7f6e
\n upstream postgres_upstream {
\n server 127.0.0.1:5432; # \u66ff\u6362\u4e3a\u4f60\u7684 PostgreSQL \u670d\u52a1\u5668\u5730\u5740\u548c\u7aef\u53e3
\n }<\/p>\n
server {
\n listen 5432; # \u4ee3\u7406\u76d1\u542c\u7684\u7aef\u53e3，\u53ef\u4ee5\u4e0e PostgreSQL \u7684\u7aef\u53e3\u76f8\u540c\u6216\u4e0d\u540c
\n proxy_pass postgres_upstream;
\n }<\/p>\n
# Redis \u4ee3\u7406\u914d\u7f6e
\n upstream redis_upstream {
\n server 127.0.0.1:6379; # \u66ff\u6362\u4e3a\u4f60\u7684 Redis \u670d\u52a1\u5668\u5730\u5740\u548c\u7aef\u53e3
\n }<\/p>\n
server {
\n listen 6379; # \u4ee3\u7406\u76d1\u542c\u7684\u7aef\u53e3，\u53ef\u4ee5\u4e0e Redis \u7684\u7aef\u53e3\u76f8\u540c\u6216\u4e0d\u540c
\n proxy_pass redis_upstream;
\n }<\/p>\n
# \u5176\u4ed6 TCP \u670d\u52a1\u4ee3\u7406\u914d\u7f6e
\n upstream custom_tcp_upstream {
\n server 127.0.0.1:12345; # \u66ff\u6362\u4e3a\u4f60\u7684\u81ea\u5b9a\u4e49 TCP \u670d\u52a1\u5730\u5740\u548c\u7aef\u53e3
\n }<\/p>\n
server {
\n listen 12345; # \u4ee3\u7406\u76d1\u542c\u7684\u7aef\u53e3，\u53ef\u4ee5\u4e0e\u81ea\u5b9a\u4e49 TCP \u670d\u52a1\u7684\u7aef\u53e3\u76f8\u540c\u6216\u4e0d\u540c
\n proxy_pass custom_tcp_upstream;
\n }
\n} <\/p>\n
\u5728\u5e94\u7528\u65b0\u7684\u914d\u7f6e\u4e4b\u524d，\u6d4b\u8bd5 Nginx \u914d\u7f6e\u6587\u4ef6\u7684\u8bed\u6cd5：<\/p>\n
sudo nginx -t <\/p>\n
\u5982\u679c\u914d\u7f6e\u6b63\u786e，\u91cd\u542f Nginx \u4f7f\u65b0\u7684\u914d\u7f6e\u751f\u6548：<\/p>\n
sudo systemctl restart nginx <\/p>\n
\u4f7f\u7528\u76f8\u5e94\u7684\u5ba2\u6237\u7aef\u5de5\u5177\u8fde\u63a5\u5230 Nginx \u4ee3\u7406\u7684\u7aef\u53e3，\u4ee5\u9a8c\u8bc1\u4ee3\u7406\u662f\u5426\u5de5\u4f5c\u6b63\u5e38\u3002<\/p>\n
mysql -h your_nginx_server_ip -P 3306 -u your_mysql_user -p <\/p>\n
psql -h your_nginx_server_ip -p 5432 -U your_postgres_user -d your_database <\/p>\n
redis-cli -h your_nginx_server_ip -p 6379 <\/p>\n
\u6839\u636e\u81ea\u5b9a\u4e49 TCP \u670d\u52a1\u4f7f\u7528\u76f8\u5e94\u7684\u5ba2\u6237\u7aef\u5de5\u5177\u8fde\u63a5\u5230 Nginx \u4ee3\u7406\u7684\u7aef\u53e3\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb1k\u6b21\uff0c\u70b9\u8d5e6\u6b21\uff0c\u6536\u85cf2\u6b21\u3002\u6839\u636e\u81ea\u5b9a\u4e49 TCP \u670d\u52a1\u4f7f\u7528\u76f8\u5e94\u7684\u5ba2\u6237\u7aef\u5de5\u5177\u8fde\u63a5\u5230 Nginx \u4ee3\u7406\u7684\u7aef\u53e3\u3002_nginx\u914d\u7f6e \u5982\u4f55\u8fde\u63a5postgresql\u6570\u636e\u5e93\u6570\u636e\u5e93<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[117],"topic":[],"class_list":["post-11983","post","type-post","status-publish","format-standard","hentry","category-server","tag-nginx"],"yoast_head":"\n