On Thu, 24 Feb 2005 10:15:34 -0600, toru okada <[EMAIL PROTECTED]> wrote: > I can give you two good reasons. LiveJournal and Wikipedia. In the > past couple of months both of these websites went down due to power > issues in their coloco facilities. It took a bit of effort to bring > both of these sites back up because the database was in an > inconsistent state. Both sites lost data. I would not trust anything > of value in MySql.
Wow, what a load of FUD. Neither LiveJournal nor Wikipedia blame the outages on MySQL. For example, the livejournal developer blogged the details of what happened here -- http://www.livejournal.com/community/lj_dev/670215.html. Note that the core problem was that someone TURNED OFF THE POWER TO THE WHOLE COLO. Read through the details, they had hardware issues and configuration issues that they discovered as part of the process. And they only talk about the slow rebuild of the MyISAM indexes, which is a known tradeoff for large MyISAM tables (note also that they're running most of their tables in Innodb instead). I'm less familar w/ what went on with Wikipedia, but Jochem has a post in the thread here http://lists.mysql.com/mysql/180389 which is related to a possible underlying issue in the fsync() implementation in the 2.6 linux kernel (several online sites have mentioned that Wikipedia makes lots of use of the Fedora Core, which is a tradeoff between new features -- and related possibilty of bugs -- and stability/support of a RedHat Enterprise or Suse). Painting with broad strokes without a lot of information isn't real useful. Here's some more FUD... OH MY GOD! THERE ARE WORMS THAT CAN HIT SQL SERVER. Why would I ever trust my data to MS-SQL?!?!?!?? Of course you can trust MS-SQL -- it's a great database. I'd ask what kind of idiot leaves port 1433 open on a MS-SQL server in the first place (due to the number of infections with the various worms, apparently a lot)? The issue LiveJournal had with the disk cache for example, would likely have affected MS-SQL just as readily as MySQL. How about some counter examples about organizations that get a lot of value out of MySQL: Yahoo! (financial particularly, but also travel and others); Sabre (for clearing airline reservations); Cox Cable (for their customer data warehouse) Los Alamos (for terabytes of data) and yes, both Wikipedia and LiveJournal too -- read what they're saying before you write MySQL off because of a post on Slashdot... -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196323 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
