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
已提问 1 年前1169 查看次数
2 回答
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
审核人员
philaws
已回答 1 年前
  • 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
已回答 1 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则