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. 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.... 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
Archived
This topic is now archived and is closed to further replies.