Mysql主从复制

环境准备
软件及系统: CentOS 7.5 — 2台、MySQL 5.7 — Yum安装
系统环境准备

##关闭防⽕墙及SElinux安全机制

[root@mysql ~]# `systemctl disable firewalld`

Removed symlink /etc/systemd/system/multiuser.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbusorg.fedoraproject.FirewallD1.service.

[root@mysql ~]# sed -ri s/SELINUX=enforcing/SELINUX=disabled/g

/etc/selinux/config

[root@mysql ~]# reboot

##必要的软件环境准备

[root@mysql ~]# yum -y install wget vim net-tools

[root@mysql ~]# yum -y groupinstall "Development Tools"

[root@mysql ~]# wget https://dev.mysql.com/get/mysql80-community-releaseel7-1.noarch.rpm
[root@mysql ~]# rpm -ivh mysql80-community-release-el7-1.noarch.rpm

需要修改MySQL的安装仓库的设置, 开启5.7的安装源, 关闭8.0的安装源
将mysql的配置文件的8.0的enable改为0 5.7的版本的enable改为1

安装构建
##安装配置过程

>   [root@mysql ~]# yum -y install mysql-community-server

[root@mysql ~]# systemctl enable mysqld && systemctl start mysqld

##主从配置过程
##------------------------------------主库设置----------------------------
--------##

[root@master ~]# vi /etc/my.cnf //开启⼆进制⽇志并设置服务ID

[mysqld]
server-id=21    				 //这里可以填你ip的最后一位
log-bin=mysql-bin

[root@master ~]# systemctl start mysqld && systemctl enable mysqld

[root@master ~]# grep 'password' /var/log/mysqld.log

2018-09-28T01:53:04.173732Z 1 [Note] A temporary password is generated for
root@localhost: ied,1qj(y/gH //注意修改密码
[root@master ~]# mysql -uroot -p’(BavDu…0928)’
mysql> CREATE USER ‘replication’@‘192.168.13.22’ IDENTIFIED BY
“#BavDu…0928#”;
Query OK, 0 rows affected (0.01 sec)
mysql> GRANT REPLICATION SLAVE ON . TO ‘replication’@‘192.168.13.22’;
Query OK, 0 rows affected (0.00 sec)
mysql> SHOW MASTER STATUS;
±-----------------±---------±-------------±-----------------±---------
---------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
Executed_Gtid_Set |
±-----------------±---------±-------------±-----------------±---------
---------+
| mysql-bin.000002 | 877 | | |
|
±-----------------±---------±-------------±-----------------±---------
---------+
1 row in set (0.00 sec)
##------------------------------------主库设置----------------------------

--------##

##------------------------------------从库设置----------------------------
--------##

[root@slave ~]# vi /etc/my.cnf
[mysqld]
server_id=22

[root@slave ~]# systemctl start mysqld && systemctl enable mysqld

[root@slave ~]# grep 'password' /var/log/mysqld.log

2018-09-28T02:07:33.890742Z 1 [Note] A temporary password is generated for
root@localhost: dFS:z5DQ/<h5

[root@slave ~]# mysql -uroot -p'(BavDu..0928)'

mysql>

CHANGE MASTER TO  
-> MASTER_HOST='192.168.13.21',  
> MASTER_USER='replication', 
-> MASTER_PASSWORD='#BavDu..0928#', 
> MASTER_LOG_FILE='mysql-bin.000001', 
 -> MASTER_LOG_POS=877;

mysql> start slave;

mysql>

 show slave status\G;

*************************** 1. row ***************************

##------------------------------------从库设置---------------------------
---------##

ok 一主一从的模式已经搭建完成，同时可以扩展为一主多从的模式。