Responding to Amazon Aurora recommendations
From the list of Aurora 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 Aurora 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
Sign in to the Amazon Web Services Management Console and open the Amazon RDS console at https://console.amazonaws.cn/rds/
. -
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.
-
-
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.
A confirmation window appears.
-
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 following example shows the confirmation window 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.
The following example shows the banner with the failure message.
To apply a configuration based Aurora recommendation using the Amazon RDS API
Use the DescribeDBRecommendations operation. The
RecommendedActions
in the output can have one or more recommended actions.Use the RecommendedAction object for each recommended action from step 1. The output contains
Operation
andParameters
.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 ],
Use the
operation
for each recommended action from the output in step 2 and input theParameters
values.After the operation in step 2 is successful, use the ModifyDBRecommendation operation to modify the recommendation status.
Dismissing the Amazon Aurora recommendations
You can dismiss one or more recommendations.
To dismiss one or more recommendations
Sign in to the Amazon Web Services Management Console and open the Amazon RDS console at https://console.amazonaws.cn/rds/
. -
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.
-
-
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 banner displays a message when the selected one or more recommendations are dismissed.
The following example shows the banner with the successful message.
The following example shows the banner with the failure message.
To dismiss an Aurora recommendation using the Amazon CLI
-
Run the command
aws rds describe-db-recommendations --filters "Name=status,Values=active"
.The output provides a list of recommendations in
active
status. Find the
recommendationId
for the recommendation that you want to dismiss from step 1.Run the command
>aws rds modify-db-recommendation --status dismissed --recommendationId <ID>
with therecommendationId
from step 2 to dismiss the recommendation.
To dismiss an Aurora recommendation using the Amazon RDS API, use the ModifyDBRecommendation operation.
Modifying the dismissed Amazon Aurora 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
Sign in to the Amazon Web Services Management Console and open the Amazon RDS console at https://console.amazonaws.cn/rds/
. -
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.
-
-
Choose one or more dismissed recommendations from the list and then choose Move to active.
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.
The following example shows the banner with the failure message.
To change a dismissed Aurora recommendation to active recommendation using the Amazon CLI
-
Run the command
aws rds describe-db-recommendations --filters "Name=status,Values=dismissed"
.The output provides a list of recommendations in
dismissed
status. Find the
recommendationId
for the recommendation that you want to change the status from step 1.Run the command
>aws rds modify-db-recommendation --status active --recommendationId <ID>
with therecommendationId
from step 2 to change to active recommendation.
To change a dismissed Aurora recommendation to active recommendation using the Amazon RDS API, use the ModifyDBRecommendation operation.