Jump to content


are 2 db's better than one?

  • Please log in to reply
1 reply to this topic

#1 ijasont

  • Members
  • Pip
  • Newbie
  • 5 posts

Posted 23 May 2003 - 03:33 AM

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.
Jason Tugman [br]wannabe PHP Game Dev

#2 shivabharat

  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 23 May 2003 - 09:40 AM

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....
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users