MySQl 5.7.26 学习笔记-9-多实例管理
目录
1.准备目录
2.准备配置文件
[[email protected] ~]$ 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[[email protected] ~]$ 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[[email protected] ~]$ 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
3.初始化
[[email protected] ~]$ mysqld --initialize-insecure --user=mysql --basedir=/application/mysql --datadir=/data/3307/data
[[email protected] ~]$ mysqld --initialize-insecure --user=mysql --basedir=/application/mysql --datadir=/data/3308/data
[[email protected] ~]$ mysqld --initialize-insecure --user=mysql --basedir=/application/mysql --datadir=/data/3309/data
4.准备启动脚本
[[email protected] ~]$ cp /etc/systemd/system/mysqld.service /etc/systemd/system/mysqld3307.service
[[email protected] ~]$ cp /etc/systemd/system/mysqld.service /etc/systemd/system/mysqld3308.service
[[email protected] ~]$ cp /etc/systemd/system/mysqld.service /etc/systemd/system/mysqld3309.service[[email protected] ~]$ sed -i s#/etc/my.cnf#/data/3307/my.cnf#g /etc/systemd/system/mysqld3307.service
[[email protected] ~]$ sed -i s#/etc/my.cnf#/data/3308/my.cnf#g /etc/systemd/system/mysqld3308.service
[[email protected] ~]$ sed -i s#/etc/my.cnf#/data/3309/my.cnf#g /etc/systemd/system/mysqld3309.service
5.授权
[[email protected] system]$ chown -R mysql.mysql /data/*
6.启动验证
[[email protected] system]$ systemctl start mysqld3307.service
[[email protected] system]$ systemctl start mysqld3308.service
[[email protected] system]$ systemctl start mysqld3309.service