Databasing

Facebook Twitter

11 Common Web Use Cases Solved in Redis. In How to take advantage of Redis just adding it to your stack Salvatore 'antirez' Sanfilippo shows how to solve some common problems in Redis by taking advantage of its unique data structure handling capabilities.

11 Common Web Use Cases Solved in Redis

Common Redis primitives like LPUSH, and LTRIM, and LREM are used to accomplish tasks programmers need to get done, but that can be hard or slow in more traditional stores. A very useful and practical article. Neo4j: NOSQL For the Enterprise. Luke Melia » Redis in Practice: Who’s Online? Redis is one of the most interesting of the NOSQL solutions.

Luke Melia » Redis in Practice: Who’s Online?

It goes beyond a simple key-value store in that keys’ values can be simple strings, but can also be data structures. Redis currently supports lists, sets and sorted sets. This post provides an example of using Redis’ Set data type in a recent feature I implemented for Weplay, our social youth sports site. The End Result. Try Redis. TutorialCachingStory - memcached - This is a story of Caching - Memcached. Ed note: this is an overview of basic memcached use case, and how memcached clients work Two plucky adventurers, Programmer and Sysadmin, set out on a journey.

TutorialCachingStory - memcached - This is a story of Caching - Memcached

Together they make websites. Websites with webservers and databases. Users from all over the Internet talk to the webservers and ask them to make pages for them. On Redis, Memcached, Speed, Benchmarks and The Toilet. The internet is full of things: trolls, awesome programming threads, p0rn, proofs of how cool and creative the human beings can be, and of course crappy benchmarks.

On Redis, Memcached, Speed, Benchmarks and The Toilet

In this blog post I want to focus my attention to the latter, and at the same time I'll try to show how good methodology to perform a benchmark is supposed to be, at least from my point of view. Why speed matters? Choosing innodb_buffer_pool_size. November 3, 2007 by Peter Zaitsev39 Comments My last post about Innodb Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size and indeed I oversimplified things a bit too much, so let me write a bit better description.

Choosing innodb_buffer_pool_size

Innodb Buffer Pool is by far the most important option for Innodb Performance and it must be set correctly. Instagram Engineering • Storing hundreds of millions of simple key-value pairs in Redis. Instagram Engineering • Sharding & IDs at Instagram. Shard (database architecture) In practice, sharding is far more complex.

Shard (database architecture)

Although it has been done for a long time by hand-coding (especially where rows have an obvious grouping, as per the example above), this is often inflexible. There is a desire to support sharding automatically, both in terms of adding code support for it, and for identifying candidates to be sharded separately. Consistent hashing is one form of automatic sharding to spread large loads across multiple smaller services and servers.[2][3] Where distributed computing is used to separate load between multiple servers (either for performance or reliability reasons), a shard approach may also be useful. Sharding goes beyond this: it partitions the problematic table(s) in the same way, but it does this across potentially multiple instances of the schema.