Replacing Relational DB with Redis: a Case Study
While relational databases represent a valuable and versatile tool, they have their problems. For many workloads the performance offered by many RDBMSes does not cut it.
This talk considers one such case, and walks through the implementation of one possible solution, namely the replacement of a PostgreSQL instance with an in-memory key-value store Redis.
The general steps necessary for such conversion are defined and elaborated upon.
The limitations of using Redis instead of an RDBMS are discussed as well.
As a bonus, using Redis as a message bus is described. An implementation of a generic queue for watching Best Practical's Request Tracker's transactions is used as an illustration.
Last presented: Nordic Perl Workshop 2011, June 19th 2011, Malmö, Sweden