WarcraftReamls.com
  FAQFAQ    SearchSearch    MemberlistMemberlist    UsergroupsUsergroups   RegisterRegister 
  ProfileProfile    Log in to check your private messagesLog in to check your private messages    Log inLog in 
DB Errors

 
Post new topic   Reply to topic    WarcraftRealms.com Forum Index -> WarcraftRealms.com Bugs
View previous topic :: View next topic  
Author Message
Padanfain
Updater Extraordinaire


Joined: 18 Dec 2010
Posts: 173
Location: Shadar Logoth
WR Updates: 40,168,446
Padanfain WR Profile

PostPosted: Mon Mar 02, 2015 8:38 pm    Post subject: DB Errors Reply with quote

Have been seeing these fairly frequently the last few days.

When opening the upload page and sometimes at the end of upload...
Error - Unable to connect to DB

When opening the forum index page...
phpBB : Critical Error
Could not connect to the database


Thinking it is not metalbeast doing maintenance or such because a refresh or reload of the page is usually successful.
_________________
"Water? .... I'm thirsty not dirty." - Prince Kheldar of Drasnia
"I've looked at the world for quite a few years now and I've found that if I don't laugh, I'll probably end up crying." - Prince Kheldar of Drasnia
Back to top
View user's profile Send private message
bringoutyourdead
Forums Admin & general flunky


Joined: 07 Nov 2008
Posts: 1214
Location: Silicon Valley, CA, USA
WR Updates: 9,182,216
bringoutyourdead WR Profile

PostPosted: Mon Mar 02, 2015 9:49 pm    Post subject: Reply with quote

Actually Metalbeast and his staff are doing something.
I contacted him on the 23rd about these errors and he said they were "Optimizing MySQL"

To be honest I'm thinking He and his staff.. thinks this site is useful for testing performance tweaks as they keep moving us to bigger and better setups.
According to Metalbeast, WarcraftRealms.com is now on a CDN aka http://en.wikipedia.org/wiki/Content_delivery_network.

This protects the site from DOS attacks and local hardware failures.
I expect the continuing very short issues is due to their still working on getting the DB engines to handle their replications across the various servers in the CDN.
While these glitches are a bit of an annoyance.. as you noted almost always an immediate retry gets through.

In a previous message, Metalbeast as an aside mentioned a little about the server configurations..
Massive(at least to me) numbers of CPU cores and High order GB of ram...
enough that all processing was happening in ram with no need for paging from disk drives.

There have been a few oops! missing steps...
a system level cron job that helps with cleaning up the spambots got missed when the did a transfer to new environment..

But on the other hand, I don't know if anyone actually spotted when they did the cut-over.. I sure didn't.

I did catch a DNS IP transfer back around Thanksgiving when they did a DNS update and I caught in a mid transfer situation while using my remote admin tools.

I don't know if it was Metalbeast and crew but at one point their master spam blocking setup marked @gmail.com as a spam source. Rolling Eyes
Back to top
View user's profile Send private message
bringoutyourdead
Forums Admin & general flunky


Joined: 07 Nov 2008
Posts: 1214
Location: Silicon Valley, CA, USA
WR Updates: 9,182,216
bringoutyourdead WR Profile

PostPosted: Tue Mar 03, 2015 1:39 pm    Post subject: Reply with quote

Metalbeast re-confirmed this morning that they are still working on db optimization issues... getting it dialed in on the configuration settings.
Back to top
View user's profile Send private message
Padanfain
Updater Extraordinaire


Joined: 18 Dec 2010
Posts: 173
Location: Shadar Logoth
WR Updates: 40,168,446
Padanfain WR Profile

PostPosted: Tue Mar 03, 2015 1:57 pm    Post subject: Reply with quote

Cool beans. TY for the info boyd.
_________________
"Water? .... I'm thirsty not dirty." - Prince Kheldar of Drasnia
"I've looked at the world for quite a few years now and I've found that if I don't laugh, I'll probably end up crying." - Prince Kheldar of Drasnia
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    WarcraftRealms.com Forum Index -> WarcraftRealms.com Bugs All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
WarcraftRealms.com  


Powered by phpBB © 2001, 2005 phpBB Group