数据库一主一从

1.首先下载安装包

2.部署环境变量

vim /etc/my.conf

主添加内容

server-id=1

log-bin

进入到mysql中

show master logs；

grant replication slave on *.* to repluser@'10.0.0.%' identified by '123456';

help change master  to ---复制

reset master; ---停止

start master; ---启动

show grants for repluser@'10.0.0.%'; ----查看权限

从库

1.首先下载安装包

2.部署环境变量

vim /etc/my.conf

server-id=2

CHANGE MASTER TO MASTER_HOST='10.0.0.6', ------主库的id
  MASTER_USER='replication', ----名
  MASTER_PASSWORD='123456',---密码
  MASTER_PORT=3306,---端口
  MASTER_LOG_FILE='centos7-1-bin.000001', 
  MASTER_LOG_POS=448

show slave status\G