NIGINX部署数据库

1. 下载MySQL安装包,并解压多份,
2. 将其端口设置成3307和3308(my.ini中设置)
3. 配置数据库主从关系,保证数据库中数据一致(其他文章介绍)
4. 配置nginx 如下:

#user  nobody;
worker_processes  1;

#error_log  logs/error.log;
#error_log  logs/error.log  notice;
#error_log  logs/error.log  info;

#pid        logs/nginx.pid;


events {
    worker_connections  1024;
}


http {
    include       mime.types;
    default_type  application/octet-stream;

    #log_format  main  '$remote_addr - $remote_user [$time_local] "$request" '
    #                  '$status $body_bytes_sent "$http_referer" '
    #                  '"$http_user_agent" "$http_x_forwarded_for"';

    #access_log  logs/access.log  main;

    sendfile        on;
    #tcp_nopush     on;

    #keepalive_timeout  0;
    keepalive_timeout  65;

    #gzip  on;

    server {
        listen       80;
        server_name  localhost;

        #charset koi8-r;

        #access_log  logs/host.access.log  main;

        location / {
            root   html;
            index  index.html index.htm;
        }

        #error_page  404              /404.html;

        # redirect server error pages to the static page /50x.html
        #
        error_page   500 502 503 504  /50x.html;
        location = /50x.html {
            root   html;
        }
    }
}
stream {
    server {
       listen 3306;
       proxy_pass db;    
    }
    upstream db {
       #server 127.0.0.1:3307;
       server 127.0.0.1:3308;
    }
 
}

数据库连接端口都为3306,可以切换数据库使用3307和3308的数据库