On Tuesday 27 June 2006 10:22 am, Asif Lodhi wrote: > ALL I am asking is how strong you think MySQL stands up in such a > business scenario. I have even created the manual business procedures > for power-failure scenarios. I DO need to know HOW gracefully MySQL > will recover after each power failure or pull-the-plug situations.
I think you're going the wrong direction here. It's not about if MySQL will recover, it's if your system itself will recover. You can't just randomly take a bunch of abrupt power failures without a UPS system and expect things to be AOK. Even if MySQL recovers, what about your disks? Depending on how your filesystem does caching, your data loss could be the filesystem itself not commiting the data (take for example xfs, which does lots of caching and writes the data as minimal as possible). Either you invest in a UPS system to keep your things running until the generators kick in, or you pay more than that for data loss. -- Chris White PHP Programmer/DBrain Freeze Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]