mysql多个实例_Mysql启动多个实例

系统环境:CentOS5

操作步骤:

cd /var/lib

cp -a mysql /var/lib/mysql1

cp -a mysql /var/lib/mysql2

vi /etc/my_multi.cnf

[mysqld_multi]

mysqld = /usr/bin/mysqld_safe

mysqladmin = /usr/bin/mysqladmin

user = root

[mysqld1]

socket = /tmp/mysql.sock1

port = 3307

pid-file = /var/lib/mysql1/hostname.pid1

datadir = /var/lib/mysql1

log = /var/lib/mysql1/log-file.log

log-error = /var/lib/mysql1/log-error.err

[mysqld2]

socket = /tmp/mysql.sock2

port = 3308

pid-file = /var/lib/mysql2/hostname.pid2

datadir = /var/lib/mysql2

log = /var/lib/mysql2/log-file.log

log-error = /var/lib/mysql2/log-error.err

mysqld_multi --config-file=/etc/my_multi.cnf start 1,2

mysql -u root -S /tmp/mysql.sock1

vi yemaosheng_com.sh

#!/bin/sh

if [ $1 == "start" ]

then

mysqld_multi --config-file=/etc/my_multi.cnf start 1,2

echo "All Mysql Start";

else

mysqld_multi --config-file=/etc/my_multi.cnf stop 1,2

echo "All Mysql Stop";

fi

sh yemaosheng_com.sh start

转载请注明出处：http://yemaosheng.com

分享到：

2012-06-25 19:32

浏览 700

分类:数据库

评论