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
