MySQL（一）MySQL-5.7.20二进制多实例安装

MySQL-5.7.20二进制多实例安装

先决条件

[root@mysql-manager ~]# mkdir -p /opstands/tools
[root@mysql-manager ~]# yum -y install bash-com* vim wget lrzsz tree libaio

二进制部署

[root@mysql-manager ~]# cd /opstands/tools
[root@mysql-manager tools]# wget https://downloads.mysql.com/archives/get/file/mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz

或者

[root@mysql-manager tools]# wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz

解压并修改目录名

[root@mysql-manager tools]# tar xf mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz -C /opstands/
[root@mysql-manager tools]# mv /opstands/mysql-5.7.20-linux-glibc2.12-x86_64/ /opstands/mysql-5.7.20

配置环境变量

[root@mysql-manager tools]# echo 'export PATH=/opstands/mysql-5.7.20/bin:$PATH' >> /etc/profile
[root@mysql-manager tools]# source /etc/profile

创建MySQL用户

[root@mysql-manager tools]# useradd -s /sbin/nologin mysql -M

创建每个实例的数据目录

[root@mysql-manager ~]# mkdir -p /opstands/mysql-330{7,8,9}/data

创建每个实例配置文件

[root@mysql-manager ~]# cat >> /opstands/mysql-3307/my.cnf<<EOF
[mysqld]
user=mysql
server_id=7
port=3307
bind-address=0.0.0.0
basedir=/opstands/mysql-5.7.20
datadir=/opstands/mysql-3307/data
socket=/opstands/mysql-3307/mysql.sock
log_error=/opstands/mysql-3307/mysql.log
EOF
[root@mysql-manager ~]# cat >> /opstands/mysql-3308/my.cnf<<EOF
[mysqld]
user=mysql
server_id=8
port=3308
bind-address=0.0.0.0
basedir=/opstands/mysql-5.7.20
datadir=/opstands/mysql-3308/data
socket=/opstands/mysql-3308/mysql.sock
log_error=/opstands/mysql-3308/mysql.log
EOF
[root@mysql-manager ~]# cat >> /opstands/mysql-3309/my.cnf<<EOF
[mysqld]
user=mysql
server_id=9
port=3309
bind-address=0.0.0.0
basedir=/opstands/mysql-5.7.20
datadir=/opstands/mysql-3309/data
socket=/opstands/mysql-3309/mysql.sock
log_error=/opstands/mysql-3309/mysql.log
EOF

初始化数据

[root@mysql-manager ~]#mysqld --initialize-insecure  --basedir=/opstands/mysql-5.7.20 --user=mysql --datadir=/opstands/mysql-3307/data && echo $?
[root@mysql-manager ~]#mysqld --initialize-insecure  --basedir=/opstands/mysql-5.7.20 --user=mysql --datadir=/opstands/mysql-3308/data && echo $?
[root@mysql-manager ~]#mysqld --initialize-insecure  --basedir=/opstands/mysql-5.7.20 --user=mysql --datadir=/opstands/mysql-3309/data && echo $?

拷贝systemd启动文件

[root@mysql-manager tools]# vim /etc/systemd/system/mysqld.service

[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/opstands/mysql-5.7.20/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000

[root@mysql-manager ~]# cp /etc/systemd/system/mysqld.service /etc/systemd/system/mysqld-3307.service
[root@mysql-manager ~]# cp /etc/systemd/system/mysqld.service /etc/systemd/system/mysqld-3308.service
[root@mysql-manager ~]# cp /etc/systemd/system/mysqld.service /etc/systemd/system/mysqld-3309.service

修改启动配置文件路径

[root@mysql-manager ~]# sed -i 's#ExecStart=/opstands/mysql-5.7.20/bin/mysqld --defaults-file=/etc/my.cnf#ExecStart=/opstands/mysql-5.7.20/bin/mysqld --defaults-file=/opstands/mysql-3307/my.cnf#g' /etc/systemd/system/mysqld-3307.service
[root@mysql-manager ~]# sed -i 's#ExecStart=/opstands/mysql-5.7.20/bin/mysqld --defaults-file=/etc/my.cnf#ExecStart=/opstands/mysql-5.7.20/bin/mysqld --defaults-file=/opstands/mysql-3308/my.cnf#g' /etc/systemd/system/mysqld-3308.service
[root@mysql-manager ~]# sed -i 's#ExecStart=/opstands/mysql-5.7.20/bin/mysqld --defaults-file=/etc/my.cnf#ExecStart=/opstands/mysql-5.7.20/bin/mysqld --defaults-file=/opstands/mysql-3309/my.cnf#g' /etc/systemd/system/mysqld-3309.service

授权

[root@mysql-manager ~]# chown -R mysql.mysql /opstands/mysql-*

启动7、8、9三个实例

[root@mysql-manager ~]# systemctl daemon-reload
[root@mysql-manager ~]# systemctl start mysqld-3307.service
[root@mysql-manager ~]# systemctl start mysqld-3308.service
[root@mysql-manager ~]# systemctl start mysqld-3309.service

连接查看7、8、9实例id

[root@mysql-manager ~]# mysql -S /opstands/mysql-3307/mysql.sock -e "show variables like 'server_id'"
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| server_id     | 7     |
+---------------+-------+
[root@mysql-manager ~]# mysql -S /opstands/mysql-3308/mysql.sock -e "show variables like 'server_id'"
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| server_id     | 8     |
+---------------+-------+
[root@mysql-manager ~]# mysql -S /opstands/mysql-3309/mysql.sock -e "show variables like 'server_id'"
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| server_id     | 9     |
+---------------+-------+