asikarwar
3 months agoNeophyte
Data Source Consolidation and Transition Strategy
Hello,
Current Situation:
- We have multiple data sources across different data centers for monitoring metrics such as CPU, Memory, Disk, Network, and others. Currently, these are managed separately, leading to a fragmented view of the data.
Objective:
- Our goal is to consolidate and standardize these data sources so that eventually, we will have a single data source for each metric (e.g., CPU, Memory) across all data centers. This consolidation will allow us to bring all relevant data under one dashboard without needing to create multiple tables for each metric (since each table can only have one data source).
Challenges:
- One of the main challenges is the potential data loss when moving devices from one data source to another. If the data source is changed, the historical data may be deleted, which is a significant concern during the transition.
Proposed Solution:
- To mitigate this risk, I am considering using Kafka to send a duplicate stream of data. This would create a redundant data source that could be used until the transition to the consolidated data source is fully complete. This approach would ensure that no data is lost during the transition and provide a safety net as we standardize our monitoring setup.
Request for Guidance:
- I am seeking advice on the best way to proceed with this consolidation and transition process. Specifically, I would like to know:
- The most efficient way to standardize data sources across all data centers.
- How to effectively use Kafka or another method to maintain data integrity during the transition period.
Thanks,