Hi,
I followed the steps for two-way replication as described in the
documentation for mysql in section 4.10
We have two servers on suse linux running mysql, lets call them A and B,
considering A as the master and B as the slave
updates and inserts made at both A and B are seen on each other but the
following case doesn't work
1)The ethernet cable which connects A to the network is removed that is
the master is running but it can't see the slave.
2) INSERTS are made to B
3) A is brought back to the network
Now when it is checked for with a select statement.
some additional updates are seen on the table in A,
i.e. all the updates and inserts made on B right from the beginning are
re-entered into the table on A
e.g.
1) on B
insert into customer('ronak',24);
insert into customer ('raghu', 25);
on A
select * from Customers;
ronak 24
raghu 25
would be the output.
2)The ethernet cable of A is removed removing it from the network.
3) on B the following inserts and updates are made.
insert into customer('ramveera',23);
insert into customer('rocky',23);
4) A is bought back to the network
select * from customers.
would give
ronak 24
raghu 25
ronak 24 // added again
raghu 25 // added again
ramveera 23
rocky 23
whereas the output one would expect is
ronak 24
raghu 25
ramveera 23
rocky 23
Could anyone please suggest a solution to this.
regards,
Shivam
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
