Mysql多台数据库同步问题
今天要去服务器上应用,先设了一台主服务器,然后设了两台服务器,分别放在网通和电信,按以前的配置方法来配置好数据库,发现总是不能应用,查了一下错误日志:
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 [email=]'alfasync@master.alfa.com:3306',replication[/email] resumed in log 'mysql-bin.000001' at position 98
060522 22:48:25 [Note] Slave: received end packet from server, apparent master shutdown:
|
下午在公司搞了半天都不知道是什么原因。晚上回家小舅子又一直占着我的宝贝机器不给我用,最后要睡觉了,没有办法,才把他打跑,终于让我用一会儿了。。。
放狗一下,找到这个链接:
http://bugs.mysql.com/bug.php?id=8837
看那个人和我遇到的情况差不太多,于是看了一下后面的回复:
[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 sameserver-id, they may be causing each other to be disconnected. Otherwise, wewill need to see the my.cnf configuration for all servers so we can attempt toreproduce this.
|
应该就是这个问题了,于是分别跑到电信和网通的服务器上去,把server-id分别改成202和102,重启,OK,爽,问题这么简单,看来还是要没事放狗一下,狗狗真是个好东西,HOHO
这样以后一个是电信的,一个是网通的,以后就没有关系了