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.

posta 2 anni fa808 visualizzazioni
3 Risposte
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
con risposta 2 anni fa
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
con risposta 2 anni fa
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
con risposta 2 mesi fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande