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 個月前

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

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

回答問題指南