On Thu, Feb 24, 2005 at 09:10:32AM -0500, Greg Whalin <gwhalin@stripped> 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
rich@stripped -----------+-----------------------------------------------
| Thread |
|---|
| • wikipedia down, slashdot covering, mysql mentioned | Scott Haneda | 22 Feb |
| • Re: wikipedia down, slashdot covering, mysql mentioned | DebugasRu | 22 Feb |
| • Re: wikipedia down, slashdot covering, mysql mentioned | Peter Wilm | 22 Feb |
| • Re: wikipedia down, slashdot covering, mysql mentioned | Daniel Kasak | 22 Feb |
| • Re: wikipedia down, slashdot covering, mysql mentioned | Greg Whalin | 22 Feb |
| • Re: wikipedia down, slashdot covering, mysql mentioned | Daniel Kasak | 22 Feb |
| • Re: wikipedia down, slashdot covering, mysql mentioned | Greg Whalin | 23 Feb |
| • Re: wikipedia down, slashdot covering, mysql mentioned | DebugasRu | 24 Feb |
| • Re: wikipedia down, slashdot covering, mysql mentioned | Rich Lafferty | 24 Feb |
| • Re: wikipedia down, slashdot covering, mysql mentioned | Greg Whalin | 24 Feb |
| • Re: wikipedia down, slashdot covering, mysql mentioned | Rich Lafferty | 24 Feb |
| • Re: wikipedia down, slashdot covering, mysql mentioned | Greg Whalin | 24 Feb |
| • Re[2]: wikipedia down, slashdot covering, mysql mentioned | DebugasRu | 24 Feb |
| • Re: wikipedia down, slashdot covering, mysql mentioned | Heikki Tuuri | 22 Feb |
| • Re: wikipedia down, slashdot covering, mysql mentioned | Greg Whalin | 22 Feb |
| • Re: wikipedia down, slashdot covering, mysql mentioned | Jochem van Dieten | 23 Feb |
| • Re: wikipedia down, slashdot covering, mysql mentioned | Heikki Tuuri | 23 Feb |
| • Re: wikipedia down, slashdot covering, mysql mentioned | Heikki Tuuri | 23 Feb |
| • Re: wikipedia down, slashdot covering, mysql mentioned | Heikki Tuuri | 23 Feb |