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 <kse...@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 >