List:General Discussion« Previous MessageNext Message »
From:Rich Lafferty Date:February 24 2005 3:17pm
Subject:Re: wikipedia down, slashdot covering, mysql mentioned
View as plain text  
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 mentionedScott Haneda22 Feb
  • Re: wikipedia down, slashdot covering, mysql mentionedDebugasRu22 Feb
  • Re: wikipedia down, slashdot covering, mysql mentionedPeter Wilm22 Feb
  • Re: wikipedia down, slashdot covering, mysql mentionedDaniel Kasak22 Feb
    • Re: wikipedia down, slashdot covering, mysql mentionedGreg Whalin22 Feb
      • Re: wikipedia down, slashdot covering, mysql mentionedDaniel Kasak22 Feb
        • Re: wikipedia down, slashdot covering, mysql mentionedGreg Whalin23 Feb
        • Re: wikipedia down, slashdot covering, mysql mentionedDebugasRu24 Feb
          • Re: wikipedia down, slashdot covering, mysql mentionedRich Lafferty24 Feb
            • Re: wikipedia down, slashdot covering, mysql mentionedGreg Whalin24 Feb
              • Re: wikipedia down, slashdot covering, mysql mentionedRich Lafferty24 Feb
                • Re: wikipedia down, slashdot covering, mysql mentionedGreg Whalin24 Feb
              • Re[2]: wikipedia down, slashdot covering, mysql mentionedDebugasRu24 Feb
Re: wikipedia down, slashdot covering, mysql mentionedHeikki Tuuri22 Feb
  • Re: wikipedia down, slashdot covering, mysql mentionedGreg Whalin22 Feb
  • Re: wikipedia down, slashdot covering, mysql mentionedJochem van Dieten23 Feb
Re: wikipedia down, slashdot covering, mysql mentionedHeikki Tuuri23 Feb
Re: wikipedia down, slashdot covering, mysql mentionedHeikki Tuuri23 Feb
Re: wikipedia down, slashdot covering, mysql mentionedHeikki Tuuri23 Feb