Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
Site Downtime: Back up and running
Old 01-09-2009, 10:36 AM   #1
Moderator Emeritus
Martha's Avatar
 
Join Date: Feb 2004
Location: minnesota
Posts: 13,211
Site Downtime: Back up and running

Andy may post his own message, but according to Andy
late last night he had the server admins run some maintenance scripts on the slave database server which caused some issues. The crashed tables looks like they have now been repaired.

Don't ask me what this means.
__________________

__________________
.


No more lawyer stuff, no more political stuff, so no more CYA

Martha is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 01-09-2009, 10:38 AM   #2
Administrator
W2R's Avatar
 
Join Date: Jan 2007
Location: New Orleans
Posts: 34,653
Glad to hear (and find) that things are up and running again!
__________________

__________________
"You can never cross the ocean until you have the courage to lose sight of the shore." - - - C. Columbus
W2R is offline   Reply With Quote
Old 01-09-2009, 10:41 AM   #3
Administrator
Andy R's Avatar
 
Join Date: Jan 2007
Location: Dallas, Tx
Posts: 1,175
Here is the announcement I was going to post but Martha beat me to the punch.
I wanted to post and let you all know what the issue was and apologize for the inconvenience. Late last night I asked the server admins to perform some routing maintenance on the database. This was done very late at night when traffic to the site is at it's lowest. Although we experienced a couple glitches during the maintenance all seemed well when we checked the sites after it was done. Apparently at some point in the night a database table crashed and that caused the site not to load. We are looking into the reason this happened and hopefully will not have any more down time in the foreseeable future.

Once again my apologies for the down time and if you experience any errors or issues please report them here and we will address them ASAP.

Regards,

Andy
__________________
Lagom är bäst - Enough is as good as a feast - There is virtue in moderation
Andy R is offline   Reply With Quote
Old 01-09-2009, 10:42 AM   #4
Moderator Emeritus
Bestwifeever's Avatar
 
Join Date: Sep 2007
Posts: 15,320
Quote:
Originally Posted by Martha View Post
...Some maintenance scripts on the slave database server caused some issues. The crashed tables looks like they have now been repaired.
Sounds like a lot of work--so glad to be able to post again.

This is going to be my universal excuse for everything from now, by the way--
__________________
“Do act mysterious. It always keeps them coming back for more.”
Bestwifeever is offline   Reply With Quote
Old 01-09-2009, 11:01 AM   #5
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
TromboneAl's Avatar
 
Join Date: Jun 2006
Posts: 11,013
A rough morning for ER Forum posters.

__________________
Al
TromboneAl is offline   Reply With Quote
Old 01-09-2009, 11:06 AM   #6
Administrator
Andy R's Avatar
 
Join Date: Jan 2007
Location: Dallas, Tx
Posts: 1,175
Quote:
Originally Posted by Bestwifeever View Post
This is going to be my universal excuse for everything from now, by the way--
Haha, that's funny.

Quote:
Originally Posted by Martha View Post
Maybe you might want to just flesh out what I said.
Basically we run on a database technology that many websites use called MySQL. I have a setup known as a Master/Slave which uses the Master to write our posts to and the slave for searching and retrieving the content to display. This setup works well because hard drives are kind of like record players or CD players where a mechanism slides across to write or read data. With our setup one is focused on writing and one is focused on reading which provides better input/output speeds.

We had problems with one database table on the slave server so last night (during the slow time) I asked the server admins to run a repair/optimize routine on the slave server. This is like using the defragment feature of Windows which helps organize the data on the drive so it's more organized on the hard drive. It's only something that might be done once or twice a year on the slave but is done more often on the master.
__________________
Lagom är bäst - Enough is as good as a feast - There is virtue in moderation
Andy R is offline   Reply With Quote
Old 01-09-2009, 11:19 AM   #7
Administrator
Janet H's Avatar
 
Join Date: Feb 2007
Location: Pacific NW
Posts: 4,770
Quote:
Originally Posted by Andy R View Post
..... It's only something that might be done once or twice a year on the slave but is done more often on the master.
Once again, a slave gets the short end; irony noted.
__________________
E-R.org Custom Google Search | You're only given a little spark of madness. You mustn't lose it. (Robin Williams)
Janet H is offline   Reply With Quote
Old 01-09-2009, 12:51 PM   #8
Moderator Emeritus
Khan's Avatar
 
Join Date: Aug 2006
Location: Pine Island, Florida
Posts: 6,801
Send a message via AIM to Khan
Database errors give me flashbacks from w*rk.
__________________
"Knowin' no one nowhere's gonna miss us when we're gone..."
Khan is offline   Reply With Quote
Old 01-09-2009, 02:15 PM   #9
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Purron's Avatar
 
Join Date: Nov 2007
Posts: 5,585
T-Al, those pictures you posted look like some of the stock traders I've seen these days
__________________
I purr therefore I am.
Purron is offline   Reply With Quote
Old 01-09-2009, 02:17 PM   #10
Moderator
ziggy29's Avatar
 
Join Date: Oct 2005
Location: Texas
Posts: 15,404
Quote:
Originally Posted by Khan View Post
Database errors give me flashbacks from w*rk.
As someone who spent several years in hell providing on-call 24/7 tech support for Oracle database utilities -- including database recovery tools -- this puts me into a fetal position and makes me want my mommy.
__________________
"Hey, for every ten dollars, that's another hour that I have to be in the work place. That's an hour of my life. And my life is a very finite thing. I have only 'x' number of hours left before I'm dead. So how do I want to use these hours of my life? Do I want to use them just spending it on more crap and more stuff, or do I want to start getting a handle on it and using my life more intelligently?" -- Joe Dominguez (1938 - 1997)
ziggy29 is offline   Reply With Quote
Old 01-09-2009, 02:29 PM   #11
Moderator
bssc's Avatar
 
Join Date: Dec 2005
Posts: 9,085
SQL stands for Squirrley query language
__________________

__________________
Angels danced on the day that you were born.
bssc is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
My COBRA is running out soon JDConnell Health and Early Retirement 26 01-14-2009 08:01 AM
Downtime Notice (Wednesday Night) Andy R Forum Admin 4 08-01-2007 09:20 PM
running a guesthouse claire Life after FIRE 16 04-28-2006 02:26 PM

 

 
All times are GMT -6. The time now is 11:00 PM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2016, vBulletin Solutions, Inc.