I am trying to configure Apache Ignite (3.0.0) as a in memory data Grid.The idea is to use it as a Cache and load data from an external RDBMS like postgres.I have a specific use case where I have some data files with XML type and TXT Type in postgres.I want to be a able to load the data in apache ignite (by setting it up as a cache) and then use it within my java and cpp applications.
The issue I am facing is that there are no clear directions and helpful material online for this specific version of apache ignite to set this up.
I have donwloaded the apache ignite 3 binaries on my machine (Linux Subsystem). I have been able to successfully set it up, start a cluster with one node. I was able to create a table with sample data using the gridGain UI and also via the IgniteTables API.
So far I have gone through the official documentation at : https://ignite.apache.org/docs/ignite3/latest/index
I have also gone through the examples in their github repository: https://github.com/apache/ignite-3/tree/main/examples
I can find alot of information regarding how to do this in 2.x version of apache ignite where the setup is done via xml/java configurations(specific reference : https://ignite.apache.org/docs/latest/persistence/external-storage#rdbms-integration).
I tried those as well but the CacheConfiguration package/classes dont seem to be avaible in the latest version(3.0.0).
Another update by GridGain is that they have moved to HOCON style confgurations so the setting up a cache via xml no longer seems applicable.
HOCON-based Configuration: Human-Optimized Config Object Notation (HOCON) is now the standard configuration language, offering a more readable and flexible alternative to XML.
I have also checked courses/videos at Gridgain university and official Youtube channel.
You would need to write a program to copy the data from your database to Ignite (and write it back if you mutate it).
Alternatively, GridGain 9, which is built on Ignite 3, has an equivalent feature to the cache store. As you note, the configuration for AI3/GG9 is very different from earlier versions.