FreeBSD is too filesystem errors sensitive

[Chad Perrin]

On Tue, Dec 08, 2009 at 01:41:04PM +0300, cronfy wrote:
> 
> After panic data *is* getting corrupted anyway - MySQL tables that were 
> 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.

-- 
Chad Perrin [ original content licensed OWL: http://owl.apotheon.org ]
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 196 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20091218/df7480a5/attachment.pgp