Good database hosting?

Discussion in 'MySQL' started by Solicitors Mortgages, Oct 8, 2007.

0
  1. #1
    Where is a good place to host a database that will handle a lot of queries?
    I have a "football league" type of homepage with 6 live results tables and the host it is currently on doesn't seem to be able to handle it, I keep getting error500 for the homepage :confused:

    It also needs to be quite big as the information on there will grow..and grow..

    thanks in adv...
    James.
     
    Solicitors Mortgages, Oct 8, 2007 IP
  2. JenniP

    JenniP Peon

    Messages:
    250
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    0
    #2
    What are the 500 errors caused by? If its the DB not being fast enough, are you sure you've optimised your DB for performance, and optimised the code calling it. Caching data so each user hit doesnt create a database hit is a great way to take the load off a stressed database.

    Also what type of database, MySQL, SQL Server etc?

    Jen
     
    JenniP, Oct 8, 2007 IP
  3. Solicitors Mortgages

    Solicitors Mortgages Well-Known Member

    Messages:
    2,217
    Likes Received:
    139
    Best Answers:
    0
    Trophy Points:
    103
    #3
    Hi Jen,
    As far as I am aware it is not optimised, and I wouldn't know where to begin that :p

    The league tables are LIVE so I can't use caching (especially on the homepage where the problem seems to be, all the inner pages seem to be OK)

    It's a MySQL - on 1and1 - running a Drupal cms :eek:

    any help appreciated...
    James.
     
    Solicitors Mortgages, Oct 9, 2007 IP
  4. cheftom

    cheftom Active Member

    Messages:
    377
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #4
    Hmm.. All I can say, is that I know that PowWeb's database servers have been running VERY slow!
     
    cheftom, Oct 9, 2007 IP
  5. GMROCKS

    GMROCKS Active Member

    Messages:
    648
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    60
    #5
    Here's my advice - get out of 1and1 while you can.
    they cost me $700.

    and try freemysql.net
     
    GMROCKS, Oct 9, 2007 IP
  6. chickens

    chickens Peon

    Messages:
    242
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #6
    chickens, Oct 9, 2007 IP
  7. JenniP

    JenniP Peon

    Messages:
    250
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Oh you can use caching, your tables may be live but does it really matter if they are seconds old. Depending how many concurent hits your getting even caching something for 10 seconds can save you a LOT of database access.

    Even if you wanted "Live" tables I think you could still cache for 30-60 seconds without impacting on user experience, or even better cache between one change and the next. So when one even happens that changes the table you regenerate it, cache it and keep it cached until another change happens when you regenerate it again. That would really minimise DB hits although its a lot more difficult.

    As for optimising the database, if you are joining tables make sure there are indexes on the join conditions.

    I'm willing to bet that anyone who knows about optimsing MySQL could get rid of your performance problems, especially if you add caching as well.

    On 1and1, I would second, third and even fourth the comments, they arent a quality hoster just a popular one. Wouldnt surprise me if part of the reason they are slow is an over sold database.

    Jen
     
    JenniP, Oct 11, 2007 IP