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
- Re: [GENERAL] Why database is corrupted after re-booting snacktime
- Re: [GENERAL] Why database is corrupted after re-bo... Bricklen Anderson
- Re: [GENERAL] Why database is corrupted after re-bo... Alex Stapleton
- Re: [GENERAL] Why database is corrupted after r... Tom Lane
- Re: [GENERAL] Why database is corrupted aft... Alex Stapleton
- Re: [GENERAL] Why database is corrupted... Tom Lane
- Re: [GENERAL] Why database is corr... Alex Stapleton
- Re: [GENERAL] Why database is corrupted aft... Keith C. Perry
- Re: [GENERAL] Why database is corrupted... Scott Marlowe
- Re: [GENERAL] Why database is corrupted... w_tom
- Re: [GENERAL] Why database is corr... Ron Mayer