+ Post New Thread
Results 1 to 12 of 12
CLEO Thread, SQL servers down in Regional Broadband Consortiums (RBC); Bit of bad luck - SQL websites servers have gone down just at a time when websites being used for ...
  1. #1

    SimpleSi's Avatar
    Join Date
    Jun 2005
    Location
    Lancashire
    Posts
    5,780
    Thank Post
    1,469
    Thanked 591 Times in 443 Posts
    Rep Power
    168

    SQL servers down

    Bit of bad luck - SQL websites servers have gone down just at a time when websites being used for school closure/opening news

    They b*&^%y gremlins always know the best time to do their stuff!

    regards

    Simon

    If anyone knows how to get a msg to CLEO direct - please let me know (or JDI for me please )

  2. #2

    SimpleSi's Avatar
    Join Date
    Jun 2005
    Location
    Lancashire
    Posts
    5,780
    Thank Post
    1,469
    Thanked 591 Times in 443 Posts
    Rep Power
    168
    I think they are crumbling under the load

  3. #3

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180
    It's the LancsNGfL web servers that are struggling Si. Last night I had to put a message on ours and the MySQL server kept bombing out. At that point there was 140 peoploe looking at just our website. The LancsNGfL people obviously never expected a lot of people to use the websites

  4. #4
    p858snake's Avatar
    Join Date
    Dec 2008
    Location
    Queensland
    Posts
    1,490
    Thank Post
    37
    Thanked 175 Times in 151 Posts
    Blog Entries
    2
    Rep Power
    51
    Hint: temporarily replace your site with a plain html page, it should reduce loads you will only have to rely on one server (the webserver) compared to having to rely on mysql as well. And they can be cached easier.

  5. Thanks to p858snake from:

    SimpleSi (6th January 2010)

  6. #5

    SimpleSi's Avatar
    Join Date
    Jun 2005
    Location
    Lancashire
    Posts
    5,780
    Thank Post
    1,469
    Thanked 591 Times in 443 Posts
    Rep Power
    168
    Tried plain index.html which works fine but problem is that people might have bookmarked/already be on the snow info url and some of my heads and teachers directly edit the site without telling me so we could end up with conflicting info.

    But nice idea

    regards

    Simon

  7. #6

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180
    I'm thinking some sort of review needs to be done regarding the capacity of the LancsNGfL webservers.

    All I want to do is add a new article regarding tomorrow's partial closure but it bombs out every time I click save!!!

  8. #7

    SimpleSi's Avatar
    Join Date
    Jun 2005
    Location
    Lancashire
    Posts
    5,780
    Thank Post
    1,469
    Thanked 591 Times in 443 Posts
    Rep Power
    168
    Im currently putting all my sites into maintenance mode to try to help reduce load on webservers - see this thread
    Anyone else's embc school website go down?

    regards

    Simon

  9. #8

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180
    One of the problems will be getting the amdin interface to work long enough to enter maintenance mode though!

  10. #9
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,188
    Thank Post
    446
    Thanked 168 Times in 165 Posts
    Blog Entries
    3
    Rep Power
    63
    If it's joomla 1.5 (don't know about 1.0) you can go into the configuration.php and just change the closed variable and that will save you having to get into the admin console.

    Just make sure you check the permissions so that you can write the file back again (defaults to read for all) - caused me 10 minutes of confusion

  11. Thanks to Cache from:

    SimpleSi (6th January 2010)

  12. #10

    SimpleSi's Avatar
    Join Date
    Jun 2005
    Location
    Lancashire
    Posts
    5,780
    Thank Post
    1,469
    Thanked 591 Times in 443 Posts
    Rep Power
    168
    The websites seem accessible now so I suggest editing now (if your still up!) as the more we do - the more we might help ourselves

    regards

    Simon

  13. #11

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180
    I had a chat to Martin Quinn earlier... to cut a long story short, the webservers have experienced a three-fold increase in traffic and 'every effort is being made to prevent the situation happening again'.

    The advice is to log all your concerns through the Westfield Centre so that there is a record and it is expected to be discused at the next LancsNGfL meeting which is at the start of February.

  14. #12

    SimpleSi's Avatar
    Join Date
    Jun 2005
    Location
    Lancashire
    Posts
    5,780
    Thank Post
    1,469
    Thanked 591 Times in 443 Posts
    Rep Power
    168
    Just spoken to Westfield and I am confused as they are saying they don't think last weeks problems were due to the traffic capacity of the servers

    I'm reverting my websites to normal and we'll see what happens next time

    regards

    Simon

SHARE:
+ Post New Thread

Similar Threads

  1. Sims.net & dedicated SQL Servers.
    By boomam in forum MIS Systems
    Replies: 12
    Last Post: 25th January 2010, 04:41 PM
  2. Replies: 3
    Last Post: 19th February 2008, 10:13 PM
  3. SQL
    By mac_shinobi in forum How do you do....it?
    Replies: 5
    Last Post: 6th February 2008, 02:42 PM
  4. MS SQL 2005 - Dump SQL
    By tom_newton in forum Windows
    Replies: 7
    Last Post: 23rd January 2008, 05:10 PM
  5. SQL Anywhere
    By Jobos in forum MIS Systems
    Replies: 5
    Last Post: 12th November 2007, 01:05 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •