Developers Corner

A lot of the performance problems in MMOs appear DB related, is there a particular favorite DB in use for MMOs? id assumed it would be Oracle but looking at Funcoms site AoC would appear to be using SQL server. Anyone any experience of the DB side of MMOs?

I’m currently working as DBA so I’m really curious to know that too.
Oracle RAC seems to be a good choice, but… you never know. There’s also IBM db2.

/bump

Yes same, I have over 16 years oracle experience and it would seem such an obvious choice for something like an MMO.

My professional experience is in web programming using PHP and MySQL, which is also my choice for my MORG.

MYSQL may be ok for a prototype but in terms of scaleability, performance, backuo and recovery its a non starter for something like an MMO. How many concurrent accounts/users can you manage on MYSQL?

Originally posted by Thoth-Amon

MYSQL may be ok for a prototype but in terms of scaleability, performance, backuo and recovery its a non starter for something like an MMO. How many concurrent accounts/users can you manage on MYSQL?

Its good enough for my game. It will handle my server needs of 1024 simultaneous players. 

I never use MySQL servers, I cane be mistaking though, but it doesn't seem to work that good on Linux... And everyone knows (or should know!) that Windows is by no means stable enough to host anything but websites.

Apache all the way for me. :}

Well, I'm using sqlite for my prototype database :) For production I have been using postgresql. For me the backend doesn't matter all that much. For most mmorpg's it's not really the database that limits connections though, I would say the application layer is the real bottleneck. Especially if you are going to have fancy things like player/player collision detection. Mysql seems to be good enough for second life, which honestly has more complex database needs than most games. Although scale-wise obviously WoW has the biggest demands on its database. Google has such large demands that they don't use SQL at all, using their own persisted filesystem, with very structured canned queries. It might be worth looking into similar alternatives.

If you've got the cash of course, you might as well shop the bigger options, a la oracle et all. I think a lot of games use Microsoft sql server, as loath as I would be to use a microsoft product on the server side. But they get by with it :)

For most games I feel that sql is a bit wasted. It is mostly used as a way to save stuff in case the server fails or has to be taken down, with little use while the game is running, which hopefully is what your server spends the most time doing. Even the fastest access to the database is not going to be as fast as caching everything in memory. You want to use the database wisely, hitting it as infrequently as possible, for instance grabbing a lot of data with a single select statement instead of grabbing things one at a time.

i think WoW is running on ORACLE RACs.

I would go for oracle also - i just love stored procedures :D