Notice to all Buzzboard readers & posters: A requested server migration took place Saturday evening. Unfortunately, I did not re-point my DNS records to the new server until roughly 7:45p ET on Monday, November 12. As a result, any posts and new user registrations occurring between the nighttime hours of 11/10 and approximately 7:45p ET on Monday, 11/12 have been lost.

This was unavoidable, and the longer I waited to re-point to the new server, the greater the number of posts that would've been lost.

Please feel free to resubmit any threads / posts you created. They will NOT be lost this time! Many thanks for your patience these past couple of weeks while I've worked to migrate the Buzzboard to a more secure, more robust platform.

Check out the Buzzboard's newest forum - the Buzzboard Marketplace! Find it here: http://www.mibuzzboard.com/phpBB3/viewforum.php?f=31

Preventative steps I've taken to prevent another massive loss of thread & post data

Got a question? Can't figure out how to get that neat picture under your user name? Need any other tech tips? Post it here! Also, this is where I make important site related announcements.
User avatar
MWmetalhead
Site Admin
Posts: 3315
Joined: Sun Oct 31, 2004 11:23 am

Preventative steps I've taken to prevent another massive loss of thread & post data

Post by MWmetalhead » Sat Nov 03, 2018 11:30 am

Hello.

As you may already be aware, this site experienced a massive DB failure sometime in the early morning hours of Monday, October 29. Each & every SQL database table crashed and was unable to be repaired. (I spent over an hour on chat with my hosting company as they attempted to repair the database.)

Sadly, being the unprepared dumbass that I am, I learned the hard way that my hosting company was no longer automatically backing up my site (including the DB) on a daily basis. I am not sure if this was due to my site in particular growing too large or the aggregate of sites hosted on the same virtual private server growing too large. All I know is that there is a 10 GB file size limit, and once that threshold is crossed, automatic daily backups cease.

So, the best I could do was upload a database backup file from February 21, 2017 - the last one I had saved to my personal PC - and restart from there!

I am serious about taking action to ensure such an occurrence never happens again!

To that end, I have taken the following steps:
- I have modified my WHM configuration to allow for overnight daily backup of the full database.
- These backups will be saved to not just one, but two (!!!) different Cloud server locations.
- I have modified my registration anti-spam "challenge" question and will now do this on a routine basis in an effort to prevent spambots from successfully registering accounts.
- I will now be checking the registration queue daily (barring extenuating circumstances).
- I have enrolled the Buzzboard in CloudFare, which provides a number of utilities designed to improve the user experience and provide enhanced protection from security threats. I will be blocking ALL traffic from Russia.

Your patronage is highly appreciated! Thank you for making the Buzzboard the #1 outlet for media discussion in Michigan! I welcome any additional suggestions you may have; feel free to post them here.

Regards,

M.W.


Thanks, corporate radio, for finally tossing Nickelback to the curb. Now can you please do the same for Shinedown? THEY SUCK!!!

Post Reply Previous topicNext topic