MySQL的主从复制

一级目录

实操

mysql-master 192.168.88.142
mysql-slave1 192.168.88.147
mysql-slave2 192.168.88.144

搭建之前操作

[root@localhost ~]# systemctl stop firewalld
[root@localhost ~]# setenforce 0

master 配置

开启日志文件

vim /etc/my.cnf  ##master

查看数据库从服务器提权

从服务器配置

[root@localhost ~]# vim /etc/my.cnf 
salve1

mysql> change master to master_host='192.168.142.142',master_user='myslave',master_password='123123',master_log_file='master-bin.000002',master_log_pos=154;
Query OK, 0 rows affected, 2 warnings (0.00 sec)

mysql> start slave;
Query OK, 0 rows affected (0.00 sec)

mysql> 

slave2

[root@localhost ~]# vim /etc/my.cnf 

mysql> change master to master_host='192.168.142.142',master_user='myslave',master_password='123123',master_log_file='master-bin.000002',master_log_pos=154;
Query OK, 0 rows affected, 2 warnings (0.00 sec)

mysql> start slave;
Query OK, 0 rows affected (0.00 sec)

mysql>