Steve Wolfe <nw(at)codon(dot)com> writes:
> I've run with fsync off on my production servers for years. Power never
> goes off, and RAID 5 protects me from disk failures. Sooner or later, it may
> bite me in the butt. We make backups sufficiently often that the small amount
> of data we'll lose will be far offset by the tremendous performance boost that
> we've enjoyed. In fact, we even have a backup server sitting there doing
> nothing, which can take over the duties of the main DB server within a VERY
> short amount of time.
That's good, because you'll eventually need it.
All it will take will be a Linux crash for the database files on disk to
become corrupted. No amount of UPS or RAID protection will protect from that.
--
greg