红联Linux门户
Linux帮助

Mysql多台数据库同步问题

发布时间:2006-09-29 21:25:19来源:红联作者:asiaec
今天要去服务器上应用,先设了一台主服务器,然后设了两台服务器,分别放在网通和电信,按以前的配置方法来配置好数据库,发现总是不能应用,查了一下错误日志:
[code]060522 22:48:24 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' position 98
060522 22:48:24 [Note] Slave: connected to master 'alfasync@master.alfa.com:3306',replication resumed in log 'mysql-bin.000001' at position 98
060522 22:48:25 [Note] Slave: received end packet from server, apparent master shutdown:[/code]

下午在公司搞了半天都不知道是什么原因。晚上回家小舅子又一直占着我的宝贝机器不给我用,最后要睡觉了,没有办法,才把他打跑,终于让我用一会儿了。。。

放狗一下,找到这个链接:

http://bugs.mysql.com/bug.php?id=8837

看那个人和我遇到的情况差不太多,于是看了一下后面的回复:

[code][1 Mar 2005 23:15] Dean Ellis
Of course, if there is a bug and it is 4.1 we do want to fix that. :)

Please check that your slaves have different server-ids. If they have the same
server-id, they may be causing each other to be disconnected. Otherwise, we
will need to see the my.cnf configuration for all servers so we can attempt to
reproduce this.[/code]

应该就是这个问题了,于是分别跑到电信和网通的服务器上去,把server-id分别改成202和102,重启,OK,爽,问题这么简单,看来还是要没事放狗一下,狗狗真是个好东西,HOHO

这样以后一个是电信的,一个是网通的,以后就没有关系了
文章评论

共有 0 条评论