replacing source endpoint for DMS Replication

Question

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

Answer

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%';
3. Change the log-bin path in my.cnf file as below log_bin = new_path/naming_format.
4.  Shutdown your mysql server.
5.  Move your bin log files from previous location to new location.
6. Star you mysql server.
7. 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

replacing source endpoint for DMS Replication

Relevant content