Re: wikipedia down, slashdot covering, mysql mentioned

[Daniel Kasak]

Scott Haneda wrote:

>There is a thread over at /. about WikiMedia being out due to a power outage
><http://slashdot.org/articles/05/02/22/0151213.shtml?tid=95>
>
>MySql is getting bashed pretty hard in some cases as apparently, in power
>failures, you get database corruption.  (this is all from the posts, not my
>opinion at all, I am asking only to learn more) Also, it is mentioned the
>MySql devs just do not have data corruption from power failure a high
>priority.
>
>Many are leaning on Postgres.  For me, MySql has never let me down (Knock on
>PSU) but I have to ask, for more data on this matter.  I run MySql on OS X,
>I sometimes have to reboot, it comes back up fine, I do however, do nothing
>special to shut down mysql, should I be?
>  
>
There are certainly some people who have nothing better to do than 
preach the benefits of Postgres over MySQL on Slashdot.
The simple fact is that no matter how fancy your software is, if your 
computer experiences a power outage, you can't *insist* that one 
particular application somehow protect your data from the fate of 
everything else on your computer.

We have a UPS connected to our 2 servers. The Linux server is running 
apcupsd and controlling the Win2k server ( also running apcupsd in slave 
mode ). Both servers are connected via a crossover cable to each other ( 
so we don't have to put the network switches on the UPS ).

If WikiMedia can't implement something at least as good as the above, 
then how can they or anyone else point the finger at MySQL for data 
corruption? The mind boggles over what they expect.

Having said that, our MySQL server has experienced a power 'issue' ( my 
boss tripped over the power cord coming from the UPS ). We both turned 
white :) But MySQL started up OK, rolled back a transaction or 2, and 
continued on it's way.

There's nothing like a UPS though. Or better yet, a UPS, daily backups, 
and a transaction log.

-- 
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: ([phone] / F: ([phone]
email: dkasak@stripped
website: http://www.nusconsulting.com.au