Jean-Luc Fontaine wrote:
> On Thursday 22 March 2001 16:46, Johan Vanroose wrote:
> > From: [EMAIL PROTECTED]
> > To: [EMAIL PROTECTED]
> > Subject: Replication does not continue after removal/replace of network
> > cable.
> >
> > Description:
> > Configuration.
> > Two servers (PCs) running mysql, both are master and slave to each
> > other.
> > Replication using binary log.
> > Updates done (from the mysql console) on either server are replicated
> > to the other.
> > (The application (I) takes care that the updates are not conflicting.)
> > So far so good.
> > Now the problem.
> > I remove a network cable from one of the servers.
> > I do an update (insert into table) on server 1.
> > I do a second update (again insert) on server 2.
> > Of course the updates aren't replicated (no communication possible).
> > However... when I replace the cable, the replication is not done for
> > the
> > previous two inserts. I waited 4 minutes... Still no replication.
>
> Hmmm. The same thing happened to me with the 3.23.35 rpm on Linux Redaht 7.0.
> I had to do a 'slave stop/start' for the slave to recover.
Did you get any further with this problem? I tried MySQL support. But since we have no
support contract I did not get anything usefull back (yet). They say it's an NT problem
but your situation seems to prove different. Also the whole system runs happy - even
MySQL (without its replication).
Since all looks OK (i.e. the log files and master/slave status) I assume that MySQL
just
*forgets* to replicate.
Kind regards,
Johan.
>
>
> --
> Jean-Luc Fontaine
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
