Redis synchronization with database

[Guru Ramamurthy]

Hi all,

I am a newbie to Redis.
I know that we can give commands in command line to cache the data.
But, how to synchronize my cache data to DB (say RDBMS, ORACLE DB).
If you give me a pointer, I can pick up

Thanks,
Guru

[Tim Moores]

Welcome to the Ranch.

That's not really how Redis operates (or rather, what it is made for). You'll have to implement that in your own code.

[Guru Ramamurthy]

Is it so?

1. Create a topic so that data will be published to this
2. Write a program (Java or any other language), to subscribe to this topic, read and insert into DB?

If this is so, if there is a change in the DB table (say a new record insert in DB table), how we can copy this new record to REDIS?
Sorry, I am very new.

[Tim Moores]

As I said, you will have to write the code to do that - Redis does not have facilities to read or write to a DB by itself.

[Tim Holloway]

REDIS is strictly an in-memory cache. Rather than try and force it to be a local database cache, you should use a product that actually acts as a local database cache. For a discussion on such things, this may help: https://codeahoy.com/2017/08/11/caching-strategies-and-how-to-choose-the-right-one/

Alternatively, in Java there are facilities which manage the caching and database I/O as extensions of the application itself. Enterprise JavaBeans was designed this way, and many Java Persistence Architecture (JPA) libraries can do so as well - JPA is just a simplified version of EJB Version 3 that doesn't require full EJB services or servers.