Caching in Rails, Mysql, and Ubuntu 14.04

November 10, 2017 1k views
Caching Ubuntu

I have a Ruby on Rails application with a Mysql database running on Ubuntu 14.04. I have a query that is taking like 4 seconds to run. This is terrible so I'd like to cache it in rails.

I'm basically trying to do something like this:

def competing_price
    Rails.cache.fetch("#{cache_key}/competing_price", expires_in: 12.hours) do
      Competitor::API.find_price(id)
    end
  end

What can I do to implement this cache? I need either Memcached or Redis to act as the memory store. How do install this on DigitalOcean and then configure Rails to use this memory store? Got a tutorial?

1 Answer

Hello,

You can follow the steps here on how to install, secure and use redis on Ubuntu:

https://www.digitalocean.com/community/tutorials/how-to-install-and-use-redis

Hope that this helps!
Regards,
Bobby

by Etel Sverdlov
This tutorial covers the Redis Installation, some simple Redis operations, and the 5 Redis data types. Redis, developed in 2009, is a flexible, open-source, key value data store that allows users to store vast amounts of data without the limits of a relational database.
Have another answer? Share your knowledge.