I have a single RDS cluster. This cluster has two instances, one in each zone. Naturally, one "replication role" reader and one writer.
I manually triggered a failover of the main instance from the RDS console "Instance actions" menu. After doing so, the console eventually showed this change including the swap of reader and writer roles. However, the replica instance remained read only so all writes were failing. This replica instance's Parameter Group settings have read_only:TrueIfReplica.
What other information can I provide to clarify my configuration or issue?
Any clues on why this replica instance stayed read only?
If this is the expected behavior of read_only:TrueIfReplica, where else should I look to fix my configuration?