By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

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 ?

Topics
Migration & ModernizationDatabase
Tags
AWS Database Migration ServiceAurora PostgreSQL
Language
English
Sarath
asked a year ago290 views
1 Answer
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
answered a year ago
  • Sarath
    a year ago

    Means for full load it will have 13 sessions means (13 single threads or does it use connection pooling)

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content