From owner-freebsd-stable@FreeBSD.ORG Thu Jan 18 08:47:39 2007 Return-Path: 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 A41BE16A492 for ; Thu, 18 Jan 2007 08:47:39 +0000 (UTC) (envelope-from lists@leewelle.de) Received: from mail.verwayen.com (mail.verwayen.com [88.198.161.26]) by mx1.freebsd.org (Postfix) with ESMTP id 6782A13C46A for ; Thu, 18 Jan 2007 08:47:39 +0000 (UTC) (envelope-from lists@leewelle.de) Received: from localhost (localhost [127.0.0.1]) by mail.verwayen.com (Postfix) with ESMTP id DDAAD58467 for ; Thu, 18 Jan 2007 08:49:29 +0000 (UTC) Received: from mail.verwayen.com ([127.0.0.1]) by localhost (mail.verwayen.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 10840-08 for ; Thu, 18 Jan 2007 08:49:23 +0000 (UTC) Received: from [192.168.223.8] (u6-52.dsl.vianetworks.de [194.231.186.52]) by mail.verwayen.com (Postfix) with ESMTP id 9E8EB58476 for ; Thu, 18 Jan 2007 08:49:22 +0000 (UTC) From: Richard To: freebsd-stable@freebsd.org In-Reply-To: References: <1169038057.23831.24.camel@richard02> <200701171608.55482.nvass@teledomenet.gr> <1169046617.23831.46.camel@richard02> Content-Type: text/plain Date: Thu, 18 Jan 2007 09:47:08 +0100 Message-Id: <1169110028.20706.53.camel@chaffinch> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2.1 FreeBSD GNOME Team Port Content-Transfer-Encoding: 7bit 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 18 Jan 2007 08:47:39 -0000 On Wed, 2007-01-17 at 19:48 +0100, Ivan Voras wrote: > Richard wrote: > > > Am Mittwoch, den 17.01.2007, 16:08 +0200 schrieb Nikos Vassiliadis: > > >> I remember that heartbeat can call any script you it tell to. > >> So, you have to let heartbeat start MySQL. rc will just start > >> heartbeat. > > Yes, you are right, and exactly that was my problem. It didn't start. > > Hmm, do you have more information - in which way did it fail? rc.d > scripts (including those for mysql) bring in variables via rc.subr: > > ---- > # > # Add the following line to /etc/rc.conf to enable mysql: > # mysql_enable (bool): Set to "NO" by default. > > Are you saying this part has failed, or that you don't have the proper > variables in /etc/rc.conf? If the variable mysql_enable is set in '/etc/rc.conf', mysql is started on both nodes at startup, it it is not there (and the passive node won't work due to the lack of mounted diskspace), heartbeat call '/usr/local/etc/rc.d/mysql-server start' and nothing happens. I got around this problem by writing my own startup-scripts not using those Variables. I thought that there might be a much nicer solution, but a failover configuration working with FreeBSD seems not to be that widespread as it is under Linux. (Yes, there are many firewall-implementations using carp, but would that work for services like mysql or samba too?) Richard