Carl,
- Original Message -
From: "Carl McNamee" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, December 10, 2002 6:36 AM
Subject: RE: Question about SLAVE STOP
> I know that the slave will honor transactions but how does that effect the
&
McNamee
Subject: Re: Question about SLAVE STOP
Hello.
On Sat 2002-12-07 at 14:26:00 +0100, [EMAIL PROTECTED] wrote:
> Hello.
>
> On Fri 2002-12-06 at 16:13:54 -0600, [EMAIL PROTECTED]
wrote:
> >
> > First off, we are using Innodb tables on version 3.23.53a-max.
> >
> &
Hello.
On Mon 2002-12-09 at 08:17:41 -0600, [EMAIL PROTECTED] wrote:
> I know that the slave will honor transactions but how does that effect the
> STOP SLAVE command? Based on your note, I'm assuming (Oh, that nasty word!)
> that if the stop slave is issued in the middle of a transaction it will
Hi!
I was able to break replication with a single SLAVE STOP command in 4.0.6.
I ran an InnoDB stress test ibtest17.
>From the printout below we see that after SLAVE START immediately we got a
foreign key error in the slave. That shows the slave no longer was identical
to the master, since only
Hi!
- Original Message -
From: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, December 07, 2002 4:59 PM
Subject: Re: Question about SLAVE STOP
> Hello.
>
> On Sat 2002-12-07 at 14:26:00 +0100, [EMAIL PROTECTED] wro
Hello.
On Sat 2002-12-07 at 14:26:00 +0100, [EMAIL PROTECTED] wrote:
> Hello.
>
> On Fri 2002-12-06 at 16:13:54 -0600, [EMAIL PROTECTED] wrote:
> >
> > First off, we are using Innodb tables on version 3.23.53a-max.
> >
> > If the command STOP SLAVE is issued in the middle of the following type
Hello.
On Fri 2002-12-06 at 16:13:54 -0600, [EMAIL PROTECTED] wrote:
>
> First off, we are using Innodb tables on version 3.23.53a-max.
>
> If the command STOP SLAVE is issued in the middle of the following type of
> transaction:
>
> set autocommit = 0;
> update...;
> update...;
> update...;
>
sql,query
First off, we are using Innodb tables on version 3.23.53a-max.
If the command STOP SLAVE is issued in the middle of the following type of
transaction:
set autocommit = 0;
update...;
update...;
update...;
commit;
does it roll back the current transaction or wait for it to complete?
