From owner-freebsd-stable@FreeBSD.ORG  Wed Jan 17 13:38: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 8259D16A412
	for <freebsd-stable@freebsd.org>; Wed, 17 Jan 2007 13:38:00 +0000 (UTC)
	(envelope-from wmoran@collaborativefusion.com)
Received: from mx00.pub.collaborativefusion.com
	(mx00.pub.collaborativefusion.com [206.210.89.199])
	by mx1.freebsd.org (Postfix) with ESMTP id E103613C4A5
	for <freebsd-stable@freebsd.org>; Wed, 17 Jan 2007 13:37:59 +0000 (UTC)
	(envelope-from wmoran@collaborativefusion.com)
Received: from vanquish.pgh.priv.collaborativefusion.com
	(vanquish.pgh.priv.collaborativefusion.com [192.168.2.61])
	(SSL: TLSv1/SSLv3,256bits,AES256-SHA)
	by wingspan with esmtp; Wed, 17 Jan 2007 08:37:59 -0500
	id 00056431.45AE26B7.000147F6
Date: Wed, 17 Jan 2007 08:37:58 -0500
From: Bill Moran <wmoran@collaborativefusion.com>
To: Vladimir Botka <vlado@botka.homeunix.org>
Message-Id: <20070117083758.a45714b6.wmoran@collaborativefusion.com>
In-Reply-To: <1169040597.4775.9.camel@srv>
References: <1169038057.23831.24.camel@richard02> <1169040597.4775.9.camel@srv>
Organization: Collaborative Fusion
X-Mailer: Sylpheed 2.3.0 (GTK+ 2.10.7; i386-portbld-freebsd6.1)
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Cc: Richard <lists@leewelle.de>, 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 13:38:00 -0000

In response to Vladimir Botka <vlado@botka.homeunix.org>:
> Richard píše v st 17. 01. 2007 v 13:47 +0100:
> > Hi there!
> > 
> > I am looking for a solution for a small problem regarding a high
> > availability setup.
> > I am running heartbeat on a STABLE-system, the failover works fine for
> > IP-adresses and I am able to see that a
> > '/usr/local/etc/rc.d/mysql-server start' statement is issued. BUT since
> > the variables for mysql are not set in rc.conf (Otherwise it would be
> > started at startup), it isn't starting at all.
> > 
> > So my question: How to set those rc.conf-variables in order to start
> > services in such an setup? Or is there a better solution?
>
> Hello,
> just modify the /usr/local/etc/rc.d/mysql-server script.
> Cheers, -vlado

Then have to fsck around with diffs at every upgrade?  Not the approach I
would take.  And please don't top-post.

I don't remember the details of how heartbeat works, but you should be able
to set the required variables and export them into the environment prior
to calling the mysql-server script.  If not, just create a wrapper script
that sets the required variables then calls the rc script.

-- 
Bill Moran
Collaborative Fusion Inc.