[FIXED] what is the best strategy to sync data between DB and redis cache

Issue

We are using Oracle db, we would like to use Redis Cache mechanism, We add some subset of DB data to cache, does it sync with DB automatically when there is a change in the data in DB or we will have to implement the sync strategy, if yes, what is the best way to do it.

Solution

does it sync with DB automatically when there is a change in the data in DB

No, it doesn't.

we will have to implement the sync strategy, if yes, what is the best way to do it.

This will depend on your particular case. Usually caches are sync'd in two common ways:

1. Data cached with expiration. Once cached data has expired, a background process adds fresh data to cache, and so on. Usually there's data that will be refreshed in different intervals: 10 minutes, 1 hour, every day...

2. Data cached on demand. When an user requests some data, that request goes through the non-cached road, and that request stores the result in cache, and a limited number of subsequent requests will read cached data directly if cache is available. This approach can fall into #1 one too in terms of cache invalidation interval.

Now I believe that you've enough details to think about what could be your best strategy in your particular case!

Answered By - Matías Fidemraizer

Answer Checked By - Terry (PHPFixing Volunteer)