您的位置:首页 > 博客中心 > 数据库 >

Centos7.5 生产环境搭建MySQL 5.7主从

时间:2022-03-15 10:49

环境:
服务器两台:
192.168.19.77 4核心,16G内存 内网隔离,不通外网
192.168.19.78 4核心,16G内存 内网隔离,不通外网

一. 先有外网的机器,下载MySQL 5.7官网软件包
官网下载链接:
为了方便,我这里将安装MySQL5.7需要的官方软件包下载链接地址就直接贴上来
使用官方RPM包安装,需要安装5个包,分别是下面的5个链接,都是官方链接

https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-common-5.7.23-1.el7.x86_64.rpm
https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-libs-5.7.23-1.el7.x86_64.rpm
https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-client-5.7.23-1.el7.x86_64.rpm
https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-server-5.7.23-1.el7.x86_64.rpm
https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-devel-5.7.23-1.el7.x86_64.rpm

二. 安装
使用FTP软件,将软件包上传至内网2台数据库服务器77/78的/tmp目录下
安装rpm前,先要将MariaDB数据库和libs卸载掉

    # yum remove mariadb mariadb-server mariadb-devel mariadb-libs

安装MySQL

   #  rpm -ivh mysql-community-libs-5.7.23-1.el7.x86_64.rpm 
   #  rpm -ivh mysql-community-common-5.7.23-1.el7.x86_64.rpm 
   #  rpm -ivh mysql-community-libs-5.7.23-1.el7.x86_64.rpm 
   #  rpm -ivh mysql-community-client-5.7.23-1.el7.x86_64.rpm 
   #  rpm -ivh mysql-community-server-5.7.23-1.el7.x86_64.rpm 
   #  rpm -ivh mysql-community-devel-5.7.23-1.el7.x86_64.rpm

三. 定制配置数据库
四. 配置主从
五. 验证

本类排行

今日推荐

热门手游