mysql主从配置

最新推荐文章于 2022-04-22 15:20:01 发布

youngeeeeeer

最新推荐文章于 2022-04-22 15:20:01 发布

阅读量78

点赞数

分类专栏： mysql 文章标签： MySQL 主从复制 CentOS7 binlog 配置教程

本文链接：https://blog.csdn.net/youngeeeeeer/article/details/116852088

版权

mysql 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

mysql主从配置

2台linux（centos7）
mysql版本5.7

主机配置

centos1
ip：192.168.8.114

mysql配置my.cnf

[mysqld]
user=mysql
datadir=/var/lib/mysql
#master标识
server-id=1
#【必须】binlog文件配置(路径相对于datadir)
#主从同步原理就是基于binlog文件
log-bin=mysql-bin

mysql配置从机登陆用户
mysql> grant replication slave on *.* to 'rep'@'%' identified by '123456';

从机配置

centos2
ip地址：192.168.8.115

mysql配置文件my.cnf

[mysqld]
user=mysql
datadir=/var/lib/mysql
#slave标识，id非1
server-id=2

mysql从机配置连接主机

mysql> stop slave;
#配置主机信息
mysql> change master to master_host='192.168.8.114', master_user='rep', master_password='123456';
#设置完成后开启同步
mysql> start slave;

查看从机状态

mysql> show slave status;
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.8.114
Master_User: rep
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000001
Read_Master_Log_Pos: 5267
Relay_Log_File: centos2-relay-bin.000003
Relay_Log_Pos: 320
Relay_Master_Log_File: mysql-bin.000001
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table: