replacing source endpoint for DMS Replication

0

Hello we have DMS Replication task that copy data from mysql to S3 in an ongoing replication task based on CDC (Binlogs) . we need to replace the source mysql server , to a stronger hardware. we will replace it with new server having the same IP and name end with the data replicated from the old server. but the binlog in the new server is located in different location and i need to find a way to update the replication task to start from specific point in the binlog. when stopping the replication takss i can see the CDC setting for the stop point but i dont see any way to modify it or change it. van someone guide me in whet should be the process of replacing server of the DMS source endpoint and modifying the start point when resuming the task. thanks

avishni
已提問 3 個月前檢視次數 177 次
1 個回答
0

Thank you for your question.

You should be able to perform planned database changes, update the binlog path, and resume the database migration task without specifying a start point. However, ensure that the binary logs are available to AWS DMS for processing change data capture (CDC).

Detailed steps on how to change binlog path are outlined as follows:

  1. Stop the DMS migration task after you have confirmed that the source and target latency are in sync, whenever possible.
  2. Check current log-bin path and naming format.

show variables like '%log_bin%';

  1. Change the log-bin path in my.cnf file as below log_bin = new_path/naming_format.
  2. Shutdown your mysql server.
  3. Move your bin log files from previous location to new location.
  4. Star you mysql server.
  5. From here you will be able to resume DMS migration task.

Moving forward, if you wish to initiate a DMS migration task from a specific point, you can consider using a checkpoint or a CDC start point as a CDC starting point by creating a CDC-only task. For a detailed, step-by-step guide on this concept, please see: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Task.CDC.html#CHAP_Task.CDC.StartPoint.Checkpoint

AWS
支援工程師
已回答 3 個月前
profile picture
專家
已審閱 1 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南