How many db connections does DMS use for full load/ CDC.

0

If we have 20 transactions on a table in a second so worst case will DMS make 20 connections for tracking transactions ?

Sarath
已提問 1 年前檢視次數 301 次
1 個回答
0

Well, the number of sessions would vary during different phases of the AWS DMS. For example, if you an AWS DMS task running in Full Load + CDC mode with the default settings of 8 tables in parallel, you will find 8 sessions during the Full Load + 1/2 sessions depending on the Source engine + 1 session for CDC phase. Meaning, it doesnt matter if you have 20 or 2000 concurrent sessions, CDC is always single threaded and replication will happen with the commit order.

Hope this helps.

AWS
D-Rao
已回答 1 年前
  • Means for full load it will have 13 sessions means (13 single threads or does it use connection pooling)

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

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

回答問題指南