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
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.
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.
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.
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
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
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.