ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ilya Kasnacheev <ilya.kasnach...@gmail.com>
Subject Re: Data from multiple MySQL DBs
Date Wed, 11 Sep 2019 15:09:33 GMT
Hello!

I think the best course will be to read all DBs in user code and use data
streamer to populate Ignite.

Regards,
-- 
Ilya Kasnacheev


вт, 10 сент. 2019 г. в 18:01, Kurt Semba <ksemba@extremenetworks.com>:

> Hi all,
>
>
>
> I need to sync data from multiple MySQL databases into Ignite.
>
>
>
> All those MySQL databases follow the same schema / same tables but
> obviously contain different data. They are separate instances of the same
> DB and we want to pull all that data into Ignite to have a central store to
> query against.
>
>
>
> What would be the best strategy to solve this?
>
>
>
> Create a dedicated Cache for each DB instance and then find a way to
> create a UNION SQL query over all those Caches?
>
> Find a way to define all the MySQL DBs as data sources in the Spring XML
> cluster config file and hope that Ignite pulls the same type of data from
> all DBs?
>
>
>
> I’m open for suggestions 😊
>
> Thanks
>
> Kurt
>

Mime
View raw message