========================================关于nginx代理mysql的超时断开问题=====================================================
#Load balancer causes "Communications link failure" with JDBC and MySQL
#The last packet successfully received from the server was 134,912 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
proxy_timeout 代理时间大一点就好了
events {
worker_connections 10240;
}
stream {
server {
listen 3306;
proxy_connect_timeout 3600s;
proxy_timeout 36000s;
proxy_pass 127.0.0.1:3306;
}
server {
listen 8889;
proxy_connect_timeout 3600s;
proxy_timeout 36000s;
proxy_pass 127.0.0.1:6379;
}
}