On Thu, Feb 24, 2005 at 09:10:32AM -0500, Greg Whalin <[EMAIL PROTECTED]> wrote: > > Exactly. No ACID database can ensure integerity in such a situation. > Postgres, Oracle, or any other transactional DB would have suffered the > same fate in these two cases (LiveJournal, Wiki).
FWIW, my understanding of LiveJournal's integrity problem after the power outage involved tables they weren't yet able to migrate off of MyISAM, and getting replication content in all directions. The stuff migrated to InnoDB already came up fine. Their replication setup is a bit complex -- see http://www.danga.com/words/2004_mysqlcon/mysql-slides.pdf for an overview. (My kit at the same facility was hit too, and recovered correctly, for what it's worth. :-) At least this mailing list has progressed beyond "Why didn't they have a UPS?", I suppose. :-) -Rich -- Rich Lafferty --------------+----------------------------------------------- Ottawa, Ontario, Canada | Save the Pacific Northwest Tree Octopus! http://www.lafferty.ca/ | http://zapatopi.net/treeoctopus.html [EMAIL PROTECTED] -----------+----------------------------------------------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
