We have requirement to load the CDC events from source to KAFKA(it can be using GG/HVR etc) and from KAFKA to SingleStore.
Please could you confirm,
- How to process the CDC events from KAFKA topics to SingleStore? Can we do using SingleStore Pipelines?
- How the updates applied on SingleStore if a records already available on SingelStore?
- Can we apply these changes from one SingleStore data base to other SingleStore data base and how?
- Please suggest different available approach to apply changes from one data base to other data base and what are the complexities involved.
- It would be great if you provide usecase(with relevant screenshots) to process CDC events from KAFKA to SingleStore.