Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 用TiDB作为数据中台是否可行?

Hello everyone, as the title suggests, does anyone have any good suggestions?
Background: In the production environment, there are many databases, mainly MySQL and MongoDB, some on Tencent Cloud and some on self-built private clouds. Currently, there is a traditional big data platform for data extraction and aggregation, but this platform is a commercial product from Tencent, and almost no one can configure and debug it. It only meets some of the data needs of the project. As the company has added new businesses, the demand for data analysis has also increased, and some reporting software has been introduced. However, these reporting software need to directly connect to the database to fetch data, relying on the performance of the original database. The current idea is to use TiDB for data aggregation, allowing colleagues who work on reports to connect to TiDB for SQL analysis and statistics. Are there any good solutions for real-time synchronization of MySQL and MongoDB data?