How to handle TiDB multi-tenancy synchronization to MySQL using TiCDC? (Solved)

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tidb多租户利用ticdc同步到mysql怎么处理呢？（已解决）

| username: hazel

How to handle synchronizing TiDB multi-tenancy to MySQL using TiCDC? MySQL does not support multi-tenancy, so what will happen to the tenants in TiDB when synchronized to MySQL?

2
| username: 小龙虾爱大龙虾 | Original post link

The multi-tenant solution in TiDB mainly involves resource control to limit the resource usage of different users. Different tenants essentially have different schemas, allowing different businesses to run stably on a single cluster. Therefore, there are no issues when it comes to MySQL.

3
| username: Jack-li | Original post link

The iCDC (TiDB Change Data Capture) component implements real-time data synchronization to MySQL.

4
| username: zhanggame1 | Original post link

TiDB also does not have multi-tenancy.

5
| username: FutureDB | Original post link

I don’t understand, why would TiDB’s multi-tenancy affect synchronization to MySQL? Aren’t you synchronizing table data?

6
| username: ziptoam | Original post link

You can directly synchronize the business table, there’s no need to synchronize the user table.

7
| username: yulei7633 | Original post link

Normal synchronization will do, distinguish multiple tenants by different database names.