Good morning there (and sorry if this mail comes twice - I do not know
If the first try succeeded),
I have a question regarding mysql replication:
I have set up a 2 node replication where each host acts as master AND
slave to the other, so it does not matter where you make changes, both
databases will have the same data.
While testing the configuration with something like
while (i < 1000000)
insert a record containing I into the database
and then pulling the power down switch on the machine which runs the
insert-script (machine A) I see the following:
machine B (which is the slave in this scenario) contains more records
than machine A. The binary log for A is correct (== all records of
machine A are in the binary log).
This means that machine B gets records over the net earlier than machine
A can write it into the binary log.
How can I prevent this - both machines should have the same data?
Any suggestions???
regards
Chris .
---------------------------------------------------------------------
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
