nginx 负载mysql_nginx负载均衡mysql数据库

1、安装

ubuntu 1804上安装：

sudo apt install nginx

查看版本号：nginx -v(1.14.0)

查看模块：nginx -V(检查是否包含stream模块，--with-stream=dynamic)

2、配置

配置文件:/etc/nginx/nginx.conf

在nginx.conf中添加以下代码

# Load Balancing for MySQL

stream {

upstream mysql {

server 192.168.1.251:3306;

server 192.168.1.252:3306;

server 192.168.1.253:3306;

server 192.168.1.254:3306;

}

server {

listen 33066;

proxy_pass mysql;

}

}

3、启动

sudo systemctl status nginx

sudo systemctl start nginx

或

sudo systemctl restart nginx

sudo nginx -s reload

sudo nginx -t 测试配置文件

4、测试

mysql连接地址：192.168.1.248:33066

附URL：

http://nginx.org/en/docs/stream/ngx_stream_core_module.html

https://docs.nginx.com/nginx/admin-guide/load-balancer/tcp-udp-load-balancer/

https://docs.nginx.com/nginx/admin-guide/load-balancer/tcp-health-check/

http://nginx.org/en/docs/switches.html