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 年前808 查看次数
3 回答
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

AWS
已回答 2 年前
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.

AWS
已回答 2 年前
0

DMS absolutely can corrupt MySQL source tables. It's happened to me twice. I would back up the tables and/or not rely on DMS.

Owen
已回答 2 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则