So, quick update here. The site was down for most of the night because the database cluster shot itself in the head. I had restarted a machine to install updates, and this caused the backend cluster to entire to entirely loose its mind. Unfortunately, I didn't have a manual dump of the database made, just a VM snapshot, since, well, I wasn't tinkering with it directly. I've mostly been trying to patch things to the point that I can sleep, and leaving things down like IRC and email which need to be seriously overhauled before they can go back up.
As far as damages go, it looks like we lost 10 or so days of messages, which uh, sucks for multiple reasons. We're currently on ##soylentnews on Libera.Chat while I pull bits of the site out of the flames, but I'm at the point that if I don't sleep, I will make things worse. Corruption in the production database is very much not what I wanted, and we're very much in limp mode for the moment. I'm going to let staff handle IRC and comments while I sleep, and then I'll post another update when I'm awake.
See you in a few hours
~ NCommander
(Score: 0) by Anonymous Coward on Sunday November 13 2022, @06:41AM (3 children)
Is your brain running on MySQL too? Has it lost info on the recent/regular noticeable data loss on SoylentNews?
If you store stuff in a real DB it won't get lost like that so easily.
There's no good reason to use MySQL other than "legacy" aka some fools made the wrong choice years ago and you're stuck with it.
(Score: 3, Funny) by janrinok on Sunday November 13 2022, @09:25AM (2 children)
What a load of rubbish. Have you bothered to find out why we lost data?
(Score: 0) by Anonymous Coward on Sunday November 13 2022, @10:44AM
(Score: 0) by Anonymous Coward on Sunday November 13 2022, @10:48AM
So what DB software is that DB cluster running?