Migrating catalog table to Aurora Mysql target

0

Hi, I have a source database in Aurora Mysql created in 2014. We enable binlogs in this instance to use the DMS service on June 20, 2020. I want to move some catalog tables from my source database to my target database(also an Aurora Mysql instance) but although the replication task works perfectly and no error logs are shown on CloudWatch related to the task, the table is not created at my target database. This catalog table hasn't been edited since 2014(before the date when we enable binlogs) so my guess is that there is a problem related to the available binlogs for that table( it hasn't been edited so it hasn't had binlogs related) so the DMS ignores the table. Also, I have tried:

  1. Creating a replication task with a table that has been edited after June 20. It works perfectly and the table is replicated to the target database.
  2. Creating a replication task for a table that doesn't exist at my source endpoint. I received the same behavior; the replication task works perfectly, no error logs are shown at CloudWatch and the table doesn't exist at the target database (This was the expected behavior but I would have expected that an error would have been triggered letting me know that the table didn't exist at the source endpoint.

Any thoughts at this behavior?

Edited by: fahernandez on Jul 2, 2020 5:02 PM

已提問 4 年前檢視次數 189 次
1 個回答
0

It was an error while giving permission to the source database user. When the source table in the database doesn't exists or doesn't have enough permission. the process will run successfully but the table won't be migrated.

已回答 4 年前

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

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

回答問題指南