--pgp-sign-Multipart_Mon_Sep__4_23:53:03_2006-1
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

At Tue, 22 Aug 2006 14:30:16 -0700,
Chuck Swiger wrote:
>=20
> For the most part, filesystem snapshots have worked pretty well under =20
> a bunch of cases on FreeBSD; the example of using dump/restore is a =20
> good one, also for trying to obtain a more consistent file-level =20
> backup of an active database, and so forth.

Unless you've done something to integrate some kind of consistency
flush/halt feature into your database software there's no guarantee of a
consistent file or file-system level backup of any active database,
especially not if you're talking about anything more sophisticated than
a flat text files maintained with awk and join et al.  You must still
stop your database completely to ensure that any data still cached in in
any process is flushed and the file-level data is 100% consistent.  Of
course with using filesystem snapshots the database downtime that is
necessary is far shorter than without that feature -- almost
unnoticeable for many types of DB applications.

--=20
						Greg A. Woods

H:+1 416 218-0098 W:+1 416 489-5852 x122 VE3TCP RoboHack <woods@robohack.ca>
Planix, Inc. <woods@planix.com>       Secrets of the Weird <woods@weird.com>

--pgp-sign-Multipart_Mon_Sep__4_23:53:03_2006-1
Content-Type: application/pgp-signature
Content-Transfer-Encoding: 7bit

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 5.0i for non-commercial use
MessageID: AAbGeCEbcy8EBx0o5JLCW55ZvDWopnxO

iQA/AwUBRPz0omJ7XxTCWceFEQKCtgCgonqdIbkFB7rBRZdDZxLbKvKO/48AnRn2
BHJOUNO2WMdpl2LBHsKUgmMa
=oSvn
-----END PGP SIGNATURE-----

--pgp-sign-Multipart_Mon_Sep__4_23:53:03_2006-1--