- 下载MySQL安装包,并解压多份,
- 将其端口设置成3307和3308(my.ini中设置)
- 配置数据库主从关系,保证数据库中数据一致(其他文章介绍)
- 配置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的数据库