How can I configure AWS RDS Aurora reader to writer so that it works like multi master?

Question

We are using AWS RDS Aurora for our application and using a read replica to read the data from the database.

We now want to use this read replica as the writer so that we can also write to this reader instance and data will be synced between them. Hence, to use it as multi-master replication.

Is there a way to achieve this?

I have tried to enable the read_only to false but the parameter is not modifiable. Ref: aws.amazon.com/premiumsupport/knowledge-center/rds-read-replica Screenshot: ibb.co/d5SCMQ — m0hit

m0hit m0hit · Accepted Answer · 2017-04-12T08:39:34

Unfortunately, the read_only parameter group setting for Aurora databases is not editable like it is for a MySQL parameter group.

Ref: https://forums.aws.amazon.com/thread.jspa?messageID=746263&#746263

How can I configure AWS RDS Aurora reader to writer so that it works like multi master?

1 Answers