Real time sync ignite cache

[Om Thacker <om...@gmail.com>]

Hello All,

I have 10 ignite caches created for 10 database tables. I have a scenario
wherein I need to update the cache regularly if the database is updated from
other sources. 
I am currently using kafka confluent to sync the ignite cache with the db.
But do we have any other option in ignite , which can be used to update the
cache on update in db or insert into  cache ,on insert in db.
Note: "I cannot use read-through option as it is only available."





--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Real time sync ignite cache

[Denis Magda <dm...@apache.org>]

Well, there are several options in additions to what you do with Kafka.

   1. Set up MySQL triggers and let them push data to Ignite via JMX or
   another streaming tool.
   2. Use Oracle Golden Gate integration that works for MySQL. This tool
   does this much more efficiently:
   https://www.gridgain.com/resources/blog/syncing-gridgain-memory-computing-cluster-and-database-using-oracle-goldengate


-
Denis


On Tue, Jun 4, 2019 at 1:16 PM aealexsandrov <ae...@gmail.com>
wrote:

> Hi,
>
> Without cache stores, you can try to use ignite-spark integration but it
> will not provide the real-time synchronization.
>
> Also, you can try to set up some incremental data loading over JDBC, for
> example via apach sqoop.
>
> BR,
> Andrei
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: Real time sync ignite cache

[aealexsandrov <ae...@gmail.com>]

Hi,

Without cache stores, you can try to use ignite-spark integration but it
will not provide the real-time synchronization. 

Also, you can try to set up some incremental data loading over JDBC, for
example via apach sqoop.

BR,
Andrei



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Real time sync ignite cache

[Om Thacker <om...@gmail.com>]

I am using MySQL database



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Real time sync ignite cache

[aealexsandrov <ae...@gmail.com>]

Hi,

What database do you use?

BR,
Andrei



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/