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

评论

2 楼 xiaolaogong 2011-09-11  

访问到的数据当然相同了
这是运行多个mysqld监听程序实例
加载是数据库当然相同了

1 楼 beming 2011-08-09  

请问博主有没有发现，无论从哪个端口进去都能访问到不同端口里的数据库呢？