RDS Blue/Green Deployment

0

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.

profile picture
Lottie
asked a month ago210 views
1 Answer
0

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.

AWS
MODERATOR
philaws
answered a month ago
profile picture
EXPERT
reviewed a month ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions