From owner-freebsd-stable@FreeBSD.ORG  Wed Jan 17 15:08:00 2007
Return-Path: <owner-freebsd-stable@FreeBSD.ORG>
X-Original-To: freebsd-stable@freebsd.org
Delivered-To: freebsd-stable@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id 3EEDC16A412
	for <freebsd-stable@freebsd.org>; Wed, 17 Jan 2007 15:08:00 +0000 (UTC)
	(envelope-from eugen@www.svzserv.kemerovo.su)
Received: from www.svzserv.kemerovo.su (www.svzserv.kemerovo.su
	[213.184.65.80])
	by mx1.freebsd.org (Postfix) with ESMTP id 9698D13C45A
	for <freebsd-stable@freebsd.org>; Wed, 17 Jan 2007 15:07:59 +0000 (UTC)
	(envelope-from eugen@www.svzserv.kemerovo.su)
Received: from www.svzserv.kemerovo.su (eugen@localhost [127.0.0.1])
	by www.svzserv.kemerovo.su (8.13.8/8.13.8) with ESMTP id l0HEXBDt074859;
	Wed, 17 Jan 2007 21:33:11 +0700 (KRAT)
	(envelope-from eugen@www.svzserv.kemerovo.su)
Received: (from eugen@localhost)
	by www.svzserv.kemerovo.su (8.13.8/8.13.8/Submit) id l0HEXBfE074858;
	Wed, 17 Jan 2007 21:33:11 +0700 (KRAT) (envelope-from eugen)
Date: Wed, 17 Jan 2007 21:33:11 +0700
From: Eugene Grosbein <eugen@kuzbass.ru>
To: Richard <lists@leewelle.de>
Message-ID: <20070117143311.GA74404@svzserv.kemerovo.su>
References: <1169038057.23831.24.camel@richard02>
	<6b3582f60701170547l13f387dalf594e2c0895a49d9@mail.gmail.com>
	<1169043029.23831.32.camel@richard02>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <1169043029.23831.32.camel@richard02>
User-Agent: Mutt/1.4.2.1i
Cc: freebsd-stable@freebsd.org
Subject: Re: Failover-HA-Setup
X-BeenThere: freebsd-stable@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Production branch of FreeBSD source code <freebsd-stable.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>, 
	<mailto:freebsd-stable-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-stable>
List-Post: <mailto:freebsd-stable@freebsd.org>
List-Help: <mailto:freebsd-stable-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
	<mailto:freebsd-stable-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 17 Jan 2007 15:08:00 -0000

On Wed, Jan 17, 2007 at 03:10:29PM +0100, Richard wrote:

> > Try '/usr/local/etc/rc.d/mysql-server forcestart'

> Hm, that's only a temporary solution.
> 
> As a background:
> 
> Heartbeat monitors the HA nodes via a UDP ping (or other method) and if
> one of the nodes goes down, it takes over a clustered IP and then starts
> services by issuing the corresponding scripts in [/usr/local|]/etc/rc.d
> with the argument start...
> 
> So your solution will not really work....

Just put another script into /usr/local/etc/rc.d that would
run /usr/local/etc/rc.d/mysql-server forcestart
if and only if a flag is present in your system.
Create the flag when system boots and before /usr/local/etc/rc.d/mysql-server
starts with rcorder. Remove the flag just after 
/usr/local/etc/rc.d/mysql-server has finished.

You can user crons '@reboot' feature to create a flag
and one more rc.d script that runs after mysql-server and removes flag.

Eugene Grosbein