1-下载安装
下载以上文件放到centos7服务器的 指定文件下
执行安装命令：yum install -y mysql-community-*-5.7.37-1.el7.x86_64.rpm
2-账号创建
# 开启MySQL服务器 systemctl start mysqld
# 查看默认生成的密码 cat /var/log/mysqld.log | grep password
#登录：mysql -u root -p 输入密码登录
# 设置密码等级 （可以设置简单密码，等级小一点）
set global validate_password_length=4;
set global validate_password_policy=0;
#创建maseter用户并授权
CREATE USER 'master'@'%' IDENTIFIED WITH mysql_native_password BY 'master';
ALTER USER 'master'@'%' IDENTIFIED WITH mysql_native_password BY 'master';
GRANT ALL PRIVILEGES ON *.* TO 'master'@'%' IDENTIFIED BY 'master' WITH GRANT OPTION; FLUSH PRIVILEGES;
FLUSH PRIVILEGES;
#创建slave用户并授权
CREATE USER 'slave'@'%' IDENTIFIED WITH mysql_native_password BY 'slave';
GRANT REPLICATION SLAVE ON *.* TO 'slave'@'%' IDENTIFIED BY 'slave' WITH GRANT OPTION;
FLUSH PRIVILEGES;FLUSH PRIVILEGES;
除最后 创建slave账号外，从mysql的服务搭建重复上面步骤
3-主从配置文件设置
1-maseter的mysql的my.cnf配置
在[mysqld]下添加
user=root centos的登录系统，这里省劲直接用root
character-set-server=utf8
port=3306
tmpdir=/tmp
log-bin=master-bin
log-bin-index=master-bin.index
server-id=1 唯一，slave的服务也有这个不能重复
2-slave的mysql的my.cnf配置
user=root
character-set-server=utf8
port=3306
tmpdir=/tmp
relay-log=slave-relay-bin
relay-log-index=slave-relay-bin.index
server-id=2
3-启动命令
在master服务器执行show master status；
在slave服务器执行
CHANGE MASTER TO
MASTER_HOST='192.168.0.200',
MASTER_PORT=3306,
MASTER_USER='slave',
MASTER_PASSWORD='slave',
master_log_file='master-bin.000001', 上一步命令中看到master的文件名和偏移量
master_log_pos=154;
START SLAVE;
搭建完成就可以测试了
