On 26 Oct 2005, at 19:43, snacktime wrote:
I remember a few months back when someone hit the emergency power
switch to the whole floor where we host at Internap. Subsequently
the backup power system had a cascading failure. Livejournal, who
also hosts there, was up all night and into the next day restoring
their mysql databases after a bunch of them were corrupted. I
believe they had write cache turned on.
Of course our postgresql servers on scsi drives came right back
up. If it wasn't for a couple of servers that won't reboot
automatically if the power goes out I wouldn't have even had to go
down to the data center.
Chris
I don't know about this you know. Power failures can cause seriously
random failures on most PC hardware. A few weeks ago we had a RAID 1
(fsync on, caching off, battery backed raid controller etc) system
get it's RAID partitions gets totally fried by a power failure. My
suspicion is that if the power failure isn't a particularly fast one,
(e.g. you overloaded a fuse somewhere, fuses are insanely slow to
fail compared to alternatives like MCBs) then your RAID card's RAM
will get corrupted as the voltage drops or the system memory will
resulting in bad data getting copied to the RAID controller as RAM
seems to be pretty sensitive to voltage variations in experiments
i've done on my insanely tweak-able desktop at home. I would of
though ECC probably helps, but it can only correct so much.
Of course I'm not an electrical engineer (although my friend is a
member of IEEE and he seemed to agree it was a possibility) doesn't
the possibility of this kinda make things a bit more complicated and/
or expensive to maintain data integrity during a power failure?
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
