编辑/usr/local/nginx/conf/nginx.conf,在最后一行添加如下
stream {
server {
listen 3305;
proxy_pass db;}
upstream db {
server 10.3.131.22:3306;
server 10.3.131.23:3306;
server 10.3.131.24:3306;
server 10.3.131.25:3306;}}# 配置完成后启动nginx
/usr/local/nginx/bin/nginx
# 测试登录
mysql -uroot -p'QianFeng@123' -h 10.3.131.21 -P 3305