During the use of MySQL databases, databases and tables are usually split based on business dimensions to distribute different business data to different databases for storage. In business scenarios with large volumes of data, sharding is usually performed on the data in tables. However, if overall data analysis is required, all data needs to be aggregated, and databases and tables need to be merged.
The LibraDB engine supports synchronizing database tables from multiple databases to the same analysis cluster. The database/table merge feature aggregates data scattered across different instances, merges databases and tables, and enables analysis and queries.
Use Cases
This feature applies to scenarios where data scattered across different database instances needs to be aggregated and databases/tables need to be merged for analysis and query.
The database/table merge capability can be configured in analysis clusters of TDSQL-C for MySQL.
Database instances of TencentDB for MySQL and TDSQL-C for MySQL support database/table merge.
Multiple databases can be merged into one database.
Multiple tables can be merged into one table. Structures of these tables should be consistent.
Databases in multiple instances can be synchronized to the analysis engine for query and use by the original name.
Use Instructions