How to enable write operations on Mysql RDS green environment

0

Hi Team,

After you create the blue/green deployment, the DB instance in the green environment is read-only by default. Can anyone help How to enable write operations on Mysql RDS green environment.

vglobal
asked a year ago1002 views
2 Answers
0

Yes, you can create a custom parameter group with read_only=0, and then apply this to the green environment. This will allow you to make changes to green. However please do be careful that you do not make changes that will break the replication from blue. -Phil

AWS
MODERATOR
philaws
answered a year ago
  • My green environment parameter group already has read_only=0 and is still read only.

    We need to do this in order to test the new configuration as our software writes session tokens to the database. We won't run into replication conflicts as we will be using a database that isn't in use in the Blue environment

0

When you create a blue/green deployment for an RDS MySQL instance, the DB instance in the green environment is created as a read-only replica of the DB instance in the blue environment. This is to ensure that any changes made during the deployment process do not affect the production database until the green environment has been fully tested and approved for production use.

**What are you trying to achieve? **

From [https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/blue-green-deployments-overview.html] (Overview of Amazon RDS Blue/Green Deployments) :

During testing, we recommend that you keep your databases in the green environment read only. We recommend that you enable write operations on the green environment with caution because they can result in replication conflicts in the green environment. They can also result in unintended data in the production databases after switchover.

profile pictureAWS
Niko
answered a year 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