MySQL本地单机数据库_Mysql 数据库单机多实例部署手记

#multi server

[mysqld_multi]

mysqld = /home/root/local/mysql/bin/mysqld_safe

mysqladmin = /home/root/local/mysql/bin/mysqladmin

#mysqld_multi log

log = /web/mysql/multi.log

#用户名密码，用以mysqld_multi操作时透传给mysqladmin(初始化时一般为匿名访问，注释掉即可)

#user=root

#password=

#dev server

[mysqld3306]

user = mysql

port = 3306

socket = /web/mysql/dev/var/mysql.sock

pid-file = /web/mysql/dev/var/mysqld.pid

log-error = /web/mysql/dev/var/mysqld.log

datadir = /web/mysql/dev/data

max_connections = 200

default-storage-engine = innodb

character_set_server = utf8mb4

#prd server

[mysqld3307]

user = mysql

port = 3811

socket = /web/mysql/prd/var/mysql.sock

pid-file = /web/mysql/prd/var/mysqld.pid

log-error = /web/mysql/prd/var/mysqld.log

datadir = /web/mysql/prd/data

max_connections = 1000

default-storage-engine = innodb

character_set_server = utf8mb4