nginx在1.9版本以后内置tcp,可以用来给mysql做负载,安装nginx参考https://blog.csdn.net/letterss/article/details/82869820,唯一不同的是编译的时候
./configure --prefix=/usr/local/nginx --conf-path=/usr/local/nginx/nginx.conf --with-stream --with-stream_ssl_module
在nginx.conf里面添加stream
stream {
upstream mysql {
hash $remote_addr consistent;
server 106.13.38.88:3306;
}
server {
listen 8080; //监听的端口
proxy_connect_timeout 5s;
proxy_timeout 5s;
proxy_pass mysql;
}
}
启动nginx,测试连接ok