From owner-freebsd-fs@FreeBSD.ORG Thu Mar 26 15:53:51 2009 Return-Path: Delivered-To: fs@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id F401E106564A; Thu, 26 Mar 2009 15:53:50 +0000 (UTC) (envelope-from scode@hyperion.scode.org) Received: from hyperion.scode.org (cl-1361.ams-04.nl.sixxs.net [IPv6:2001:960:2:550::2]) by mx1.freebsd.org (Postfix) with ESMTP id AEB8B8FC1F; Thu, 26 Mar 2009 15:53:50 +0000 (UTC) (envelope-from scode@hyperion.scode.org) Received: by hyperion.scode.org (Postfix, from userid 1001) id D5CBF23C4E9; Thu, 26 Mar 2009 16:53:49 +0100 (CET) Date: Thu, 26 Mar 2009 16:53:49 +0100 From: Peter Schuller To: Karl Denninger Message-ID: <20090326155349.GA47932@hyperion.scode.org> References: <49C83673.3000604@aldan.algebra.com> <200903251820.54749.doconnor@gsoft.com.au> <200903251925.36108.doconnor@gsoft.com.au> <3.0.1.32.20090325072137.00ee6b48@sage-american.com> <3.0.1.32.20090326065337.00f081e0@sage-american.com> <3.0.1.32.20090326070807.00f081e0@sage-american.com> <200903261331.n2QDVd4b038485@lava.sentex.ca> <20090326140131.GA45201@hyperion.scode.org> <49CBA34B.9070708@denninger.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="azLHFNyN32YCQGCU" Content-Disposition: inline In-Reply-To: <49CBA34B.9070708@denninger.net> User-Agent: Mutt/1.5.19 (2009-01-05) Cc: "Jack L. Stone" , freebsd-stable@freebsd.org, fs@freebsd.org Subject: Re: support quality (Re: dump | restore fails: unknown tape headertype 1853384566) X-BeenThere: freebsd-fs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Filesystems List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 26 Mar 2009 15:53:51 -0000 --azLHFNyN32YCQGCU Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable > However, whether either of these approaches is sufficient is another=20 > matter. One of the real problems with live transaction processing=20 > systems is a means to know when there is a failure exactly what you=20 > lost. This is not a trivial problem to solve and requires plenty of=20 > thought before implementation, especially if you cannot afford the=20 > outage time necessary to take the snapshots - in some cases even that=20 > (relatively) short outage time is unacceptable. I would like to point out that if the backup strategy is correct, a COMMIT is guaranteed to be correctly honored, and the problem of determining what was lost has more to do with the birds-eye view of to what point in time the database was reverted as part of emergency recovery, than any difficulty in understanding what actually happens during snapshot recovery. I completely understand that you have various requirements in production that makes it a non-solution to just get a consistent snapshot at some arbitrary point in time without synchronizing with other software components somehow, but such issuse are into the realm of application design and integration with the backup procedure, and we are no longer talking about the viability of obtaining a consistent backup of a single database through snapshotting. --=20 / Peter Schuller PGP userID: 0xE9758B7D or 'Peter Schuller ' Key retrieval: Send an E-Mail to getpgpkey@scode.org E-Mail: peter.schuller@infidyne.com Web: http://www.scode.org --azLHFNyN32YCQGCU Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.11 (FreeBSD) iEYEARECAAYFAknLpQ0ACgkQDNor2+l1i31CzQCg5UoDaK/ztD4cfo0QV+NkpFfX uaUAnjhT2maKRMhWwSQ8XZMUOMPrMhdh =jjGC -----END PGP SIGNATURE----- --azLHFNyN32YCQGCU--