How to modify blue/green switchover mapping

Question

My MySQL 5.6 RDS cluster is reaching end of life. I've created a blue/green deployment, as suggested in the notification. When I attempt the switchover, it returns the message, "DB instance rl-dev-e1a has a different role than rl-dev-e1a-green-r0puam" the blue role is a writer instance and the green role is a reader instance. The blue e1b is a reader instance and the green e1b is a writer instance. It appears the mappings are crossed. How do I change the mappings, so that the blue writer is mapped to the green writer and the blue reader is mapped to the green reader?

Answer

This error is because your green cluster has had a role change, the writer in that cluster switched frm one node to another node.
In order to resolve this issue you can call failover-db-cluster on the green cluster to make rl-dev-e1a-green-r0puam the writer and then blue green deployment switchover will succeed.

Thanks,

How to modify blue/green switchover mapping

Relevant content