Craig Posted May 21, 2018 Report Share Posted May 21, 2018 Greetings all, Due to an error on my part during the server migration that took place back in February, I’m required to perform a task that will take the forum offline for a few hours. For transparency, the error was ignoring an alert with regards to a Cronjob that was not working on the forum; as a result, the forum database grew and consumed a large portion of diskspace. The Cronjob was subsequently fixed, however due to the way in which the SQL DB works out of the box on Linux, the disk space cannot be reclaimed, this in turn has lead to automated backups failing. To reclaim the disk space and allow the automated backups to complete successfully, I am required to delete all SQL DB’s on the server, uninstall SQL, then perform a SQL install and recover the DB’s (I am able to perform manual backups of the SQL DB’s). All very simple on paper and should be completed within 30 minutes. However, I’m going to plan for this not going according to plan, so please allow 3 hours of downtime with a website that doesn’t look all too nice, and maybe results in a timeout. Rest assured, any outage will be due to my work, and I’ll be actively working on it! I won’t give any times for when I’ll commence work, that will be dictated by the amount of homebrew consumed the day before! Craig Quote Link to comment Share on other sites More sharing options...
AlanHo Posted May 21, 2018 Report Share Posted May 21, 2018 We need you sober for that job - not that I understood much of it. All the best - it's a pity you have to do all that work. Quote Link to comment Share on other sites More sharing options...
Belatucadrus Posted May 21, 2018 Report Share Posted May 21, 2018 We had a SQL problem this afternoon, a Grey SQL, little bugger got in through the window then couldn't find his way out. Quote Link to comment Share on other sites More sharing options...
Irene Posted May 21, 2018 Report Share Posted May 21, 2018 Thanks for the warning Craig, I'll add it to my Outlook Diary. Quote Link to comment Share on other sites More sharing options...
Gandalph Posted May 22, 2018 Report Share Posted May 22, 2018 While you are at it Craig, I have always fancied an SQL DB so if you come across one that is not doing anything we could negotiate a price for it. Quote Link to comment Share on other sites More sharing options...
andsome Posted May 22, 2018 Report Share Posted May 22, 2018 I am mystified Quote Link to comment Share on other sites More sharing options...
Craig Posted May 22, 2018 Author Report Share Posted May 22, 2018 Great news! I tested the plan, it didn't work, however I did fail back to my 3 hour option that resulted in a server migration that has completed successfully! So, here we are on the forum, on a freshly installed server, minus my disk space issue. I've got 3 spare hours at the weekend now! Craig Quote Link to comment Share on other sites More sharing options...
AlanHo Posted May 22, 2018 Report Share Posted May 22, 2018 Craig - congratulations - now invite us all round for some home brew to celebrate your success. That will fill in the 3 hours you gained. Quote Link to comment Share on other sites More sharing options...
Gandalph Posted May 22, 2018 Report Share Posted May 22, 2018 Well done that man. Make mine a pint. Quote Link to comment Share on other sites More sharing options...
Boris Posted May 22, 2018 Report Share Posted May 22, 2018 Definitely quicker now ! Thanks. Quote Link to comment Share on other sites More sharing options...
andsome Posted May 22, 2018 Report Share Posted May 22, 2018 1 hour ago, Gandalph said: Well done that man. Make mine a pint. Make mine two Quote Link to comment Share on other sites More sharing options...
catgate Posted May 22, 2018 Report Share Posted May 22, 2018 Forum Maintenance 27th May 2018 By Craig, Yesterday at 06:55 PM in Windows Forum Related My calender tells me that it is not 27th May for a few more days yet! (Unless it is two other fellows). Quote Link to comment Share on other sites More sharing options...
Irene Posted May 23, 2018 Report Share Posted May 23, 2018 Wow! The forum is amazingly fast now! Craig, it is Quote Link to comment Share on other sites More sharing options...
andsome Posted May 23, 2018 Report Share Posted May 23, 2018 Thirty five M.P. H Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.