Why is there a writable instance inside a secondary region for MySQL AWS Aurora Replica?
0
votes
1
answer
200
views
I have created two Aurora MySQL clusters with two nodes in two regions using terraform. The secondary region is set up to replicate from primary region using binlog. This seems to be set up correctly,
describe-db-clusters
shows replication info and Replication source
is displayed on the secondary cluster in the Console.
What confuses me is that in the secondary region, there is a write node. I can connect to it, add data to table and it gets propagated back to primary region—and vice versa. I am specifically not using multimaster cluster (which is single-region only anyway) and I am not using global database as I want to scale to more regions. Based on AWS docs, [only global database supports write forwarding](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-global-database-write-forwarding.html) .
I only tried with manually connecting to the instances using mysql CLI as I want to understand the characteristics before using this with an application.
How is this possible? Is there any documentation? How does this setup handle update conflicts?
Asked by Almad
(101 rep)
Feb 10, 2021, 10:44 AM
Last activity: Jun 17, 2025, 07:09 AM
Last activity: Jun 17, 2025, 07:09 AM