前提:
vmware nginx 192.168.18.110:8023
vmware mysql8 192.168.18.111:3306 master
vmware mysql8 192.168.18.112:3306 slave
mysql宕机只剩一台都能用!!!
《nginx安装教程》
《mysql8主从复制》
有了以上准备,才能开始!!!
nginx.conf
worker_processes 1;
events {
worker_connections 1024;
}
stream{
upstream mysql{
server 192.168.18.111:3306;
server 192.168.18.112:3306;
}
server {
#避开3306防止装了mysql数据库占用端口
listen localhost:8023;
proxy_pass mysql;
}
}
http {
include mime.types;
default_type application/octet-stream;
sendfile on;
keepalive_timeout 65;
include conf.d/*.conf;
}
springboot的application.yml
spring:
datasource:
username: x
password: x
#url中database为对应的数据库名称
url: jdbc:mysql://192.168.18.110:8023/demo?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=Asia/Shanghai
driver-class-name: com.mysql.cj.jdbc.Driver
nginx 用stream无法负载均衡…