Hi Sumit, In addition to the approach suggested by Nick you can go for DDL way: https://apacheignite.readme.io/docs#section-create-table
You can create tables (and underlying caches), indexes in runtime. To tie such a table up with a MySQL layer you need to register a template with your CacheStore implementation and pass the template as a parameter to CREATE TABLE command: https://apacheignite.readme.io/docs#section-extended-parameters Ignite doesn’t automatically update its scheme in response to MySQL related changes. So this is what you need to do manually for both storages. — Denis > On Sep 30, 2017, at 2:18 AM, Sumit Sethia <[email protected]> wrote: > > Hi, > I want to dynamically create cache for new mysql table in Ignite. I don't > have table's class definition at runtime. I regularly get new data in HDFS > for those tables in avro format. I want to ingest that incremental data into > Ignite Cache by creating cache at runtime if it doesn't exist for that table > and then put data into cache. Also I want to query on that data. Plus what > happens if schema changes in MySql ? Will BinaryObject in Ignite help in > solving my use case ? I tried to read Binary Object documentation but > couldn't get it. Please help. > > Thanks, > Sumit.
