Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: ticdc,tidb-mysql,能同步用户和数据库吗?还是只能同步表?
If no users or databases have been created in MySQL, after establishing a changefeed, can the users and databases in TiDB be synchronized over?
TiCDC mainly focuses on the synchronization of data changes, that is, the insert, delete, and update operations of tables in TiDB. It does not directly synchronize the users and database structure in TiDB. This is because TiCDC primarily focuses on the data layer, not the metadata or structure layer.
TiCDC should be incremental transmission, only transmitting the changed parts. It needs to be paired with full initialization.
Best practices can be referenced here:
Can only synchronize tables.
TiCDC is incremental synchronization, synchronizing incremental table data, and the target needs to be initialized.
It can only synchronize tables.