Re: Replication problem

[ahmad younes]

the first multi master replication we did is stopping with us not knowing what exactly going wrong
sometimes error is .. duplicate primary key , sometimes impossible to read log position

and then we have to delete all relay files and index and redo the replication again for it to work

any idea what might be wrong ?! am not very sure abt my.ini configuration
please tell me if something is wrong with it


[mysqld]
# IP of 2nd Server
report-host=192.168.10.252
report-user=repadmin
report-password=repadmin
# IP of 1st Server
master-host=192.168.10.206
master-user=<repadmin>
master-password=<repadmin>
log-bin=C:/Program Files/MySQL/MySQL Server 5.1/bin/mysql-bin.log
server-id=1
auto_increment_increment=10
auto_increment_offset=1
relay-log-index=callcenter2-relay-bin.index

and to the 2nd


[mysqld]
# IP of 2nd Server
report-host=192.168.10.206
report-user=repadmin
report-password=repadmin
# IP of 1st Server
master-host=192.168.10.252
master-user=<repadmin>
master-password=<repadmin>
log-bin=C:/Program Files/MySQL/MySQL Server 5.1/bin/mysql-bin.log
server-id=2
auto_increment_increment=10
auto_increment_offset=2
relay-log-index=callcenter2-relay-bin.index




the one am note sure about is the relay-log-index=callcenter2-relay-bin.index i use the same file on both servers ... which is the one with the ip 252
is that right ? or should i use deffernet relay index in each my.ini ?