Jump to content
  • Advertisement
Sign in to follow this  
Funyun

How do the major MMOs out there store login and other information?

This topic is 3677 days old which is more than the 365 day threshold we allow for new replies. Please post a new topic.

If you intended to correct an error in the post then please contact us.

Recommended Posts

How do other MMO companies out there store things like usernames and passwords? Do they store them in SQL databases or something of that sort? And what about things like information on skills, items, etc.? Is that all stored and constantly written to a central database or is it just saved in a text file on the server? Thanks.

Share this post


Link to post
Share on other sites
Advertisement
I suggest a MMO server is viewed like any other big server application. In which case, a database is the standard solution. You CAN use files but databases are designed for exactly this purpose.

Share this post


Link to post
Share on other sites
Some things (like authentication) don't change much between applications.

However, the amount of mutating state for an MMO, and the real-time requirements, are actually fairly special to MMO games. The other app that may be similar is the stock market, but they have different trade-offs (consistency is more important, latency is less important, somewhat oversimplified). And different budgets :-)

The "vanilla" MMO architecture is that the simulation servers "check out" the state from the database server when a player logs in, and they "checkpoint" the state after important events and once in a while, to reduce the amount of data lost if the server should crash. Additionally, user trades and other "important" events should be done as a transaction in the database, to avoid the possibility of "dup" or "trade" hacks/corruption.

Share this post


Link to post
Share on other sites
Well MMO's such as WoW are using SQL right now, it seems to be a big deal lol

I on the other hand like text files whn im making my games, much easier, although SQL is much mor effcient!

Share this post


Link to post
Share on other sites
Quote:

The other app that may be similar is the stock market, but they have different trade-offs (consistency is more important, latency is less important, somewhat oversimplified). And different budgets


Latency for trading is crucial. Especially with all the automatic electronic trading going on today. There are trading solutions that count the response time in microseconds. MMO's also have fairly small budgets with few reaching the 100 million USD mark. Remember that this is the financial backbone of the world we're talking about where 100 million or so is nothing.

Quote:

I on the other hand like text files whn im making my games, much easier, although SQL is much mor effcient!

A RDBMS is extremely inefficient to be honest. It's more about relational models than a simple blob storage engine. I doubt authentication will ever be a bottleneck though since even if it would be a full RDBMS you'd be running extremely simple queries and the database files would be very very likely to fit in RAM. The most expensive part would probably be to reach out to the database server, compile the SQL and execute the SQL. However you'd have transactional safety and other guarantees that can be very hard to get completely right on your own. I would definitely go with simply using an existing RDBMS and then switch it out with a custom solution after doing load testing and seeing that it wouldn't be able to keep up. My bet is that you'll be able to log in many thousands of people per second even on a desktop computer.

Share this post


Link to post
Share on other sites
Quote:
Original post by asp_My bet is that you'll be able to log in many thousands of people per second even on a desktop computer.


But being logged in isn't particularly interesting, no matter how fast they log in.

It's what they do that matters.

Share this post


Link to post
Share on other sites
Text files don't scale. Any MMO that expects more than a few dozen players (and if you're not it's not really an MMO. It's more a mMO :P) needs to be using a database of some sort.

Share this post


Link to post
Share on other sites
Quote:
Text files don't scale.


Shh! Don't tell the web. It hasn't heard yet! It'd be a shame if it suddenly collapsed because of the lack of scalability of text files.

Share this post


Link to post
Share on other sites
Quote:
Original post by hplus0603
Quote:
Text files don't scale.


Shh! Don't tell the web. It hasn't heard yet! It'd be a shame if it suddenly collapsed because of the lack of scalability of text files.


Heh, I can't tell if you're being sarcastic or facetious :)

Share this post


Link to post
Share on other sites
Quote:
I can't tell if you're being sarcastic or facetious


Man, I don't even know anymore!

(bonus points if you know the source of that quote in context)

Share this post


Link to post
Share on other sites
Sign in to follow this  

  • Advertisement
×

Important Information

By using GameDev.net, you agree to our community Guidelines, Terms of Use, and Privacy Policy.

We are the game development community.

Whether you are an indie, hobbyist, AAA developer, or just trying to learn, GameDev.net is the place for you to learn, share, and connect with the games industry. Learn more About Us or sign up!

Sign me up!