RDS Blue/Green Deployment

Question

I have setup a Blue/Green Deployment for the DB instance restored from the production. 
The replication from Blue to Green works when I created a table in Blue, Green got it.
According to the documentation (Overview of Amazon RDS Blue/Green Deployments)[https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/blue-green-deployments-overview.html#blue-green-deployments-major-steps]

> You can make changes to the RDS DB instances in the green environment without affecting production workloads.

But I am not able to make schema changes on the Green as it is set to read-only.
If I am to set the Green to read-only=0, should I also turn off the replication so that the schema change will not be overwritten?
But if the replication is turned off, when I switch over the changes made to Blue Production will be lost.

Answer

I assume this is mysql or Aurora mysql? 
You can make changes to green by setting read_only=OFF. This is by design to allow for common maintenance tasks on green (such as converting a PK from int to bigint). However you also have to be careful not to make any changes that would otherwise break the binlog replication. Example if you dropped a table on green that might break replication to green.

RDS Blue/Green Deployment

相关内容