mysql 5.6 启动多实例

###5.6多实列
###复制软件
cp -r mysql-5.6.16-linux-glibc2.5-x86_64 3333
chown -R mysql:mysql 3333
cp -r mysql-5.6.16-linux-glibc2.5-x86_64 8888
chown -R mysql:mysql 8888

#初始化数据目录
####3333
mkdir /3333
mkdir /3333/data
mkdir /3333/log
mkdir /3333/run
touch /3333/log/db.log
chown -R mysql:mysql /3333

cat > /3333/my.cnf<<EOF
[mysqld]
port=3333
datadir=/3333/data
socket=/3333/mysql.sock
[mysqld_safe]
log-error=/3333/log/db.log
pid-file=/3333/run/db.pid
EOF

##初始化数据文件
/mysql/3333/scripts/mysql_install_db --datadir=/3333/data --user=mysql --basedir=/mysql/3333 --defaults-file=/3333/my.cnf

##开机自动启动脚本：
1，新建
ln -s /3333/my.cnf /mysql/3333/my.cnf
2，修改support-files/mysql.server
basedir=/mysql/3333


####8888
mkdir /8888
mkdir /8888/data
mkdir /8888/log
mkdir /8888/run
touch /8888/log/db.log
chown -R mysql:mysql /8888

cat > /8888/my.cnf<<EOF
[mysqld]
port=8888
datadir=/8888/data
socket=/8888/mysql.sock
[mysqld_safe]
log-error=/8888/log/db.log
pid-file=/8888/run/db.pid
EOF
##初始化数据文件
/mysql/8888/scripts/mysql_install_db --datadir=/8888/data --user=mysql --basedir=/mysql/8888 --defaults-file=/8888/my.cnf

##开机自动启动脚本：
1，新建
ln -s /8888/my.cnf /mysql/8888/my.cnf
2，修改support-files/mysql.server
basedir=/mysql/8888


###启动脚本：
[root@VM-16-10-centos support-files]# /mysql/3333/support-files/mysql.server status
 SUCCESS! MySQL running (17135)
[root@VM-16-10-centos support-files]# /mysql/8888/support-files/mysql.server status
 SUCCESS! MySQL running (18018)


####检查结果：
[root@VM-16-10-centos support-files]# ps -ef|grep mysql
root     16977     1  0 22:39 pts/1    00:00:00 /bin/sh /mysql/3333/bin/mysqld_safe --datadir=/3333/data --pid-file=/3333/data/VM-16-10-centos.pid
mysql    17135 16977  0 22:39 pts/1    00:00:00 /mysql/3333/bin/mysqld --basedir=/mysql/3333 --datadir=/3333/data --plugin-dir=/mysql/3333/lib/plugin --user=mysql --log-error=/3333/log/db.log --pid-file=/3333/data/VM-16-10-centos.pid --socket=/3333/mysql.sock --port=3333
root     17861     1  0 22:42 pts/1    00:00:00 /bin/sh /mysql/8888/bin/mysqld_safe --datadir=/8888/data --pid-file=/8888/data/VM-16-10-centos.pid
mysql    18018 17861  9 22:42 pts/1    00:00:00 /mysql/8888/bin/mysqld --basedir=/mysql/8888 --datadir=/8888/data --plugin-dir=/mysql/8888/lib/plugin --user=mysql --log-error=/8888/log/db.log --pid-file=/8888/data/VM-16-10-centos.pid --socket=/8888/mysql.sock --port=8888
root     18059 12625  0 22:42 pts/1    00:00:00 grep --color=auto mysql

[root@VM-16-10-centos support-files]# netstat -antpl|grep mysql
tcp6       0      0 :::8888                 :::*                    LISTEN      18018/mysqld        
tcp6       0      0 :::3333                 :::*                    LISTEN      17135/mysqld