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

How to enable Logical Replication for existing Aurora PG 13 Cluster?

0

We are considering enabling logical (streaming) replication on our existing Aurora PG 13 cluster for CDC?

We want to keep our aurora read replicas as is, but I haven't found good resource that explains how to achieve both, OR what is the implication for existing read replicas.

Our current understanding is that we might have to stand up 2x current nodes in our cluster which would be way too expensive for us.

Topics
DatabaseAnalytics
Tags
PostgreSQLAurora PostgreSQLAmazon Aurora
Language
English
AWS-User-4365303
asked 2 years ago1494 views
2 Answers
2

You can enable logical replication by setting the parameter rds.logical_replication parameter in Cluster Parameter group. There will not be any impact on the existing Aurora replicas/reader instances in the cluster. Additionally, you do not need to add new instances in the cluster just because the logical replication is enabled.

Refer - https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Replication.html#Aurora.Replication.AuroraPostgreSQL

AWS
prasanth_aws
answered 2 years ago
EXPERT
John_F
reviewed 2 years ago
2

Thank you for reaching out. Since you mentioned CDC, I will also recommend you to review this document since it provides guidance on the enabling Logical replication for CDC. [Using a PostgreSQL database as an AWS DMS source - Enabling change data capture (CDC) using logical replication - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html#CHAP_Source.PostgreSQL.Security

AWS
SUPPORT ENGINEER
Arnab_S
answered 2 years ago
  • AWS-User-4365303
    2 years ago

    Thanks @arnab, the intention is to run CDC indefinitely (i.e we are not just migrating DB), does DMS still solve the problem cleanly and cost effectively?

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