From owner-freebsd-database@FreeBSD.ORG  Fri Sep 15 15:26:04 2006
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
X-Original-To: freebsd-database@freebsd.org
Delivered-To: freebsd-database@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 6568916A47B
	for <freebsd-database@freebsd.org>;
	Fri, 15 Sep 2006 15:26:04 +0000 (UTC)
	(envelope-from glenn@mail.more.net)
Received: from libby.lpmo.org (libby.lpmo.org [216.106.2.138])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 36AA243D53
	for <freebsd-database@freebsd.org>;
	Fri, 15 Sep 2006 15:26:03 +0000 (GMT)
	(envelope-from glenn@mail.more.net)
Received: from gkar.earthdome.org (92.mnetw.more.net [207.160.138.92])
	by libby.lpmo.org (Postfix) with ESMTP id E973E28430
	for <freebsd-database@freebsd.org>;
	Fri, 15 Sep 2006 10:18:16 -0500 (CDT)
Received: by gkar.earthdome.org (Postfix, from userid 503)
	id 68F55774581; Fri, 15 Sep 2006 10:24:05 -0500 (CDT)
Date: Fri, 15 Sep 2006 10:24:05 -0500
From: Glenn Nielsen <glenn@mail.more.net>
To: freebsd-database@freebsd.org
Message-ID: <20060915152405.GD8776@gkar.earthdome.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.4.2.2i
Subject: MySQL and FS softupdates
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 15 Sep 2006 15:26:04 -0000

I recently had a server running a MySQL master db lose power. When
the server came back up the mysql binary log used for replication
was missing the last 7-8 minutes of database changes.

FS softupdates are being used.

Are softupdates a good thing, a bad thing, or make no difference
for recovery of a mysql database after a server failure?

Thanks,

Glenn

----------------------------------------------------------------------
Glenn Nielsen             glenn@more.net | /* Spelin donut madder    |
MOREnet System Programming               |  * if iz ina coment.      |
Missouri Research and Education Network  |  */                       |
----------------------------------------------------------------------