AWS RDS Aurora Reader Replication to External MySql Instance

Question

I want to use AWS aurora replica as a master for external MySQL instance.

I have created an aurora instance and a read replica with BinLog enabled DB cluster parameter.

Replication from writer is working fine but I am not able to see bin_log parameter ON for read replica.

Is there any way by which we can achieve this?

Answer 1

I have tried contacting AWS to achieve this and I got to know that It is not possible to replicate from the Aurora Replica to the external mysql instance.

For replication, we need to turn off the read-only or turn on GTID so that we can setup Master-Master replication but at the moment in aurora all the nodes will read the data from the same cluster volume and only write node can perform writes on the database. Because of this it is not possible to disable the read_only option in Aurora replica. Also GTID replication is not currently supported in RDS Aurora.