By using AWS re:Post, you agree to the Terms of Use
/Does AWS DMS has any way to touch or modify source tables?/

Does AWS DMS has any way to touch or modify source tables?

0

I created several Full load, ongoing replication task DMS tasks to copy data from a VPS MySQL server to RDS MySQL, and after some tweaks (time zone config, collations, etc) I was able to get everything working as expected and replicating data effectively.

Yesterday however some tables were truncated in my source MySQL database (TRUNCATE table_name). The table statistics in the DMS task did detect a DDL change as appreciated in the below screenshot:

https://i.postimg.cc/q7wsxsZc/Screen-Shot-2022-05-24-at-17-41-01.png

I was able to get the TRUNCATE commands from the MySQL binlog.

Questions:

  • Is there any way that DMS could have been the culprit in literally truncating my source tables? My tasks don't even have the preparation mode TRUNCATE, I have DO NOTHING.
  • I didn't find any way in the configs or in the docs but, does DMS have a way to affect source tables?

Edit:

I get the feeling that the VPS server got hacked. But I haven't been able to confirm if that's the case.

Edit 2:

Even some tables DMS didn't know about (were not included in the table mappings) got truncated as well.

2 Answers
1

Hi AWS-User-6348262,

DMS uses unidirectional replication from the source DB to the target DB. DMS will not update or delete any data in your source DB.

Hope that helps!

Best, Sean

answered a month ago
0

DMS wont write or truncate any source user db tables. In some engine types it would create extra tables to capture ongoing changes but in that case also it wont truncate tables.

answered a month ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions