From owner-freebsd-questions@FreeBSD.ORG Fri Dec 18 18:19:23 2009 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 723FB106566C for ; Fri, 18 Dec 2009 18:19:23 +0000 (UTC) (envelope-from perrin@apotheon.com) Received: from outbound-mail-155.bluehost.com (outbound-mail-155.bluehost.com [67.222.39.35]) by mx1.freebsd.org (Postfix) with SMTP id 41A158FC1C for ; Fri, 18 Dec 2009 18:19:22 +0000 (UTC) Received: (qmail 21580 invoked by uid 0); 18 Dec 2009 18:19:22 -0000 Received: from unknown (HELO box543.bluehost.com) (74.220.219.143) by outboundproxy5.bluehost.com with SMTP; 18 Dec 2009 18:19:22 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=apotheon.com; h=Date:From:To:Subject:Message-ID:Mail-Followup-To:References:Mime-Version:Content-Type:Content-Disposition:In-Reply-To:User-Agent:X-Identified-User; b=YL/CDpWtcrtLIA2RxZUxbYW1PshY26yCsAZwgVXv3O3W8oHWa26mcQH2pVrPgg+rRdAlBm3NUlF0k0o6tQGVY+OVxUlb/9ahjoT28bzdHB6hEk8J2HZpI4NqwyrnejG9; Received: from c-24-8-180-234.hsd1.co.comcast.net ([24.8.180.234] helo=kukaburra.hydra) by box543.bluehost.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1NLhQ9-0005x8-2G for freebsd-questions@freebsd.org; Fri, 18 Dec 2009 11:19:22 -0700 Received: by kukaburra.hydra (sSMTP sendmail emulation); Fri, 18 Dec 2009 11:12:04 -0700 Date: Fri, 18 Dec 2009 11:12:04 -0700 From: Chad Perrin To: freebsd-questions@freebsd.org Message-ID: <20091218181204.GB98208@guilt.hydra> Mail-Followup-To: freebsd-questions@freebsd.org References: <4B1DF953.4050504@sprinthost.ru> <4B1E2D40.9060900@sprinthost.ru> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="BwCQnh7xodEAoBMC" Content-Disposition: inline In-Reply-To: <4B1E2D40.9060900@sprinthost.ru> User-Agent: Mutt/1.4.2.3i X-Identified-User: {2737:box543.bluehost.com:apotheon:apotheon.org} {sentby:smtp auth 24.8.180.234 authed with ren@apotheon.org} Subject: Re: FreeBSD is too filesystem errors sensitive X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 18 Dec 2009 18:19:23 -0000 --BwCQnh7xodEAoBMC Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Dec 08, 2009 at 01:41:04PM +0300, cronfy wrote: >=20 > After panic data *is* getting corrupted anyway - MySQL tables that were= =20 > open are broken, soft-updates are unsync'ed etc etc. By the way, you might want to look into using a DBMS that (unlike MySQL) doesn't hose up open tables because of a power failure or kernel panic. Choose something ACID-compliant like PostgreSQL if you fear data loss. There are evidently a couple of storage engines for MySQL that also provide much the same safety for your data, too, but you can't just settle for the default and hope that's good enough. If it's an option for you, you may want to look into disabling soft updates as well so that you don't have to just hope that everything gets synced before the end of the world. Depending on your usage, however, this might result in unacceptably poor performance. --=20 Chad Perrin [ original content licensed OWL: http://owl.apotheon.org ] --BwCQnh7xodEAoBMC Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.13 (FreeBSD) iEYEARECAAYFAksrxfQACgkQ9mn/Pj01uKWe9QCcCxVEBjcfz8IxVKNjOCFODnQ5 Vw8AnjiMdYeNy4nbAHzE8WH+Rp1FL6G2 =YTbY -----END PGP SIGNATURE----- --BwCQnh7xodEAoBMC--