Re:How to take advantage of Redis just adding it to your stack
by sbov on Wednesday June 29, 2011 @05:57AM
(#2708915)
I would be extremely surprised if WoW has issues when lots of people are crammed in a small space due to their Oracle backend. More likely it is all the calculations that the serverside is performing. I know a few people who work on other MMOs and they keep everything in memory, even accounts for logged off users.
I'm curious: what you think (or know?) they are doing that is causing the database to be a limiting factor?
Re:How to take advantage of Redis just adding it to your stack
by illumin8 on Wednesday June 29, 2011 @10:23AM
(#2709559)
I didn't mean to imply that the bottleneck was due to Oracle. I was saying the exact same thing you are saying - it's due to memory or CPU limitations in their application server, which forces them to heavily shard.
If Redis can help them scale from the small shard to larger shards that support more players in an area, it might be interesting.
You might finally be able to break the model that current large games like WoW use - heavily sharded with all persistent data stored in Oracle. Redis should allow you to shard less and use SQL less, resulting in a much better experience, especially when parts of the virtual world get crowded.