MMO - Best non-sql DB to store data

Question

What do you think would be the best non-sql database for storing info of players in a real-time MMO game that runs on a C++ server?

Answer 1

tokyo cabinet, hamsterdb, berkeleydb

my best bet would be tokyo cabinet, you should be aware that most k/v DBs doesn't came with update feature which is crucial for mmo server.

Answer 2

Man, take your pick :)

Currently, I'm using MongoDB for info about users. MongoDB is very fast, and will perform especially well if you have enough memory to store everything (at which point it's like MemcacheD with a file backing). However, MongoDB does make some concessions on "durability" to attain its speed.

If you're operating an MMO, the stuff you'll really want to look at is sharding and replica pairs. These two technologies will allow you to scale out the DB horizontally while still providing an "hot backup" for when a node fails. Replica Pairs will help you to get around the typical durability concessions by allow you to force important updates to replicate.

However, the numbers I've read on TokyoCabinet are also very impressive.

Of course, the TokyoCabinet docs have been painful. So it's really your call.