第一章需求描述部署三个MySQL5.7多实例环境（端口分别为3307、3308、3309）部署MySQL5.6和8.0版本数据库实例（（端口分别为3316和3326）返回目录第二章环境准备返回目录1.虚拟机环境$hostname-I10.0.1.51$hostnamedb01$cat/etc/redhat-releaseCentOSLinuxrelease7.7.1908(Core)返回目录2.虚拟机优化#关闭Selinux$setenforce0$sed-is#SELINUX=enforcing#SELINUX=disabled#g/etc/selinux/config#关闭防火墙$systemctlstopfirewalld$systemctldisablefirewalld$iptables-save#更改yum源$mv/etc/yum.repos.d/CentOS-Base.repo/etc/yum.repos.d/CentOS-Base.repo.ori$wget-O/etc/yum.repos.d/CentOS-Base.repohttp://mirrors.aliyun.com/repo/Centos-7.repo$sed-i'/aliyuncs/d'/etc/yum.repos.d/CentOS-Base.repo#添加epel源$wget-O/etc/yum.repos.d/epel.repohttp:///mirrors.aliyun.com/repo/epel-7.repo#更新yum缓存$yumcleanall$yummakecachefast#停止NetworkManager$systemctlstopNetworkManager$systemctldisableNetworkManager#增加文件描述符$echo'*-nofile65535'>>/etc/security/limits.conf返回目录3.清理环境返回目录①卸载安装的mysql$rpm-qa|grepmysql#结果如下mysql-community-common-8.0.18-1.el7.x86_64mysql-community-client-8.0.18-1.el7.x86_64mysql-community-libs-8.0.18-1.el7.x86_64#使用以下命令依次删除上面的程序$yumremovemysql-xxx-xxx-returndirectory②删除mysql配置文件$find/-namemysql|xargsrm-frreturndirectory③删除MariaDB文件$rpm-qa|grepmariadb$rpm-emariadb-xxx--nodeps返回目录④删除my.cnf$rm-fr/etc/my.cnf返回目录⑤查看端口是否被占用$whichmysql$pkillmysqld$netstat-lntup|egrep'3307|3308|3309|3316|3326'返回列表4.准备软件包。从MySQL官方下载地址下载二进制包。返回目录5.准备目录$rm-rf/data/*#MySQL安装目录$mkdir-p/data/app#MySQL数据目录$mkdir-p/data/330{7,8,9}/data$mkdir-p/data/33{16,26}/data#scoket目录$mkdir-p/data/socket返回目录第三章部署MySQL5.7多实例返回目录1.解压软件包并建立软连接$tarxfmysql-5.7.28-linux-glibc2.12-x86_64.tar.gz$mvmysql-5.7.28-linux-glibc2.12-x86_64mysql-5.7.28$ln-s/data/app/mysql-5.7.28/data/app/mysql5728返回目录2.创建MySQL多实例配置#3307实例配置$cat>/data/3307/my.cnf<
