FORUM IS BACK ON-LINE AGAIN!
Posted: Mon, 2020-Oct-26, 20:27
AAAARGHHH!!!! Gremlins in the system....
Yesterday, the Forum server decided to take a vacation, and powered itself down for no good reason
... And in doing so, it corrupted the "sessions" data base.... so badly, in fact, that I couldn't even get in myself! Not even through the data-base control panel.... I'm no expert on MySQL, so I had to do some learning on how to repair data-bases manually. Fortunately, it wasn't too hard in the end, and everything recovered, with no data loss! 
Sorry about the down-time, but I really didn't want to re-load the previous backup, as that would have lost a whole bunch of posts and messages, so it was better to do the "repair" instead (The forum is backed up several times per day, but quite a few hours had elapsed between the last backup and the system crash....)
Anyway, the good news is that we are back up and running, without any data missing!
The bad news, is that we were down for nearly an entire day....
.... and the badder news (for me!) is that I need to do some more learning about MySQL.... So I can fix things more quickly next time.
I'm also working on adding an entire new backup server, that should take over automatically in the event the main one takes another vacation, but that's gonna take a little while....
Best regards,
Stuart
Yesterday, the Forum server decided to take a vacation, and powered itself down for no good reason
... And in doing so, it corrupted the "sessions" data base.... so badly, in fact, that I couldn't even get in myself! Not even through the data-base control panel.... I'm no expert on MySQL, so I had to do some learning on how to repair data-bases manually. Fortunately, it wasn't too hard in the end, and everything recovered, with no data loss! Sorry about the down-time, but I really didn't want to re-load the previous backup, as that would have lost a whole bunch of posts and messages, so it was better to do the "repair" instead (The forum is backed up several times per day, but quite a few hours had elapsed between the last backup and the system crash....)
Anyway, the good news is that we are back up and running, without any data missing!
The bad news, is that we were down for nearly an entire day....
.... and the badder news (for me!) is that I need to do some more learning about MySQL.... So I can fix things more quickly next time.I'm also working on adding an entire new backup server, that should take over automatically in the event the main one takes another vacation, but that's gonna take a little while....
Best regards,
Stuart
