跳至內容

Is ok to have multiple Serverless replications in DMS using the same source endpoint migrating the same table more than once?

0

Is ok to have multiple Serverless replications in DMS using the same source endpoint migrating the same table more than once?

已提問 2 年前檢視次數 264 次

2 個答案
0
已接受的答案

It shouldnt be a issue as serverless tasks run independently. I assume you are using different target destination db or tables or else you may have to check the target for duplicate issues or pk violations

AWS

已回答 2 年前

0

Yes, it is generally acceptable to have multiple AWS DMS Serverless replications using the same source endpoint and migrating the same table more than once. However, there are some important considerations to keep in mind:

  1. Resource utilization: Each serverless replication will consume resources independently. While AWS DMS Serverless automatically manages capacity, having multiple replications of the same data may lead to increased resource usage and potentially higher costs.

  2. Storage limitations: AWS DMS Serverless provides a static 100GB allocated storage for each replication. If your replications collectively require more memory than this, due to factors like long-running transactions or caching, you might encounter issues.

  3. Workload partitioning: In some cases, partitioning your workload into separate serverless replications can be beneficial. For example, you might want to separate replications involving LOBs (Large Objects) or partition by table requirements.

  4. Performance impact: Multiple replications reading from the same source tables could potentially impact the performance of the source database, depending on its capacity and current load.

  5. Consistency: Ensure that your multiple replications are configured consistently to avoid discrepancies in the migrated data.

While it's technically possible to have multiple serverless replications using the same source endpoint and migrating the same table more than once, it's important to carefully consider your specific use case and requirements. You should evaluate whether this approach is the most efficient and cost-effective for your migration needs.
Sources
Working with AWS DMS Serverless - AWS Database Migration Service
AWS DMS Serverless limitations - AWS Database Migration Service

已回答 2 年前

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

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