From owner-freebsd-stable Wed Dec 4 18:39:51 2002 Delivered-To: freebsd-stable@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 47C7C37B401 for ; Wed, 4 Dec 2002 18:39:50 -0800 (PST) Received: from natto.numachi.com (natto.numachi.com [198.175.254.216]) by mx1.FreeBSD.org (Postfix) with SMTP id E100F43E9C for ; Wed, 4 Dec 2002 18:39:45 -0800 (PST) (envelope-from reichert@numachi.com) Received: (qmail 13246 invoked by uid 1001); 5 Dec 2002 02:39:38 -0000 Date: Wed, 4 Dec 2002 21:39:38 -0500 From: Brian Reichert To: Chatchawan Wongsiriprasert Cc: freebsd-stable@freebsd.org Subject: Re: Start deamon by cron Message-ID: <20021204213938.X413@numachi.com> References: <20021203013523.DAD5243E4A@mx1.FreeBSD.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5.1i In-Reply-To: <20021203013523.DAD5243E4A@mx1.FreeBSD.org>; from cws-freebsd-stable@hotel-accommodation.net on Mon, Dec 02, 2002 at 05:35:23PM -0800 Sender: owner-freebsd-stable@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Mon, Dec 02, 2002 at 05:35:23PM -0800, Chatchawan Wongsiriprasert wrote: > Does anyone have any experience start daemon process from cron?. > > I tried to stop my slave MySQL server every midnight for backup and the > restart the server after backup finished. > > Everything work fine except that the cron process always wait for mysql > daemon to die before sends the e-mail to me. So, the status report is > one-day delay + a zombie process (which will be cleanup next day). Why are you getting email at all? Why are you getting a zombie process? Why is there a one-day delay? I would think that it's straightforward to: mysqladmin shutdown backup however you see fit restart mysql I would think that, barring the speed of your backup, the whole thing should be done in a vew minutes. This begs the following issues, of course: - why not make use of MySQL's binary replication - don't use the stock MySQL toolchain, run mysqld, in the forground, via a watchdog program. I use DJB's daemontools myself. Good luck. > Chatchawan Wongsiriprasert -- Brian 'you Bastard' Reichert 37 Crystal Ave. #303 Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-stable" in the body of the message