mysqld_multi管理多实例

-----------------------------my.cnf
[mysqld_multi] 
mysqld = /usr/bin/mysqld_safe 
mysqladmin = /usr/bin/mysqladmin 
user  = root
password = 123456


[mysqld1] 
port       = 3306 
socket     = /data/program/mysql/mysql.sock1 
pid-file = /data/program/mysql/db-app1.pid 
datadir  = /data/program/mysql/mysql1 
user  = mysql
bind-address= 10.26.18.51
innodb_flush_log_at_trx_commit=0
lower_case_table_names=1
log-bin=mysql-bin-1
log-slave-updates
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
character_set_server=utf8
innodb_file_per_table=1
log_bin_trust_function_creators=1
log-slave-updates 
skip-grant-tables 
server-id=2




[mysqld2] 
port = 3306
socket  = /data/program/mysql/mysql.sock2 
pid-file = /data/program/mysql/db-app2.pid 
datadir  = /data/program/mysql/mysql2 
user  = mysql
bind-address= 10.26.18.52
innodb_flush_log_at_trx_commit=0
lower_case_table_names=1
log-bin=mysql-bin-1
log-slave-updates
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
character_set_server=utf8
innodb_file_per_table=1
log_bin_trust_function_creators=1
log-slave-updates 
skip-grant-tables
server-id=2 


------------创建目录
mkdir -p  /data/program/mysql/mysql1
mkdir -p  /data/program/mysql/mysql2

------------授权
chown -R mysql:mysql /data/program/mysql
chmod -R 777 /data/program/mysql

------------开启服务并创建数据
mysqld_multi --defaults-extra-file=/usr/my.cnf start 1
mysqld_multi --defaults-extra-file=/usr/my.cnf start 2

-----------查看状态
mysqld_multi --defaults-extra-file=/etc/my.cnf report 




mysql -uroot -p -S /data/program/mysql/mysql.sock1  

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29076828/viewspace-1367843/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29076828/viewspace-1367843/