mysql主存binlog同步

亦凉 2021-09-23 11:42 331阅读 0赞

1.  修改主库my.ini  
    ![在这里插入图片描述][2019112517012647.png]
2.  修改存库配置文件  
    ![在这里插入图片描述][20191125170242741.png]

## 注意 ##

### 主从的server-id 不能重复 ###

1.  在主mysql里面配置从库的用户信息
    
        grant replication slave on *.* to 'backup_user' @'%' identified by 'backup@ghsx2019';
2.  在从库的mysql中配置：
    
        change master to master_host='172.17.227.217',
        master_port=12099,
        master_user='slave',
        master_password='elecidenti!123',
        master_log_file='master-bin.000006',
        master_log_pos=180069

如果出现：Got fatal error 1236 from master when reading data from binary log

需要在主库中执行：

flush logs;
    show master status;

然后去从库设置下：

CHANGE MASTER TO MASTER_LOG_FILE='testdbbinlog.000008',MASTER_LOG_POS=107;
    slave start;
    show slave status \G

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW4xODY3NzMzODUzMA_size_16_color_FFFFFF_t_70]

参考：https://blog.csdn.net/yangfenggh/article/details/98237751  
https://www.cnblogs.com/l-hh/p/9922548.html\#top  
https://blog.csdn.net/lixora/article/details/78788535  
https://blog.csdn.net/zleiw/article/details/78243316

https://www.baidu.com/link?url=d3hSkN7clipuvERqKn1w-IkUq782tZxBVmwd1ietVnt1c2\_ZoQyBKwJPUQw9mYAEZ396OnYNgke\_i-QNLnaKwZZGUM\_E2911\_kjqBYnQRhu&wd=&eqid=b46534830010ed67000000035ddb8546

https://blog.csdn.net/qq\_38802291/article/details/83303094

https://blog.csdn.net/xiaoyuerp/article/details/83756366

[2019112517012647.png]: /images/20210923/5444375c94d04eaa87af2907c1ae7f85.png
[20191125170242741.png]: /images/20210923/6521f79f67134dcb8ae137b03c704731.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW4xODY3NzMzODUzMA_size_16_color_FFFFFF_t_70]: /images/20210923/c0f35c0e43b8421886faee89ed08c32b.png