请教mysql双向同步问题

00306

我A,B两台机器主从同步可以，但是双向同步不行
在A机器上执行slave start;提示
ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log
查看var目录下的错误内容为:
080825 14:45:48 [ERROR] log ./lsmqy-relay-bin.000056 listed in the index, but failed to stat
080825 14:45:48 [ERROR] Error counting relay log space
080825 14:45:49 [ERROR] log ./lsmqy-relay-bin.000057 listed in the index, but failed to stat
080825 14:45:49 [ERROR] Error counting relay log space
080825 14:45:50 [ERROR] log ./lsmqy-relay-bin.000058 listed in the index, but failed to stat
080825 14:45:50 [ERROR] Error counting relay log space
080825 15:06:32 [ERROR] log ./lsmqy-relay-bin.000059 listed in the index, but failed to stat
080825 15:06:32 [ERROR] Error counting relay log space
而且master.info一直都为空
另B机器上这些都很正常
就是因为这台机器报这个错，所以导致无法实现双向同步
两台机器的mysql版本都为mysql5.0.4
A上面的my.cnf配置为：

server-id       =  1
master-host     =   192.168.5.32

master-user     =  test

master-password =   '123456'

master-port     =  3306

log-bin= mysql-bin

binlog-do-db = testdb
replicate-do-db = testdb


B上面的my.cnf配置为:
server-id       = 2

master-host     =  192.168.5.40

master-user     =   test

master-password = '123456'

master-port     =  3306

replicate-do-db = testdb

binlog-do-db= testdb

log-bin= mysql-bin

请问高手们怎么解决呀

00306

怎么没人看看呀
是不是没有碰到过?

yueliangdao0608

[ERROR] log ./lsmqy-relay-bin.000056 listed in the index, but failed to stat


Check if you have enough privilege to access this file.

q1208c

我只听说过环形同步.

学习一下.

hb_li_520

原帖由 yueliangdao0608 于 2008-8-26 08:31 发表
[ERROR] log ./lsmqy-relay-bin.000056 listed in the index, but failed to stat


Check if you have enough privilege to access this file.

看一下,你自已的/data/是否mysql用户有写入的权限^0^

00306

原帖由 hb_li_520 于 2008-8-27 10:17 发表



看一下,你自已的/data/是否mysql用户有写入的权限^0^

权限是有的
开始都正常，只是我删错了一些二进制文件，才出现这种情况，有没有什么办法补救

yueliangdao0608

So you can do like this in order to remedy.
reset slave;
stop slave;
start slave;

hb_li_520

原帖由 00306 于 2008-8-25 15:12 发表
我A,B两台机器主从同步可以，但是双向同步不行
在A机器上执行slave start;提示
ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log ...

我有一次出现同样的错误信息是因为,有个程序员把我的电脑名字给改了...............
^0^

1. 
   
2. reset slave
   

复制代码

能否执行成功?

00306

谢谢大家，我已经解决了！

linuxrich

一直搞不懂咋就非双向同步， 怎么可能做得到