3、mysql的多实例配置(2)

4、设置mysql多实例启动脚本：

（1）3306：

[root@backup application]# cat /data/3306/mysql

#!/bin/sh

. /etc/init.d/functions

export PATH=/application/mysql/bin/:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/root/bin

MYUSER="root"

MYPASS="123456"

MYADMIN="mysqladmin -u$MYUSER -p$MYPASS -S /data/3306/mysql.sock"

MYPID="/data/3306/mysqld.pid"

 

[ $UID -eq 0 ] || {

echo "please use root"

exit 1

}

 

function usage (){

echo "USAGE:sh $0 |start|stop|restart|"

}

 

RETVAL=0

function check() {

RETVAL=$?

if [ $RETVAL -eq 0 ]; then

action "$1" /bin/true

else

action "$1" /bin/false

fi

}

 

function start() {

if [ -f $MYPID ]; then

echo "mysql is running......"

else

mysqld_safe --defaults-file=/data/3306/my.cnf &>/dev/null &

check "start mysql"

fi

}

 

function stop() {

if [ -f $MYPID ]; then

$MYADMIN shutdown &>/dev/null

check "stop mysql"

else

echo "mysql is stop......"

fi

}

 

function main(){

if [ $# -eq 1 ]; then

case "$1" in

start)

start

sleep 2

;;

stop)

stop

sleep 2

;;

restart)

stop

start

;;

*)

usage

;;

esac

else

usage

fi

}

 

main $*

[root@backup application]# chmod u+x /data/3306/mysql

（2）3307：

3307启动脚本和3306的启动脚本一致，将3306启动脚本中的路径改为3307的路径即可；

[root@backup application]# chmod u+x /data/3307/mysql

（3）目录树：

[root@backup application]# tree /data

/data

├── 3306

│   ├── data

│   ├── my.cnf

│   └── mysql

└── 3307

├── data

├── my.cnf

└── mysql

4 directories, 4 files

 

5、配置mysql多实例的权限：

[root@backup application]# chown -R mysql:mysql /data/3306/

[root@backup application]# chown -R mysql:mysql /data/3307/

6、初始化mysql多实例：

[root@backup application]# cd /application/mysql/scripts/

[root@backup scripts]# ./mysql_install_db --basedir=/application/mysql --datadir=/data/3306/data/ --user=mysql

Installing MySQL system tables...

OK

Filling help tables...

OK

[root@backup scripts]# ./mysql_install_db --basedir=/application/mysql --datadir=/data/3307/data/ --user=mysql

Installing MySQL system tables...

OK

Filling help tables...

OK

7、启动mysql多实例：

[root@backup scripts]# cd /application/

[root@backup application]# /data/3306/mysql start

start mysql [确定]

[root@backup application]# /data/3307/mysql start

start mysql [确定]

[root@backup application]# netstat -tunlp | egrep "3306|3307"

tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 7827/mysqld

tcp 0 0 0.0.0.0:3307 0.0.0.0:* LISTEN 7475/mysqld