Looking for guidance on Memsql capabilities as a beginner to understand. Memsql is proposed for Fast Data Access for in memory operations and same data is maintained in respective source DBs. Proposed solution is get the updated events through Micro services to Memsql after the initial load from oracle DB. Also there could not be any integration between source DB to memsql. explored whitepapers /blog to get the exact details and need assistance in this regard.
- Initial data sourcing from Oracle exadata to Memsql. Is it done through load data utility with .csv? if yes, what are all options are available for each entity which is combination of multiple oracle source tables.
- Incremental data sourcing in case a new attribute/colum is added to the model. How we have to reflect these new columns data which exists in Memsql DB.
- How to reflect the data fixes applied at source DB in Memsql.