How to synchronize data from tables in MySQL system databases using TiCDC

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

Original topic: ticdc如何同步mysql系统库中表的数据

| username: ddhe9527

I want to use TiCDC to synchronize account permission-related data such as mysql.user and mysql.db from the main TiDB cluster to the backup TiDB cluster. I tried the following rules, but none of them worked. Has anyone with experience done this before?

rules = ['*.*','mysql.*']
rules = ['*.*','mysql.db','mysql.user']
| username: dba-kit | Original post link

At present, there is no way, but I remember seeing somewhere before that it is included in the development plan.

| username: 啦啦啦啦啦 | Original post link

Indeed, it is not yet supported. We also have this requirement for disaster recovery synchronization, and currently, it is handled manually.

| username: tidb菜鸟一只 | Original post link

There is indeed no solution at the moment. If there are many users, it becomes very troublesome…

| username: yulei7633 | Original post link

Is it not possible to synchronize using system tables?

| username: 随缘天空 | Original post link

Manually export the SQL, then execute it in the new database using a database client. The data volume is not large.

| username: zhanggame1 | Original post link

Manually synchronize it.

| username: redgame | Original post link

Not supported

| username: 像风一样的男子 | Original post link

Currently not supported, you can only manually pull the synchronization yourself.

| username: lemonade010 | Original post link

Manually synchronize the data yourself.

| username: onlyacat | Original post link

Currently not supported, please submit a request to the official team.

| username: okenJiang | Original post link

| username: 霸王龙的日常 | Original post link

Not supported, the data volume of these two system tables is not large, manually synchronize them.

| username: 考试没答案 | Original post link

What requirements necessitate synchronizing the data of these tables? I usually just give up on synchronizing them and only synchronize the business tables.

| username: TiDBer_CQ | Original post link

It does not support the synchronization of system tables, so we have always used files to record user and permission management statements for execution when needed.