Ingnite automatically load data if persistent database is updated

47 Views Asked by At

See I have one use-case, where My backend persistent DB is an oracle, and I m using ignite as cache, so I have already loaded some part of a column from persistent data, but here my question is if persistent data is updated, the same should be reflected into ignite cache automatically to perform some task on updated persistent data. Please respond, if is it possible or some way to handle this

1

There are 1 best solutions below

2
alamar On BEST ANSWER

Apache Ignite does not support a generic case of pulling real-time updates from RDBMS, because SQL do not have any generic mechanism for subscribing on updates.

GridGain, which is built upon Apache Ignite, offers a specific paid integration with Oracle Golden Gate.