Chris White wrote:
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.
And that becomes a question of what kind of file system your using
and is it Windows or Unix or Max. Since we know nothing about this there
is no answer. Please tell us what operating system your using. For
example the Linux EXT3 file system is very tolerant of sudden power
failures.
Karl
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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]