#关闭防火墙
systemctl stop firewalld
setenforce 0
#查看数据系统是否装带数据库
rpm -qa | grep mariadb
yum remove 数据包
yum -y install lrzsz libaio-devel
#上传5.6 5.7.8.0版本数据包
#解压软件包到/usr/local
tar xf mysql-5.6.51-linux-glibc2.12-x86_64.tar.gz -C /usr/local
tar xf mysql-5.7.44-linux-glibc2.12-x86_64.tar.gz -C /usr/local
tar xf mysql-8.0.38-linux-glibc2.12-x86_64.tar.xz -C /usr/local
#建立软链接
ln -s /usr/local/mysql-5.6.51-linux-glibc2.12-x86_64/ /usr/local/mysql56
ln -s /usr/local/mysql-5.7.44-linux-glibc2.12-x86_64/ /usr/local/mysql57
ln -s /usr/local/mysql-8.0.38-linux-glibc2.12-x86_64/ /usr/local/mysql80
#配置环境变量
echo 'export PATH=/usr/local/mysql57/bin:$PATH' > /etc/profile.d/mysql.sh
#使生效
source /etc/profile.d/mysql.sh
#创建数据库服务管理用户
useradd mysql
#创建相关目录并进行授权
#mkdir -p /data/335{6,7}/data /data/3380/data
chown -R mysql. /data/
#下载repo资源包
yum install perl*
#初始化数据库
/usr/local/mysql56/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql56/ --datadir=/data/mysql
/usr/local/mysql57/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql57/ --datadir=/data/3357/data/
/usr/local/mysql80/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql80/ --datadir=/data/3380/data/
#编写多实例配置文件
vim /etc/my56.cnf
[mysqld]
server_id=3356
port=3356
user=mysql
basedir=/usr/local/mysql56
datadir=/data/3356/data
socket=/tmp/mysql3356.sock
vim /etc/my57.cnf
[mysqld]
port=3357
server_id=3357
user=mysql
basedir=/usr/local/mysql57
datadir=/data/3357/data
socket=/tmp/mysql3357.sock
innodb_fast_shutdown=0
vim /etc/my80.cnf
[mysqld]
port=3380
server_id=3380
user=mysql
basedir=/usr/local/mysql80
datadir=/data/3380/data
socket=/tmp/mysql3380.sock
innodb_fast_shutdown=0
mysqlx=0
#实现数据库服务多实例被systemd管理
vim mysqld56.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=/usr/local/mysql56/bin/mysqld --defaults-file=/etc/my56.cnf
LimitNOFILE=5000
vim mysqld57.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=/usr/local/mysql57/bin/mysqld --defaults-file=/etc/my57.cnf
LimitNOFILE=5000
vim mysqld80.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=/usr/local/mysql80/bin/mysqld --defaults-file=/etc/my80.cnf
LimitNOFILE=5000
systemctl daemon-reload
#启动数据库
systemctl start mysqld57
systemctl start mysqld56
systemctl start mysqld80
mysql -uroot -S /tmp/mysql3356.sock
mysql -uroot -S /tmp/mysql3357.sock
mysql -uroot -S /tmp/mysql3380.sock
/usr/local/mysql80/bin/mysql -u
)
