@@AWSLearn I am trying to create blue/green deployment for RDS postgress which don't have replica. It is giving me error "Database 'arn:aws:rds:us-east-1:XXXXXXXXXXXX:db:test' is not supported: Blue/Green Deployments require a DB instance with logical replication enabled. Before you create a Blue/Green Deployment for a DB instance, associate the DB instance with a custom DB instance parameter group that enables logical replication."
@jayeshpatel1914 this error is seen when the logical replication is turned off (rds.logical_replication=0) which is a default setting. You create a new parameter group with rds.logical_replication=1 and modify instance to use the newly created parameter group. This should help to resolved the issue. Hope this helps. Let me know how it goes for you. You can check earlier video on this channel if you want to see how to change parameter group.
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.
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?"
hi, sorry for late reply. Let us know your testing experience if you attempted changes on green environment. That will help others as well. In general, AWS suggests to avoid any changes to green environment which are not replication compatible. That could break replication. You may find these best practices handy docs.aws.amazon.com/AmazonRDS/latest/UserGuide/blue-green-deployments-overview.html#blue-green-deployments-best-practices
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.
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?
RDS blue green deployment feature provides option to specify timeout, say if switchover does not complete in certain time, it’ll rollback. No manual intervention needed. However if you gone live on new environment with data changes on new production and decided to rollback now, then that’s tricky. Don’t think there is any easy option. I’m not certain if can downgrade as part of blue green deployment, very unlikely. You will have your blue environment intact if ok to use that , usually you should test on new environment and connect production applications if all ok. Hope that make sense.
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?
No. I observed endpoint was readonly momentarily during switchover, however switchover did take around 19 seconds and that would be actual downtime. Per AWS document, switchover is expected to complete within 1 min. Still depends on workload during switchover though.
@@AWSLearn Ah yes, I understand thank you for your reply. At 15:45 I mistakenly thought that the errors were continuously coming, in fact they had stopped after the 19 seconds.
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?
I believe you should be able to use available version upgrades using blue/green deployment. I don't see 8.0.30 available in RDS service. check it once. FYI.. I do see this documented restrictions about few MySQL versions for blue/green deployment. "MySQL versions 8.0.11 through 8.0.13 have a community bug that prevents RDS from supporting them for blue/green deployments." Refer: docs.aws.amazon.com/AmazonRDS/latest/UserGuide/blue-green-deployments-overview.html#blue-green-deployments-limitations
Sure. Please see if you are able to access. drive.google.com/file/d/1j0Yr-HiDvZ6V3m5-_diKYoevULFvkEnz/view?usp=sharing I've also put the link in the description. Hope that helps.
i am getting this error Database 'arn:aws:rds:us-east-1:891519951990:db:blue-green-poc2' is not supported: Blue/Green Deployments require a DB instance with logical replication enabled. Before you create a Blue/Green Deployment for a DB instance, associate the DB instance with a custom DB instance parameter group that enables logical replication.@@AWSLearn
i am doing rds upgrade like you did, using blue-green deployment feature, my db configuration is not multi-az, how can i contact you? can you give me your email or phone number. thank you
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?
No so long as the user you are using to access your account has required permissions. The document has clear guidance on what permissions are needed for each stage of blue/green deployment. Just for your quick reference right from the document- The user who creates a blue/green deployment must have permissions to perform the following RDS operations: rds:AddTagsToResource rds:CreateDBInstanceReadReplica The user who switches over a blue/green deployment must have permissions to perform the following RDS operations: rds:ModifyDBInstance rds:PromoteDBInstance The user who deletes a blue/green deployment must have permissions to perform the following RDS operation: rds:DeleteDBInstance
Quality content!
Thank you for your feedback.
Thank you. This is awesome
Thanks for your feedback.
Very Nice Video
Thank you Jayesh for your feedback. Good to know you liked the video.
@@AWSLearn I am trying to create blue/green deployment for RDS postgress which don't have replica. It is giving me error "Database 'arn:aws:rds:us-east-1:XXXXXXXXXXXX:db:test' is not supported: Blue/Green Deployments require a DB instance with logical replication enabled. Before you create a Blue/Green Deployment for a DB instance, associate the DB instance with a custom DB instance parameter group that enables logical replication."
@@jayeshpatel1914 which postgresql version you are using? I haven't seen this error but will try if can reproduce.
@jayeshpatel1914 this error is seen when the logical replication is turned off (rds.logical_replication=0) which is a default setting. You create a new parameter group with rds.logical_replication=1 and modify instance to use the newly created parameter group. This should help to resolved the issue. Hope this helps. Let me know how it goes for you. You can check earlier video on this channel if you want to see how to change parameter group.
Hello Girish. Thank you for the Video. Can we follow the same to upgrade MySQL 5.7 to MySQL 8.0?
Were you able to do it ? I'm planning to do the same and since it is a major upgrade. Want to know any hiccup that might come up
@@theanatomyofreliability2168 Even I need to do it today. And I have another question, after a switchover, can we do a rollback?
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.
Appreciate your efforts!!! but Is background music required, not getting your clear voice, so please make videos without music
Thank you Pramod. Absolutely. I understand and next time, will take care . I appreciate your feedback.
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?"
hi, sorry for late reply. Let us know your testing experience if you attempted changes on green environment. That will help others as well.
In general, AWS suggests to avoid any changes to green environment which are not replication compatible. That could break replication. You may find these best practices handy docs.aws.amazon.com/AmazonRDS/latest/UserGuide/blue-green-deployments-overview.html#blue-green-deployments-best-practices
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.
You may not be able to reuse post switch over and have to recreate blue environment.
very usefull make more video
Thank you for your feedback. Nice to see you liked this video.
Hi Girish,
i believe you were part of PepsiCo, How are you?
Hey yes I was. I’m doing good. How are you doing? Can you please send email to girish.mukim@gmail.com
Would love to connect
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?
I’ll have to test this out. Do you see both the versions are supported in RDS? Can you check that once.
Yes, both the versions are supported in RDS
@@vijayvores3993i have also same requirement bro...can you please tell me the procedure to upgrade mysql 5.7 to 8.0
Can we do rollback? I feel like we need to create another blue green with lower version and then switch over correct?
RDS blue green deployment feature provides option to specify timeout, say if switchover does not complete in certain time, it’ll rollback. No manual intervention needed. However if you gone live on new environment with data changes on new production and decided to rollback now, then that’s tricky. Don’t think there is any easy option. I’m not certain if can downgrade as part of blue green deployment, very unlikely. You will have your blue environment intact if ok to use that , usually you should test on new environment and connect production applications if all ok. Hope that make sense.
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?
No. I observed endpoint was readonly momentarily during switchover, however switchover did take around 19 seconds and that would be actual downtime. Per AWS document, switchover is expected to complete within 1 min. Still depends on workload during switchover though.
@@AWSLearn Ah yes, I understand thank you for your reply. At 15:45 I mistakenly thought that the errors were continuously coming, in fact they had stopped after the 19 seconds.
You are welcome. It’s good to clarify doubts.Your comments would help someone. Thanks.
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?
I believe you should be able to use available version upgrades using blue/green deployment. I don't see 8.0.30 available in RDS service. check it once. FYI.. I do see this documented restrictions about few MySQL versions for blue/green deployment. "MySQL versions 8.0.11 through 8.0.13 have a community bug that prevents RDS from supporting them for blue/green deployments." Refer: docs.aws.amazon.com/AmazonRDS/latest/UserGuide/blue-green-deployments-overview.html#blue-green-deployments-limitations
make more video related to devops
Thank you
Can you attach those scripts which you used in this video? The script which pings db and there are other .sh scripts. Thank you
Sure. Please see if you are able to access.
drive.google.com/file/d/1j0Yr-HiDvZ6V3m5-_diKYoevULFvkEnz/view?usp=sharing
I've also put the link in the description. Hope that helps.
@@AWSLearn thank you so much, I really appreciate 🙏🙏
@manjunathjayam4895 you’re welcome
i am getting this error Database 'arn:aws:rds:us-east-1:891519951990:db:blue-green-poc2' is not supported: Blue/Green Deployments require a DB instance with logical replication enabled. Before you create a Blue/Green Deployment for a DB instance, associate the DB instance with a custom DB instance parameter group that enables logical replication.@@AWSLearn
i am doing rds upgrade like you did, using blue-green deployment feature, my db configuration is not multi-az, how can i contact you? can you give me your email or phone number. thank you
Decent
Thank you
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?
I think once you delete blue environment, deployment won’t exist. Don’t think you need an extra step there.
Do we have to use DMS here for data migration and all?
No. We don’t. Replication is managed internally by AWS.
What chair do you use?
FlexFit Hyken Mesh Task Chair with Adjustable Arms. Hope this answers your question😀.
There is no need of any replication user creation manually and no manual replication configuration?? Please clarify.
No so long as the user you are using to access your account has required permissions. The document has clear guidance on what permissions are needed for each stage of blue/green deployment. Just for your quick reference right from the document-
The user who creates a blue/green deployment must have permissions to perform the following RDS operations:
rds:AddTagsToResource
rds:CreateDBInstanceReadReplica
The user who switches over a blue/green deployment must have permissions to perform the following RDS operations:
rds:ModifyDBInstance
rds:PromoteDBInstance
The user who deletes a blue/green deployment must have permissions to perform the following RDS operation:
rds:DeleteDBInstance