mysql 主备重启_mysql 主主同步，服务器重启后需要重新做吗？

最新推荐文章于 2023-07-24 10:34:37 发布

达欣欣

最新推荐文章于 2023-07-24 10:34:37 发布

阅读量679

点赞数

文章标签： mysql 主备重启

本文链接：https://blog.csdn.net/weixin_33410880/article/details/113124385

版权

两台服务器做了主主同步，然后服务器重启过一次，现在mysql主主同步貌似正常的，不过有台服务器的myslq一直报错，另外一台没报错15020211:06:07[Note]Slave:connectedtomaster'replic...

两台服务器做了主主同步，然后服务器重启过一次，现在mysql主主同步貌似正常的，不过有台服务器的myslq一直报错，另外一台没报错

150202 11:06:07 [Note] Slave: connected to master 'replication@10.15.11.22:3306',replication resumed in log 'mysql-bin.000109' at position 4452475

150202 11:06:39 [Note] Slave: received end packet from server, apparent master shutdown:

150202 11:06:39 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000109' position 4471359

150202 11:06:39 [Note] Slave: connected to master 'replication@10.15.11.22:3306',replication resumed in log 'mysql-bin.000109' at position 4471359

150202 11:07:31 [Note] Slave: received end packet from server, apparent master shutdown:

150202 11:07:31 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000109' position 4504884

150202 11:07:31 [Note] Slave: connected to master 'replication@10.15.11.22:3306',replication resumed in log 'mysql-bin.000109' at position 4504884

150202 11:08:23 [Note] Slave: received end packet from server, apparent master shutdown:

150202 11:08:23 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000109' position 4540819

150202 11:08:23 [Note] Slave: connected to master 'replication@10.15.11.22:3306',replication resumed in log 'mysql-bin.000109' at position 4540819

这个需要重新建立主主同步吗？

展开

关注