Document a custom resource solution for AutoMinorVersionUpgrade property under AWS::RDS::DBInstance resource

[vmusaa]

Name of the resource

AWS::RDS::DBInstance

Resource name

AWS::RDS::DBInstance

Reference Link

1. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Maintenance.html
2. https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-resource-rds-dbinstance.html

Details

The AWS::RDS::DBInstance resource results in drift when the AutoMinorVersionUpgradeproperty is set to true and there is a minor version update. This causes the stack to go into drift.

Documentation Request -

1. An update to the documentation for AutoMinorVersionUpgrade (doc) parameter that it may result in drift due to out of band changes and the user needs to keep the template updated with current version of the DB instance.

2. Document a solution with a sample custom resource implementation which queries the current version on the instance and passes it to the AWS::RDS::DBInstance resource. In real world, it is usually not a single ops engineer who manages cloud formation templates, and it is difficult for customers to be already be aware of such an issue to occur in future and co-ordinate when it is not documented. Hence, it would be great to have this custom solution or a similar workaround documented either as an AWS Doc or an AWS Blog.

Documents/pages where this custom resource solution can be added -

1. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Maintenance.html
2. https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-resource-rds-dbinstance.html #https://github.com/awsdocs/aws-cloudformation-user-guide/issues

[rgoltz]

Hi @vmusaa - Maybe we should create and link a issue with https://github.com/awsdocs/aws-cloudformation-user-guide/issues for this?

[vmusaa]

Hi @rgoltz, I have linked the issue to https://github.com/awsdocs/aws-cloudformation-user-guide/issues as requested.

[vmusaa]

Closed by mistake, re-opened it.

[vmusaa]

#https://github.com/awsdocs/aws-cloudformation-user-guide/issues

[vmusaa]

#https://github.com/awsdocs/aws-cloudformation-user-guide/issues/1273

Created a new issue in repository - https://github.com/awsdocs/aws-cloudformation-user-guide/issues to gain correct visibility.

[osdrv]

@vmusaa could you please confirm the issue still persists? If I understand it correctly, the drift is detected on the EngineVersion attribute? If so, we landed a fix: https://github.com/aws-cloudformation/aws-cloudformation-resource-providers-rds/pull/390. I wonder if it solves the issue.