How to enable Logical Replication for existing Aurora PG 13 Cluster?
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.
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.
Thanks for confirming!
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
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?
Aurora Postgres 13 with IAM Auth - Unable to establish logical replication connectionasked 5 months ago
Aurora PostgreSQL Replica Pricingasked 2 years ago
RDS PostgreSQL cascading replication for Fivetran integration (logical replication not working on replica)asked 4 days ago
How to enable Logical Replication for existing Aurora PG 13 Cluster?asked 6 months ago
SSL replication between Aurora clustersAccepted Answerasked 3 years ago
Missing Aurora Function after upgrade from aurora pg 12 to pg 13asked 3 months ago
Aurora Postgres - Logical Replication with different databases in same instanceasked 3 months ago
Unable to configure Multi AZ deployment for existing Aurora MySQLAccepted Answerasked 2 months ago
(Serverless) Amazon Aurora MySQL 1 end of life on February 28, 2023asked 2 months ago
Granular per-instance access in an Aurora DB clusterasked a month ago