mysql5.7.26多实例配置

实验环境:CentOS 7.5
1.提前应该将用户授权做好
mysql> grant all on *. * to [email protected]‘192.168.200.%’ identified by ‘000000’;

2.多实例管理
2.1 准备多个目录
mkdir -p /data/330{7,8,9}/data

2.2 准备配置文件
cat > /data/3307/my.cnf <<EOF
[mysqld]
basedir=/application/mysql
datadir=/data/3307/data
socket=/data/3307/mysql.sock
log_error=/data/3307/mysql.log
port=3307
server_id=7
log_bin=/data/3307/mysql-bin
EOF

cat > /data/3308/my.cnf <<EOF
[mysqld]
basedir=/application/mysql
datadir=/data/3308/data
socket=/data/3308/mysql.sock
log_error=/data/3308/mysql.log
port=3308
server_id=8
log_bin=/data/3308/mysql-bin
EOF

cat > /data/3309/my.cnf <<EOF
[mysqld]
basedir=/application/mysql
datadir=/data/3309/data
socket=/data/3309/mysql.sock
log_error=/data/3309/mysql.log
port=3309
server_id=9
log_bin=/data/3309/mysql-bin
EOF

配置文件设置样板(5.7)
#服务器端配置
[mysqld]
#用户
user=mysql
#软件安装目录
basedir=/application/mysql
#数据路径
datadir=/data/mysql/data
#socket文件位置
socket=/tmp/mysql.sock
#服务器id号
server_id=6
#端口号
port=3306

#客户端配置
[mysql]
#socket文件位置
socket=/tmp/mysql.sock

2.3 初始化三套数据

mv /etc/my.cnf /etc/my.cnf.bak
mysqld --initialize-insecure --user=mysql --datadir=/data/3307/data --basedir=/application/mysql

mysqld --initialize-insecure --user=mysql --datadir=/data/3308/data --basedir=/application/mysql

mysqld --initialize-insecure --user=mysql --datadir=/data/3309/data --basedir=/application/mysql

2.4 systemd管理多实例
cd /etc/systemd/system
cp mysqld.service mysqld3307.service
cp mysqld.service mysqld3308.service
cp mysqld.service mysqld3309.service

vim mysqld3307.service
#修改为:
ExecStart=/application/mysql/bin/mysqld --defaults-file=/data/3307/my.cnf

#修改为:
ExecStart=/application/mysql/bin/mysqld --defaults-file=/data/3308/my.cnf

vim mysqld3309.service
#修改为:
ExecStart=/application/mysql/bin/mysqld --defaults-file=/data/3309/my.cnf

2.5 授权
chown -R mysql.mysql /data/*

2.6 启动
systemctl start mysqld3307.service
systemctl start mysqld3308.service
systemctl start mysqld3309.service

2.7 验证多实例
netstat -lntup|grep 330