linux数据库多实例名,linux mysql 多个实例配置

[mysqld_multi]

mysqld     = /opt/server/db/mysql/bin/mysqld_safe

mysqladmin = /opt/server/db/mysql/bin/mysqladmin

user = root

[mysqld1]

server-id = 1

socket = /tmp/mysql-test.sock

port = 3306

pid-file = /var/lib/dbdata/test/mysqld-test.pid

datadir  = /var/lib/dbdata/test

log-err =  /var/lib/dbdata/test/mysql-test-err

log =      /var/lib/dbdata/test/mysql-test-log

character_set_client = utf8

character_set_server = utf8

default-character-set=utf8

default_table_type = InnoDB

log-queries-not-using-indexes = false

innodb_data_home_dir = /var/lib/dbdata/test

user = mysql

[mysqld2]

server-id = 2

socket = /tmp/mysql-dev.sock

port = 3307

pid-file = /var/lib/dbdata/dev/mysqld-dev.pid

datadir  = /var/lib/dbdata/dev

log-err =  /var/lib/dbdata/dev/mysql-dev-err

log     =  /var/lib/dbdata/dev/mysql-dev-log

character_set_client = utf8

character_set_server = utf8

default-character-set=utf8

default_table_type = InnoDB

log-queries-not-using-indexes = false

innodb_data_home_dir = /var/lib/dbdata/dev

user = mysql

"/etc/my.cnf" 42L, 1097C written