Responding to Amazon RDS recommendations - Amazon Relational Database Service

Responding to Amazon RDS recommendations

From the list of RDS recommendations, you can:

  • Apply a configuration based recommendation immediately or defer until the next maintenance window.

  • Dismiss one or more recommendations.

  • Move one or more dismissed recommendations to active recommendations.

Applying an Amazon RDS recommendation

Using the Amazon RDS console, select a configuration based recommendation or an affected resource in the details page, and apply the recommendation immediately or schedule it for the next maintenance window. The resource might need to restart for the change to take effect. For a few DB parameter group recommendations, you might need to restart the resources.

The threshold based proactive or anomaly based reactive recommendations won't have the apply option and might need additional review.

To apply a configuration based recommendation
  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. In the navigation pane, perform any of the following:

    • Choose Recommendations.

      The Recommendations page appears with the list of all recommendations.

    • Choose Databases and then choose Recommendations for a resource in the databases page.

      The details appear in the Recommendations tab for the selected recommendation.

    • Choose Detection for an active recommendation in the Recommendations page or the Recommendations tab in the Databases page.

      The recommendation details page appears.

  3. Choose a recommendation, or one or more affected resources in the recommendation details page, and do any of the following:

    • Choose Apply and then choose Apply immediately to apply the recommendation immediately.

    • Choose Apply and then choose Apply in next maintenance window to schedule in the next maintenance window.

      The selected recommendation status is updated to pending until the next maintainance window.

      An active recommendation selected and Apply button with its options highlighted in the console.

    A confirmation window appears.

  4. Choose Confirm application to apply the recommendation. This window confirms whether the resources need an automatic or manual restart for the changes to take effect.

    The following example shows the confirmation window to apply the recommendation immediately.

    The confirmation window in the console to apply the recommendation immediately

    The following example shows the confirmation window to schedule applying the recommendation in the next maintenance window.

    The confirmation window in the console to schedule applying the recommendation in the next maintenance window

    A banner displays a message when the recommendation applied is successful or has failed.

    The following example shows the banner with the successful message.

    A banner in the console showing the message with the number of resources that will apply the recommendation

    The following example shows the banner with the failure message.

    A banner in the console showing the message with the resource that failed to apply the recommendation and the reason for the failure
To apply a configuration based RDS recommendation using the Amazon RDS API
  1. Use the DescribeDBRecommendations operation. The RecommendedActions in the output can have one or more recommended actions.

  2. Use the RecommendedAction object for each recommended action from step 1. The output contains Operation and Parameters.

    The following example shows the output with one recommended action.

    "RecommendedActions": [ { "ActionId": "0b19ed15-840f-463c-a200-b10af1b552e3", "Title": "Turn on auto backup", // localized "Description": "Turn on auto backup for my-mysql-instance-1", // localized "Operation": "ModifyDbInstance", "Parameters": [ { "Key": "DbInstanceIdentifier", "Value": "my-mysql-instance-1" }, { "Key": "BackupRetentionPeriod", "Value": "7" } ], "ApplyModes": ["immediately", "next-maintenance-window"], "Status": "applied" }, ... // several others ],
  3. Use the operation for each recommended action from the output in step 2 and input the Parameters values.

  4. After the operation in step 2 is successful, use the ModifyDBRecommendation operation to modify the recommendation status.

Dismissing the Amazon RDS recommendations

You can dismiss one or more recommendations.

To dismiss one or more recommendations
  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. In the navigation pane, perform any of the following:

    • Choose Recommendations.

      The Recommendations page appears with the list of all recommendations.

    • Choose Databases and then choose Recommendations for a resource in the databases page.

      The details appear in the Recommendations tab for the selected recommendation.

    • Choose Detection for an active recommendation in the Recommendations page or the Recommendations tab in the Databases page.

      The recommendation details page displays the list of affected resources.

  3. Choose one or more recommendation, or one or more affected resources in the recommendation details page, and then choose Dismiss.

    The following example shows the Recommendations page with multiple active recommendations selected to dismiss.

    A few active recommendations selected and dismiss button highlighted in the console

    A banner displays a message when the selected one or more recommendations are dismissed.

    The following example shows the banner with the successful message.

    A banner in the console showing the message with the number of resources that were successful to dismiss the recommendation

    The following example shows the banner with the failure message.

    A banner in the console showing the message with the resource that failed to dismiss the recommendation
To dismiss a RDS recommendation using the AWS CLI
  1. Run the command aws rds describe-db-recommendations --filters "Name=status,Values=active".

    The output provides a list of recommendations in active status.

  2. Find the recommendationId for the recommendation that you want to dismiss from step 1.

  3. Run the command >aws rds modify-db-recommendation --status dismissed --recommendationId <ID> with the recommendationId from step 2 to dismiss the recommendation.

To dismiss a RDS recommendation using the Amazon RDS API, use the ModifyDBRecommendation operation.

Modifying the dismissed Amazon RDS recommendations to active recommendations

You can move one or more dismissed recommendations to active recommendations.

To move one or more dismissed recommendations to active recommendations
  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. In the navigation pane, perform any of the following:

    • Choose Recommendations.

      The Recommendations page displays a list of recommendations sorted by the severity for all the resources in your account.

    • Choose Databases and then choose Recommendations for a resource in the databases page.

      The Recommendations tab displays the recommendations and its details for the selected resource.

  3. Choose one or more dismissed recommendations from the list and then choose Move to active.

    A few dismissed recommendations selected and Move to active button highlighted in the console

    A banner displays a successful or failure message when the moving the selected recommendations from dismissed to active status.

    The following example shows the banner with the successful message.

    a banner in the console showing the message with the number of resources moved successfully from dismissed to active recommendations

    The following example shows the banner with the failure message.

    a banner in the console showing the message with the resource that failed to move from dismissed to active recommendations
To change a dismissed RDS recommendation to active recommendation using the AWS CLI
  1. Run the command aws rds describe-db-recommendations --filters "Name=status,Values=dismissed".

    The output provides a list of recommendations in dismissed status.

  2. Find the recommendationId for the recommendation that you want to change the status from step 1.

  3. Run the command >aws rds modify-db-recommendation --status active --recommendationId <ID> with the recommendationId from step 2 to change to active recommendation.

To change a dismissed RDS recommendation to active recommendation using the Amazon RDS API, use the ModifyDBRecommendation operation.