A short story of migrating Dating DNA chatrooms + forums from MySQL to Redis and PHP Rediska.

Original title and link: Powered by Redis: Dating DNA ChatWalls (NoSQL databases © myNoSQL)

via: http://www.justincarmony.com/blog/2011/01/07/creating-chatroom-walls-with-redis-and-php/

Smories is a Django app. Although the little server it runs on handles the spiky traffic fine I’ve been fiddling with Redis to prepare the site for when it eventually overtakes Facebook. I love Redis. It feels like a natural, ultra-performant extension to Python’s easy way of handling data types.

Redis usage at ☞ Smories:

• query cache: making using of the Redis data structures
• rate limiting: based on key expiration
• activity tracking: real-time tracker using Redis capped lists

Adding it to Powered by Redis.

Original title and link: Redis at Smories (NoSQL databases © myNoSQL)

via: http://tomdyson.org/post/1465680128/smories-with-redis

Any particular reason for Membase appearing mostly in game usecases? Or is it more like: “if Zynga is using Membase, then we will too”?

Under the hood, this Facebook game makes good use of AWS and a number of other technologies. Here’s a summary:

• The game is written in Sinatra, a DSL (domain specific language) used to create Ruby apps with minimal effort. The code runs on Amazon EC2.
• Traffic to the EC2 instances is load balanced using the Nginx load balancer.
• Membase is used for data storage, hosted on a number of Elastic Block Storage (EBS) volumes.
• Scalr is used to scale and manage the application.

Original title and link: FameTown - A New AWS-Powered Facebook Game Using Membase (NoSQL databases © myNoSQL)

via: http://aws.typepad.com/aws/2010/11/fametown-a-new-aws-powered-facebook-game.html

After Facebook, Twitter^[1], Digg^[2], and a couple more, Cassandra is now going government with Synthesis, an analytics solution built by Digital Reasoning:

It is now deploying Synthesis inside the intelligence community across a 400-node cluster. Cassandra and Synthesis together will derive actionable intelligence from hundreds of millions of documents.

Original title and link: Synthesis: An Analytics Product Built on Cassandra (NoSQL databases © myNoSQL)

via: http://www.riptano.com/blog/riptano-and-digital-reasoning-form-partnership

Excellent Redis use case from PeachShake:

My solution was to leave the data storage in MySQL, but move the stream construction into Redis. Instead of querying MySQL and doing the joins to make the stream, I just create a linear stream for each user and append new IDs to it every time an action occurs. Then, the MySQL query is a dead-simple “SELECT WHERE IN” query using the IDs pulled from the Redis list. This takes a 30+ second MySQL query down to a few milliseconds.

As always, the main issue is synchronization. I have to make sure that the Redis activity stream matches the activities stored in MySQL.

Couple of comments though:

• I’d try my best to avoid SELECT WHERE IN (depending on the size of the data I’d try to assemble it and place it directly in Redis. In other words, cache at a higher level)
• Activity streams do not require perfect synchronization

Added to the Powered by Redis.

Original title and link: Redis Usecase: Activity Stream Caching (NoSQL databases © myNoSQL)

via: http://peachshake.com/2010/10/04/initial-thoughts-on-redis/