From owner-freebsd-stable@FreeBSD.ORG Fri Jan 19 22:25:19 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 0727116A400 for ; Fri, 19 Jan 2007 22:25:19 +0000 (UTC) (envelope-from uspoerlein@gmail.com) Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.173]) by mx1.freebsd.org (Postfix) with ESMTP id 8C77413C45B for ; Fri, 19 Jan 2007 22:25:18 +0000 (UTC) (envelope-from uspoerlein@gmail.com) Received: by ug-out-1314.google.com with SMTP id o2so525441uge for ; Fri, 19 Jan 2007 14:25:17 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:date:from:to:cc:subject:message-id:mail-followup-to:references:mime-version:content-type:content-disposition:in-reply-to; b=AWBaPLQY4E0M46DLag4aYCH6fIXi0L06/mZZ2WG3BjOFWxbCTUex0iICK3HZSghHdj3w4yR2cq2KTkOYVXUOSCK+uyqs/c6GlDfIONzYXMcEx1PobomvUgqWdZgvBUvsqMboOwZK5qjOPenrdpX8Es73SU9CwhYsgCqY/96LQKU= Received: by 10.66.255.7 with SMTP id c7mr3836772ugi.1169245517154; Fri, 19 Jan 2007 14:25:17 -0800 (PST) Received: from roadrunner.q.local ( [85.180.174.29]) by mx.google.com with ESMTP id y7sm3075329ugc.2007.01.19.14.25.16; Fri, 19 Jan 2007 14:25:16 -0800 (PST) Received: from roadrunner.q.local (localhost [127.0.0.1]) by roadrunner.q.local (8.13.8/8.13.8) with ESMTP id l0JH0D93007244; Fri, 19 Jan 2007 18:00:13 +0100 (CET) (envelope-from uspoerlein@gmail.com) Received: (from q@localhost) by roadrunner.q.local (8.13.8/8.13.8/Submit) id l0JH0ClQ007243; Fri, 19 Jan 2007 18:00:13 +0100 (CET) (envelope-from uspoerlein@gmail.com) Date: Fri, 19 Jan 2007 18:00:12 +0100 From: Ulrich Spoerlein To: Richard Message-ID: <20070119170012.GB1532@roadrunner.q.local> Mail-Followup-To: Richard , freebsd-stable@freebsd.org References: <1169038057.23831.24.camel@richard02> <20070117142552.GC1225@dkirhlarov.mow.oilspace.com> <1169044590.23831.38.camel@richard02> <45AE68DF.5010700@FreeBSD.org> <1169110278.20706.58.camel@chaffinch> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1169110278.20706.58.camel@chaffinch> 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 19 Jan 2007 22:25:19 -0000 Richard wrote: > > There is no need to make any changes to the script. Put whatever other > > options you want for mysql in rc.conf, and set the _enable variable > > to no. Then you can run /usr/local/etc/rc.d/mysql-server onestart and > > it will start normally just one time. > > Yes, and mysql will be started at bootup time on both nodes, wouldn't > it? So one node would fail miserably since the lack of mounted > diskspace... No, he wrote to set mysql_enable=NO, ie, the usual startup procedure will NOT start it. This doesn't work with heartbeat, however. heartbeat always calls the resource scripts with either 'start' or 'stop', you can't make it pass 'onestart'. Only two options remain: modify existing mysql-server script (bad idea, will be overwritten on update) or go through a proxy script which "transforms" start|stop -> onestart|onestop You could also alter the environment of heartbeat (it's really just a bunch of poorly written shell scripts) and set mysql_enable=YES there, but that'd be just as fragile as rewriting the existing mysql-server script. > But the "nostart"-solution sounds like working... Till you update the port and forget about your local modification ... Ulrich Spoerlein -- A: Yes. >Q: Are you sure? > >A: Because it reverses the logical flow of conversation. > >>Q: Why is top posting frowned upon?