Replicating AWS RDS Aurora Reader to External MySql Instance
I want to use AWS aurora replica as master for external MySQL instance.
I created an aurora instance and a read replica with a DB cluster parameter with BinLog enabled.
Replication from writer is working fine, but I cannot see the bin_log ON setting to read the replica.
Is there a way we can achieve this?
source to share
I tried to contact AWS to achieve this and I found out that replicating Aurora Replica to an external mysql instance is not possible.
For replication, we need to disable read-only mode or enable GTID so that we can configure Master-Master replication, but at the moment in aurora all nodes will read data from the same cluster volume and only write node can write to database. Because of this, it is not possible to disable the read_only option on the Aurora replica. Also GTID replication is currently not supported in RDS Aurora.
source to share