Understanding Amazon RDS Blue/Green Deployment. Creation to Switchover !!

Learn AWS from the certified solution architect.
Understanding Amazon Blue/Green Deployment. Creation to Switchover !!

You can also refer to this blog if you prefer written format -

A blue/green deployment copies a production database environment to a separate, synchronized staging environment. By using Amazon RDS Blue/Green Deployments, you can make changes to the database in the staging environment without affecting the production environment. For example, you can upgrade the major or minor DB engine version, change database parameters, or make schema changes in the staging environment. When you are ready, you can promote the staging environment to be the new production database environment, with downtime typically under one minute.

Currently, blue/green deployments are supported only for RDS for MariaDB and RDS for MySQL.

This tutorial helps to understand -

What is Blue/Green Deployment w.r.t. Amazon RDS?
How to create blue/green deployment ?
How to switchover?
What are the changes to the environment post switchover ?
How much downtime is expected, in general using this method?

Refer this shared document for commands and script used in this tutorial -

Guys, Please subscribe if you like such technical content. Don't hesitate if you would like to share the content. Knowledge shared is knowledge squared.

-~-~~-~~~-~~-~-
Please watch: "Integrate Amazon Bedrock Foundation Models with Lambda function @AWSLearn #ai #aws #awsbedrock"
-~-~~-~~~-~~-~-

[shikri]

I am upgrading from 5.x to 8.x.
Since after switchover I cannot rollback the DB to older version, I should test first on green. But how? My service is still connecting to blue DB, right? By just being able to connect (the green db) from command line doesn't prove that my application won't fail on the upgraded DB.

[pramodpunnuche]

Appreciate your efforts!!! but Is background music required, not getting your clear voice, so please make videos without music

[saravananthambi]

This is a great video,

After successfully creating the green environment, we proceed with stage testing in that environment. During this phase, are production data synced to this green environment?

In this deployment process, I would like to incorporate adding a new column to the production database. When should we schedule this step?"

[sumankafle]

Hello Girish. Thank you for the Video. Can we follow the same to upgrade MySQL 5.7 to MySQL 8.0?

[ashutoshdange]

Cam you please cover further part of blue green depolyment. Like can we reuse the blue green after switch over or we have to again create a new blue green depolyment.

[foygrln]

Seems like the DB was unavailable for writes for much longer. Only the reads were available after 19 seconds. Or was that due to the endpoint you were referencing? For seamless switchover, would we normally implement some kind of switching or loadbalancing in front of the DB? If this is the case, what tech would you recommend for this loadbalancer?

[vijayvores]

Hi, thanks for the video.

After the completion of switch over in addition to deleting the blue environment resources, can we also delete blue/green deployment which is mentioned as a “role” in the dashboard??

Does this deletion have impact on existing green environment resources?

[muzaffarali]

Hello,
Thanks for the video.
I want to upgrade my RDS MySQL version 5.7 to 8.0.30. As per AWS docs, it seems like i need to create a new instance and then migrate/replicate the DB. Can I use Blue/Green deployment for this upgrade?

[vijayvores]

And also I would like to upgrade the major DB version of RDS MySQL (from 5.0.4 to 8.0.34) but the recommendations for older DB version shows minor upgrade and OS update, so do I need to work on these recommendations first before creating blue/green deployment or these recommendations will be automatically updated when we create blue/green deployment?

[thatisrikanth]

Can we do rollback? I feel like we need to create another blue green with lower version and then switch over correct?

[AshikDiwana]

There is no need of any replication user creation manually and no manual replication configuration?? Please clarify.

[manjunathjayam]

Can you attach those scripts which you used in this video? The script which pings db and there are other .sh scripts. Thank you

[shivajichaprana]

Do we have to use DMS here for data migration and all?