Advice on dtabase

Discussion in 'Databases' started by auctionbaylive, Nov 21, 2010.

  1. #1
    I just started designing a large game site and would like to know what if using multiple databases & servers is a good idea since a site getting a lot of quieries to a database might over stress the server (correct me if i"m wrong)

    The website will include

    User management
    video uploading, steaming and pasting
    forums
    blogs
    articles
    image galleries
    chats

    I wait for your helpful suggestions
     
    auctionbaylive, Nov 21, 2010 IP
  2. smg

    smg Well-Known Member

    Messages:
    599
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    130
    #2
    One way is to have your website/application on one server and the database on another.

    I would recommend:
    • Have the database on its own dedicated server
    • Have the server operating system, logs and data on three seperate physical hard disks on its own dedicated server

    If you want to spread your website over more than one server, then try Googling "load balancing". You will find a lot of information on the different ways of doing it.
     
    smg, Nov 22, 2010 IP
  3. rayqsl

    rayqsl Active Member

    Messages:
    91
    Likes Received:
    0
    Best Answers:
    1
    Trophy Points:
    53
    #3
    I'm no expert in this area but here are my comments. What is going to be the user load on the game? You need to do some sizing calculations to find out what you need. What if you set up the game on multiple servers and only attract 50 gamers a day? Is that OK? Or do you need to attract 1,000 or 10,000 a day to make the game viable? Personally, if this is a new game I would develop for everything to be on the same server and then move the components onto different servers if the extra capacity is needed.

    Good luck.
     
    rayqsl, Nov 24, 2010 IP
  4. auctionbaylive

    auctionbaylive Active Member

    Messages:
    416
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    53
    #4
    Sorry for the misunderstanding!!! it's not going to be an online game but a gamer information website! cheats , reviews, trailers, flash arcade games might also be there, and videos hosted on my server.
     
    auctionbaylive, Nov 25, 2010 IP
  5. iama_gamer

    iama_gamer Active Member

    Messages:
    404
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    60
    #5
    With this kind of data, the same server might be enough. To begin with you can get a VPS and once you grow and you actually need to increase resources more than the VPS limits, use the same VPS for the apache but move the database to a seperate server. You can PM me if you want more info on this
     
    iama_gamer, Dec 4, 2010 IP
  6. alexanime

    alexanime Peon

    Messages:
    39
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    first just use a common rdbms (like MySQL, prostgresql etc) when your traffic grows (you must have over 1000 queries per second to worry you can optimize the database parameters and you can yous a cluster edition
     
    alexanime, Dec 5, 2010 IP
  7. arcadeshadow

    arcadeshadow Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    No, not a good idea. Start with a simple shared DB adapted as needed when you get the traffic.
     
    arcadeshadow, Dec 10, 2010 IP
  8. auctionbaylive

    auctionbaylive Active Member

    Messages:
    416
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    53
    #8
    What I'm building is a commercial script so I need to give the options or code it a way that users can user shared servers, VP servers and private servers.
     
    auctionbaylive, Dec 12, 2010 IP