Triumphrat

Shawn

The database server that drives the majority of my critical databases kept running all day today but at an impaired state. On this site, the larger database tables ended up being locked; affecting primarily the forums on TriumphRat.Net.

Normally my mobile phone is paged when there are server issues, or loss of critical server applications. In this case, all of the applications continued to function, and the automated system never reported an issue. I run a customized *nix operating system on my servers that does great under extreme activity, but it actually never went down - so I was never called. That's technology for ya.

Anywho, after I got to my hotel and got settled (on the road visiting clients this week) I discovered the situation and resolved it in roughly 30 minutes.

To my knowledge, no data was lost. I didn't have to restore from backup, just repair several key database parts.

The cause was attributed to an automated backup routine that has outgrown it's usefulness. It's not necessarily because it's inferior but just can't handle the volume from this site any longer. TriumphRat.Net represents a significant amount of data and content. Managing the volume of data involved continues to be one of my top challenges.

The action items I'm going to implement won't be something anyone will notice here.

My apologies for the inconvenience.

__________________
Shawn
The Creator of TriumphRat.Net

iceman

...... thanks for the update Shawn.

I have read your description of what went wrong twice and my head is starting to spin - you are a clever cookie.

Thanks again for your good work - we certainly feel like something is missing when the site is down.

cheers, Grant

__________________
http://www.triumphrat.net/photogalle...790/album1051/

cafecruzin

thanks :-D but you lost me after The Data base server ............. :???:

__________________
Only Irish coffee provides in a single glass all four essential food groups:
alcohol, caffeine, sugar and fat..
Alex Levine
Of all the tyrannies that affect mankind, tyranny of religion is the worst.
"Thomas Paine"

steventhechef

Thanks for the update and maintenance Shawn,

but I'm with cafecruzin. I kept thinking "Mmmmm too deep for this little black Educk"

__________________
steventhechef

Eggs & Bacon. A day's work for a chicken, a lifetime commitment for a pig.

welshrob

So, the internet was broke?

__________________


"An unarmed man can only flee from evil and evil is not overcome by fleeing from it."

superfour

Thank you for the explanation.Even if I didn't understand it fully.

__________________
Currently riding a red ST 1050


Stuart

decobike

A day without ratnet is like a day without coffee. There I was at work all day with nothing to do. What's said here stays here right? Right? :

__________________

stevent

Uh...yeah, that's what I would have done too....back up the dashbord and prioritize the nexus port...then ummm re-align the server modum with the back-up data base...errr

Good job Shawn..(ahem)


:clap:

__________________
stevent....."May the Goddess turn the hearts of those who hate us, if not their hearts then turn their ankles so we'll know them by their limping..."

CAPTDON

Anytime my computer says "Error" I think its something I broke. Not this time! Good to see all back up & running!! :-D

__________________
CAPT D

walt

So if you give us your mobile phone number, Shawn, we'll ALL make sure that the next time the site so much as hiccups that you'll get called. :-D :roflmoa2: :hihi:

__________________
Walt, the guy on the Silver Thunderbird