mysql 5.6 共用软件，创建多实例

#共享软件目录，启动多个数据库，不同端口。

#只要需要修改
[root@VM-16-10-centos script]# cat a5.6.sh 
#!/bin/bash
#test mysql version mysql-5.6.16-linux-glibc2.5-x86_64.

basedir=/mysql/mysql
datadir=/mysqldata
dbfile=$datadir/$1
port=$1

initos() {
mkdir $dbfile
mkdir $dbfile/data
mkdir $dbfile/log
mkdir $dbfile/run
touch $dbfile/log/db.log
chown -R mysql:mysql $datadir/$1
}

initcnf() {
cat > $dbfile/my.cnf<<EOF
[mysqld]
port=$port
datadir=$dbfile/data
socket=$dbfile/mysql.sock
pid-file=$dbfile/run/db.pid
[mysqld_safe]
log-error=$dbfile/log/db.log
pid-file=$dbfile/run/db.pid
EOF
}

initdb() {
#5.7 init db
#$basedir/bin/mysqld --defaults-file=$dbfile/my.cnf  --user=mysql --initialize-insecure
#5.6 init db
$basedir/scripts/mysql_install_db --datadir=$dbfile/data --user=mysql --basedir=$basedir --defaults-file=$dbfile/my.cnf
}

startup() {
#add startup script
#通过mysql.server脚本添加，删除/etc/my.cnf,软连接$basedir/my.cnf文件，实现通过此脚本启动。
#$datadir/my.cnf不能调用port参数，只能启动默认3306端口。
mv $dbfile/my.cnf $dbfile/data/
cp $basedir/support-files/mysql.server $dbfile/mysql.$port
sed -i 46{s#basedir=#basedir=$basedir#} $dbfile/mysql.$port
sed -i 47{s#datadir=#datadir=$dbfile/data#} $dbfile/mysql.$port
sed -i "48i ln -s $dbfile/data/my.cnf $basedir/my.cnf"  $dbfile/mysql.$port
sed -i '48i rm -rf $basedir/my.cnf' $dbfile/mysql.$port
sed -i '48i rm -rf /etc/my.cnf' $dbfile/mysql.$port
}

chk() {
#startup
echo "startup script is $dbfile/mysql.$port"
$dbfile/mysql.$port start
ps -ef|grep mysql|grep -v grep
}


if [ $# -ne 1 ]
then
echo "Usage: `basename $0` {PORT-NUMBER}"
else
echo  "mysql db port number is :$1"
echo 01:init os.
initos
echo 02:init my.cnf.
initcnf
echo 03:init db.
initdb
echo 04:startup db.
startup
echo 05:chk db info.
chk
fi