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