CentOS7 MySql5.6.39 主从配置
master :192.168.229.129
slave :192.168.229.130
主配置:
server_id=1
log-bin=mysql-bin
innodb_flush_log_at_trx_commit=1
sync_binlog=1
binlog-ignore-db=test
binlog_ignore_db=mysql
创建用户
CREATE USER 'mytest'@'192.168.229.130' IDENTIFIED BY '1qaz2wsx'; #创建用户
GRANT REPLICATION SLAVE ON *.* TO 'mytest'@'192.168.229.130' IDENTIFIED BY '1qaz2wsx';#授权给从库
此时要记住File 与 Position的值mysql-bin.000010 与 785
重新启动主库 service mysqld restart
从配置:
server_id=2
log-bin=mysql-bin
innodb_flush_log_at_trx_commit=1
sync_binlog=1
binlog-ignore-db=test
binlog_ignore_db=mysql
此时注意server_id不能与主库相同,其他的可以一样。这里只配置了忽略哪些库同步(忽略test,mysql),也可以配置具体哪些库同步。
首先进入myql
stop slave;
reset slave all;
show slave status\G;#此时是空,其中\G的意思纵向输出结果
CHANGE MASTER TO
MASTER_HOST='192.168.229.129',
MASTER_USER='mytest',
MASTER_PASSWORD='1qaz2wsx',
MASTER_PORT=3306,
MASTER_LOG_FILE='mysql-bin.000010',
MASTER_LOG_POS=785,
MASTER_CONNECT_RETRY=10;# 注意MASTER_LOG_FILE 与 MASTER_LOG_POS
start slave;
show slave status\G;
这样主从关系就配置好了。