Can TiCDC and TiDB-MySQL synchronize users and databases, or can they only synchronize tables?

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

Original topic: ticdc,tidb-mysql,能同步用户和数据库吗?还是只能同步表?

| username: hazel

If no users or databases have been created in MySQL, after establishing a changefeed, can the users and databases in TiDB be synchronized over?

| username: zhaokede | Original post link

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.

| username: Kongdom | Original post link

TiCDC should be incremental transmission, only transmitting the changed parts. It needs to be paired with full initialization.

Best practices can be referenced here:

| username: 濱崎悟空 | Original post link

Can only synchronize tables.

| username: 鱼跃龙门 | Original post link

TiCDC is incremental synchronization, synchronizing incremental table data, and the target needs to be initialized.

| username: TiDBer_QYr0vohO | Original post link

Users not synchronized

| username: 友利奈绪 | Original post link

It can only synchronize tables.