8 messages in com.mysql.lists.mysqlRe: Question about SLAVE STOP
FromSent OnAttachments
Carl McNamee06 Dec 2002 14:13 
Benjamin Pflugmann07 Dec 2002 05:25 
Benjamin Pflugmann07 Dec 2002 06:55 
Heikki Tuuri08 Dec 2002 06:07 
Heikki Tuuri08 Dec 2002 11:59 
Carl McNamee09 Dec 2002 06:17 
Benjamin Pflugmann09 Dec 2002 07:06 
Heikki Tuuri10 Dec 2002 09:33 
Subject:Re: Question about SLAVE STOP
From:Benjamin Pflugmann (benj@pflugmann.de)
Date:12/09/2002 07:06:14 AM
List:com.mysql.lists.mysql

Hello.

On Mon 2002-12-09 at 08:17:41 -0600, Carl@billingconcepts.com 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 roll back.

Correct. The change of 3.23.52 was what was needed to make SLAVE STOP honor (full) transactions.

I'm also assuming that the pointer for the bin-log will now point to the begining of the transaction that was rolled back.

Unfortunately no. This what my last remark (in the other mail) was about and what Heikki also pointed out in his mails. Since the developers are now aware of the problem, I think we can look forward for a early bugfix.

HTH,

Benjamin.

-- benj@pflugmann.de