Re: Data corruption following a power failure.

[James Moe]

Andrew Iles wrote:
 
Is this the true behavior or does it just appear to work this way? And if
so, is there any way to force MySQL to automatically save data to disk in a
way that is chronologically correct? This would make it much easier for me
to recover from an unexpected crash.
 
  What os/version?
  What mysql version?
1. Invest in a UPS (Uninterruptable Power Supply) to greatly reduce the 
problems with random power loss.
2. Periodically run fsync to flush the filesystem cache to disk.
3. Use a transaction/journaled database (innodb).
4. Use a transaction/journaled filesystem (jfs, xfs).

--
jimoe at sohnen-moe dot com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]