Connector Improvement: Feature Request: Support for WAL-Based Logical Replication from Aurora Read Replicas
AnsweredHello Fivetran Team,
I would like to request support for enabling WAL-based logical replication from an Aurora PostgreSQL read replica.
Current Limitation
At the moment, Fivetran requires connecting to the writer (primary) instance to use WAL-based logical replication for Aurora PostgreSQL. This creates operational challenges because:
-
Running WAL-based CDC on the primary adds load to the writer node.
-
Many organizations (including ours) prefer to isolate analytical workloads on reader instances.
-
Query-based/XMIN-based replication on a replica is significantly more resource-intensive and less reliable for high-volume databases.
Feature Request
Please add support for reading replicated WAL from an Aurora reader instance, allowing logical replication to occur without impacting the writer node.
Important context: Aurora already supports logical replication of WAL on both primary and replicated nodes (https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Replication.Logical.Configure.html). Reader instances maintain the WAL stream internally, but Fivetran currently does not allow sourcing logical replication from a replica.
Why This Matters
-
Reduces load on the primary Aurora writer node.
-
Improves reliability and scalability of CDC pipelines.
-
Enables organizations with large workloads to run efficient incremental syncs without risking production performance.
-
Aligns with the architecture of high-availability Aurora clusters, where replicas are meant to offload non-critical workloads.
Implementing this feature would enable us and many other Aurora users to adopt a more stable, scalable architecture for CDC.
Thank you for considering this enhancement.
Best regards,
Konstantin.
-
Official comment
Hi Konstantin,
Thanks for sharing your request. Subscribing to logical replication on a replica is a feature that was introduced in Postgres 16, but to my knowledge it hasn't been adopted by Aurora yet. The link you provided explicitly instructs "to connect to the writer instance". So while I fully agree that this would be a valuable addition to Fivetran, we have to treat it as an Aurora limitation at this point.
If I'm missing something and you have any evidence of otherwise, please let me know - we will be happy to consider supporting this.
Thanks,
Val Kulichenko, Fivetran Product Team
Please sign in to leave a comment.
Comments
1 comment