Jean-Luc Fontaine wrote:
> 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).
I'm not sure how to interprete your statement. It looks like you are disturbed by
my mail. I just wanted to indicate, the by the way perfectly legal situation,
that we don't get commercial level support because we don't have commercial
support agreements. That's it.
... and you don't have to wait for one of my mails to send the MySQL team flowers
;-) I am taking my very first MySQL steps here, reporting what I thought is a
bug. Certainly I am convinced they are a fine team - why would I assume
differently?
>
>
> > 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
