On Monday 26 March 2001 12:19, Johan Vanroose wrote:
> 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).
This mailing list provides plenty of great support, and I take this
opportunity to thank the MySQL people once more (and they deserve much more
than that).
> 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.
Since I am running a production system, I am not touching anything till the
3.23.36 release.
--
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