Mysql主从配置

​注：此处mysql安装 略
此处使用mysql版本为5.7.1

主库创建用户并授权

CREATE USER 'test'@'localhost' IDENTIFIED BY '123456';
GRANT REPLICATION SLAVE,FILE ON *.* TO 'test'@'192.168.1.2' IDENTIFIED BY '123456';
flush privileges;

主库修改配置文件 my.ini

server-id=11
log_bin = mysql-bin
binlog-do-db=test #这个是需要同步的数据库 ，test是一个数据库自行先创建
replicate-do-table=test.table1 #同步表

主从配置不同server-id

  show master status 查看是否成功

从库配置

replicate-ignore-table=test.table2#忽略表  多张写多行即可

CHANGE MASTER TO MASTER_HOST='192.168.10.11',MASTER_PORT=3306,MASTER_USER='test'
,MASTER_PASSWORD='123456',MASTER_LOG_FILE='mysql-bin.000015',MASTER_LOG_POS=606;

#查看从库状态

start slave;
show slave status;

踩坑问题

[ERROR] Slave I/O for channel '': Fatal error: 
The slave I/O thread stops because master and slave have equal MySQL server UUIDs;
 these UUIDs must be different for replication to work

mysql slave为copy过来的,导致uuid重复 修改后即同步完成

​