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년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인