menyak tripping over the cable... - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to General Talk

menyak tripping over the cable...

Moderator: Baseball Moderators

menyak tripping over the cable...

Postby menyak » Wed Oct 15, 2003 8:46 am

Sorry everyone for the lengthy downtime yesterday! Yesterday was one of the days where simply nothing worked together. A seemingly harmless routine update led to a database crash, then the webmeister didn't react fast enough (what a jerk! ;) ) and in the end the datacenter overlooked the trouble ticket.

Hope I learned a lesson from that and can make a few improvements that will make a similar incident less likely or hopefully even impossible.
"Never argue with an idiot. People won't know who's who."
menyak Beginner
General Manager
General Manager

User avatar
WebmasterCafeholicCafe WriterGraphics ExpertEagle EyeInnovative MemberWeb SupporterPick 3 Weekly Winner
Posts: 3050
(Past Year: 2)
Joined: 4 Jan 2002
Home Cafe: Football
Location: Offline on even days

Postby Mad'sWife » Wed Oct 15, 2003 9:11 am

A suggestion for 0 future down time.

If you were able to use another server you could use any of a veriety of replication and failover software.

I am accustomed to doubletake for one. You could always use an alias for the second server so if one goes down noone will notice.

I do know that this is costly and may not be an option.
Mad'sWife
College Coach
College Coach

User avatar

Posts: 294
Joined: 15 Oct 2003
Home Cafe: Baseball
Location: Fort Worth Tx

Postby menyak » Wed Oct 15, 2003 9:43 am

We might take that road if we need the bandwidth of two servers, but for now it's really a financial thing and also a technical one. I already have a steep learning curve behind me, but before every detail of the single server has become boring routine, setting up a system like that would probably just _increase_ the risk of downtime. ;-)

Anyway, it's good to know you have experience with that - when the time arrives, I'll probably need some advice and moral support...
"Never argue with an idiot. People won't know who's who."
menyak Beginner
General Manager
General Manager

User avatar
WebmasterCafeholicCafe WriterGraphics ExpertEagle EyeInnovative MemberWeb SupporterPick 3 Weekly Winner
Posts: 3050
(Past Year: 2)
Joined: 4 Jan 2002
Home Cafe: Football
Location: Offline on even days

Postby Madison » Wed Oct 15, 2003 9:46 am

Well glad we are back up and running. :-) ;-D
Yes doctor, I am sick.
Sick of those who are spineless.
Sick of those who feel self-entitled.
Sick of those who are hypocrites.
Yes doctor, an army is forming.
Yes doctor, there will be a war.
Yes doctor, there will be blood.....
Madison
Mod in Retirement
Mod in Retirement

User avatar
ExecutiveEditorCafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe SpotterInnovative MemberCafe MusketeerPick 3 ChampionMatchup Meltdown SurvivorLucky Ladders Weekly Winner
Posts: 53856
(Past Year: 1)
Joined: 29 Apr 2003
Home Cafe: Baseball
Location: Taking Souls...

Postby Mad'sWife » Wed Oct 15, 2003 9:58 am

Definatly glad we are back up and running.

This is the feild I work in and would not mind helping if I can.

Feel free to ask me any questions. ;-D
Mad'sWife
College Coach
College Coach

User avatar

Posts: 294
Joined: 15 Oct 2003
Home Cafe: Baseball
Location: Fort Worth Tx

Postby menyak » Wed Oct 15, 2003 10:34 am

Mad'sWife wrote:Feel free to ask me any questions. ;-D

Ok. :-) Isn't setting up a redundant system with a database involved extremely complicated? With static pages it shouldn't be a biggie, but for mirroring a forum database both servers would need to be in sync virutally every given second. Also wondering if syncing those databases wouldn't cause a lot of extra traffic. The vast majority of stuff I've seen on the net is splitting it up into a main and a database server...
"Never argue with an idiot. People won't know who's who."
menyak Beginner
General Manager
General Manager

User avatar
WebmasterCafeholicCafe WriterGraphics ExpertEagle EyeInnovative MemberWeb SupporterPick 3 Weekly Winner
Posts: 3050
(Past Year: 2)
Joined: 4 Jan 2002
Home Cafe: Football
Location: Offline on even days

Postby Mad'sWife » Wed Oct 15, 2003 11:45 am

We actually have several servers in our production environment that are both web servers and databse servers. Doubletake the software I mentioned before replicates both os and database.

There is also a simpler solution but will not give you 100% up time. Backing up the server including database via tape, disk, or flat file backup to tape or disk is also a solution.

You can back everything up prior to update or upgrade and if something goes wrong you can restore to the point in time just prior to update.

These are just some suggestions. All new software you are not familiar with seem a bit duanting or overwhelming but once you get into it it's usually not as bad as it seems.

The question about extra traffic is no it should not bog down either server. We have ours to replicate every 30 seconds.
Mad'sWife
College Coach
College Coach

User avatar

Posts: 294
Joined: 15 Oct 2003
Home Cafe: Baseball
Location: Fort Worth Tx

Postby menyak » Wed Oct 15, 2003 12:05 pm

Ok got it - I thought you were talking about load balancing, but if I get you right you mean an (almost) real-time backup system with the ability to redirect the traffic to the backup server in emergency cases?

We're doing daily backups anyway, but that of course doesn't help very much in a situation like yesterday.

Wow, just took a look... not exactly freeware, hehe. ;-)
"Never argue with an idiot. People won't know who's who."
menyak Beginner
General Manager
General Manager

User avatar
WebmasterCafeholicCafe WriterGraphics ExpertEagle EyeInnovative MemberWeb SupporterPick 3 Weekly Winner
Posts: 3050
(Past Year: 2)
Joined: 4 Jan 2002
Home Cafe: Football
Location: Offline on even days

Postby Mad'sWife » Thu Oct 16, 2003 1:18 am

I will ask around to some of the guys at work and see if someone knows of a free replication and failover software. ;-D
Mad'sWife
College Coach
College Coach

User avatar

Posts: 294
Joined: 15 Oct 2003
Home Cafe: Baseball
Location: Fort Worth Tx

Postby eftda » Thu Oct 16, 2003 1:36 am

Madison wrote:Well glad we are back up and running. :-) ;-D


Mad'sWife wrote:Definatly glad we are back up and running.

This is the feild I work in and would not mind helping if I can.

Feel free to ask me any questions. ;-D



awwwwww how cute.. Madison and his wife post back to back awwwwww O:-)
eftda
Hall of Fame Hero
Hall of Fame Hero

User avatar
Cafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe SpotterPick 3 Weekly WinnerLucky Ladders Weekly Winner
Posts: 9790
Joined: 11 Mar 2003
Home Cafe: Baseball

Next

Return to General Talk

Who is online

Users browsing this forum: unioreimi and 6 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Thursday, Apr. 17
(All times are EST, weather icons show forecast for game time)

Atlanta at Philadelphia
(1:05 pm)
Cleveland at Detroit
(1:08 pm)
Toronto at Minnesota
(1:10 pm)
Seattle at Texas
(2:05 pm)
LA Dodgers at San Francisco
(3:45 pm)
Colorado at San Diego
(6:40 pm)
Milwaukee at Pittsburgh
(7:05 pm)
St. Louis at Washington
(7:05 pm)
NY Yankees at Tampa Bay
(7:10 pm)
indoors
Boston at Chi White Sox
(8:10 pm)
Kansas City at Houston
(8:10 pm)

  • Fantasy Baseball
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact