MMORPG and scalability : the Database problem

MasterNag · 2003-11-21T23:59:14

Hello everyone here, I am very interested in the architecture design of MMORPGs. I have read a lot on this subject and if the management of a big continuous world using several servers is fairly easy, I have found very little about the database usage. If there is no real problem when dealing with a small amount of players, it''s not the same if you think in term of scalability. So now, let''s imagine a game allowing, let''s say, 100.000 players at the same time on the same world out of a number of 1 million potential gamers (that would be achieved by having 10 to 20 game servers, each dealing with a part of those people). In this case, the underlaying database would be a very large one ! But my guess is that only one database wouldn''t be able to deal with the number of transactions needed in this case... The only solution then must be to have the "database" served by more than one server ! Then has anyone some clues on the means to achieve that (I have already thought of separating the login/billing database from the real game one, but I think that the problem still remains for this last one) ? Thanx in advance I can do anything... and I can do it better than anyone... Be like me : just be the best ! ;-)

Networking and Multiplayer Programming

Started by MasterNag October 27, 2003 06:35 AM

12 comments, last by MasterNag 21 years, 2 months ago

Themonkster

159

November 13, 2003 06:51 PM

read this

http://www.gamasutra.com/resource_guide/20020916/hallenberg_01.htm

your need to join if you are not a member and if your not a member what are you doing here

My F1 Blog http://www.willtheyeverovertake.com F1 News Blog

jwthomp

180

November 21, 2003 05:51 PM

quote:
Original post by Megahertz

I worked as a network admin for Paypal for a bit and for the most part all 10million+ users were all served off the same database.

-=[ Megahertz ]=-

Hey Megahertz,

Did you know Max Levchin or Luke Nosek at PayPal?

Cheers,

Jeff

Jeff Thompson

Megahertz

286

November 21, 2003 06:15 PM

Yes I knew Max Levchin. Luke Nosek rings a bell, but I dont think I knew who he was. Max was the CTO and he was my boss's boss.

-=[ Megahertz ]=-

[edited by - megahertz on November 21, 2003 7:15:50 PM]

-=[Megahertz]=-

jwthomp

180

November 21, 2003 11:59 PM

Megahertz,

Very neat. They were both friends of mine from college. Like myself they were both very entrepreneurial in college. It''s nice to see them succeed. Glad you got a chance to meet Max. Luke is also a very nice guy and quite smart, if a bit eccentric.

Cheers!

Jeff

Jeff Thompson

MMORPG and scalability : the Database problem

This topic is closed to new replies.

Popular Topics

Recommended Tutorials

MMORPG and scalability : the Database problem

This topic is closed to new replies.

Popular Topics

Recommended Tutorials

Reticulating splines