ijasont Posted May 23, 2003 Share Posted May 23, 2003 I am making a simple web based game that is completely db driven. My question(s) are: 1) while Mysql can easily handle my expected traffic (about 150 simultaneous users). Should I make two db\'s to lesson on load? One for player stats, info the other for game tables and change tables? 2) IF I should use to db\'s should I keep them on different servers to prevent server overload? Note: I am running current versions of mysql and php and plan to have medium level hosting package from W3Freaks. - other similar online games (mafia.org and projectrockstar.com) get really slow with over 200 users. I am concerned about mysql crashing from to many simultaneous requests. Thanks for the tips. Quote Link to comment https://forums.phpfreaks.com/topic/496-are-2-dbs-better-than-one/ Share on other sites More sharing options...
shivabharat Posted May 23, 2003 Share Posted May 23, 2003 I dont think ist necessary DB is just a logical identifier to show the content u have under that. IF I should use two db\'s should I keep them on different servers to prevent server overload? The problem u might face in this case if one server goes off u will have a tough time........ I dont think there is a real need.... Quote Link to comment https://forums.phpfreaks.com/topic/496-are-2-dbs-better-than-one/#findComment-1676 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.