安装 mysql5.6多实例_MySQL5.6 多实例安装

MySql的linux版本依赖于libaio库

# yum install libaio

# sudo vim /etc/selinux/config

把SELINUX=enforcing改为SELINUX=disabled

【创建用户】

# useradd -r -s /sbin/nologin mysql

【解压Binaries包】

# cd /tmp

# sudo tar zxvf mysql-advanced-5.6.24-linux-glibc2.5-x86_64.tar.gz

# cp mysql-advanced-5.6.24-linux-glibc2.5-x86_64 /usr/local/mysql

# chown mysql.mysql -R /usr/local/mysql

【配置环境变量】

# echo "PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile

# source /etc/profile

【配置my.cnf】

# vim /etc/my.cnf

[mysqld_multi]

mysqld = /usr/local/mysql/bin/mysqld_safe

mysqladmin = /usr/local/mysql/bin/mysqladmin

log = /data/mysql/log/mysqld_multi.log

[mysqld1]

server-id = 1

socket = /data/mysql/data1/socket/mysqld.sock

port = 3306

pid-file = /data/mysql/data1/mysqld.pid

datadir = /data/mysql/data1

log_bin= /data/mysql/data1/binlog/mysql-bin

log-error= /data/mysql/data1/error-3306.log

[mysqld2]

server-id = 2

socket = /data/mysql/data2/socket/mysqld.sock

port = 3307

pid-file = /data/mysql/data2/mysqld.pid

datadir = /data/mysql/data2

log_bin= /data/mysql/data2/binlog/mysql-bin

log-error= /data/mysql/data2/error-3307.log

[mysqld3]

server-id = 3

socket = /data/mysql/data3/socket/mysqld.sock

port = 3308

pid-file = /data/mysql/data3/mysqld.pid

datadir = /data/mysql/data3

log_bin= /data/mysql/data3/binlog/mysql-bin

log-error= /data/mysql/data3/error-3308.log

【创建数据目录】

mkdir /data/mysql/data1/{binlog,socket,relay_log} -p

mkdir /data/mysql/data2/{binlog,socket,relay_log} -p

mkdir /data/mysql/data3/{binlog,socket,relay_log} -p

mkdir -p /data/mysql/log

chown -R mysql.mysql /data/mysql

【初始化数据库】

MySQL5.6路径：/usr/local/mysql/scripts/mysql_install_db

需yum安装：yum -y install perl autoconf

/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data1

/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data2

/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data3

【启停数据库】

# mysqld_multi --defaults-extra-file=/etc/my.cnfstart 1,2,3

# mysqld_multi start 1

# mysqld_multi start 2

# mysqld_multi start 3

# mysqld_multi stop 1

# mysqld_multi stop 2

# mysqld_multi stop 3

或者用mysqladmin停实例

# mysqladmin -uroot -p -P3306 -h127.0.0.1 shutdown

# mysqladmin -uroot -p -P3307 -h127.0.0.1 shutdown

# mysqladmin -uroot -p -P3308 -h127.0.0.1 shutdown

【查看运行情况】

# mysqld_multi --defaults-extra-file=/etc/my.cnf report

【初始化密码】

/usr/local/mysql/bin/

mysqladmin -u root password 'root' -S /data/mysql/data1/socket/mysqld.sock

mysqladmin -u root password 'root' -S /data/mysql/data2/socket/mysqld.sock

mysqladmin -u root password 'root' -S /data/mysql/data3/socket/mysqld.sock

【登录数据库】

# mysql -uroot -p -h127.0.0.1 -P3306

# mysql -uroot -p -h127.0.0.1 -P3307

# mysql -uroot -p -h127.0.0.1 -P3308