What permissions are required for users when synchronizing incrementally with TiCDC?

Translated
1

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

Original topic: TiCDC增量同步的时候，同步用户需要什么权限呢

| username: Johnpan

When configuring incremental synchronization with TiCDC, --sink-uri=“mysql://root:123456@127.0.0.1:3306/”
This sink-uri= synchronization user in the configuration, if I use a regular user, what specific permissions are needed?

【TiDB Usage Environment】Production\Testing Environment\POC
【TiDB Version】
【Encountered Problem】
【Reproduction Path】What operations were performed that caused the problem
【Problem Phenomenon and Impact】
【Attachments】

  • Relevant logs, configuration files, Grafana monitoring (https://metricstool.pingcap.com/)
  • TiUP Cluster Display information
  • TiUP Cluster Edit config information
  • TiDB-Overview monitoring
  • Corresponding module’s Grafana monitoring (if any, such as BR, TiDB-binlog, TiCDC, etc.)
  • Corresponding module logs (including logs from 1 hour before and after the issue)

If the question is related to performance optimization or troubleshooting, please download the script and run it. Please select all and copy-paste the terminal output results for upload.

2
| username: Ming | Original post link

The official documentation mentions it: TiCDC 常见问题解答 | PingCAP 文档中心

3
| username: wisdom | Original post link

When the sink is TiDB or MySQL, the downstream database user needs the following permissions:

  • Select
  • Index
  • Insert
  • Update
  • Delete
  • Create
  • Drop
  • Alter
  • Create View

If you want to synchronize recover table to downstream TiDB, Super permission is required.

4
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.