YAPC::Europe 2011 “Modern Perl”

Twitter #ye2011 RSS Log in

Replacing Relational DB with Redis: a Case Study

By Anton Berezin (‎Grrrr‎) from Copenhagen.pm
Date: Monday, 15 August 2011 14:10
Duration: 65 minutes
Target audience: Intermediate
Language:
Tags: databases redis

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.

Attended by:

Other conferences

London Perl & Raku Workshop 2024 25 October 2024 — German Perl/Raku Workshop 2025 14 April 2025 — and more.

Feel free to contact us: mail@yapceurope.lv.
YAPC::Europe 2011 in Riga organizing committee.