DM Data Source: Upstream Password Modified

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

Original topic: dm 数据源,上游密码修改了。

| username: 考试没答案

【TiDB Usage Environment】Production Environment / Testing / PoC
【TiDB Version】
【Reproduction Path】What operations were performed when the issue occurred
【Encountered Issue: Problem Phenomenon and Impact】DM data source, the upstream password has been changed. How to modify the configuration of the already bound data source
【Resource Configuration】Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
【Attachments: Screenshots/Logs/Monitoring】

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

How can I modify the bound data source configuration to change the upstream password “oracle”?

| username: 裤衩儿飞上天 | Original post link

  1. pause-task
  2. modify configuration
  3. resume-task
| username: 考试没答案 | Original post link

Which command is used to modify the configuration? Could you please provide more details?

| username: rebelsre | Original post link

After stopping the task, stop the data source, change the password, and then recreate the data source.

| username: DBAER | Original post link

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

Wouldn’t it be too drastic to recreate the data source???

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

The database source does not support modifications; it can only be deleted and recreated, as long as the source name remains unchanged.

| username: dba-kit | Original post link

The data source does not support modification. You can create a new data source, then change the source-id in the task configuration (GTID also needs to be changed accordingly), and restart the task with stop-task/start-task to make the task use the new data source. After that, refer to this document to delete the original source-id.

However, this operation step is obviously simpler, but it will cause the DM task to be delayed by a few minutes. It is best to execute it during off-peak hours.

| username: Hacker_PtIIxHC1 | Original post link

You need to stop the task and rebind it, or create a new data source and change the source-id in the task configuration file to the new one.

| username: xiaoqiao | Original post link

Pause the task, modify the configuration, and then restart to see.

| username: TiDBer_21wZg5fm | Original post link

The database source cannot be modified; it can only be deleted and recreated while keeping the data source name unchanged.

| username: zhang_2023 | Original post link

Recreate the data source after changing the password.

| username: 友利奈绪 | Original post link

It seems that it can only be deleted and rebuilt.

| username: dba远航 | Original post link

DM needs to be reconfigured.

| username: 舞动梦灵 | Original post link

You can recreate a task, just remember this binlog and pos value. The task name can be the same or different.

| username: 小于同学 | Original post link

  1. pause-task
  2. Modify configuration
  3. resume-task
| username: terry0219 | Original post link

Learned.

| username: zhaokede | Original post link

Modify the configuration and start over.

| username: system | Original post link

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