How do I configure notifications for Amazon RDS or Amazon Redshift maintenance windows?

3 minute read

I want to set up notifications for Amazon Relational Database Service (Amazon RDS) and Amazon Redshift maintenance windows to minimize the effect on my resources.

Resolution

To receive email or SMS notifications about Amazon RDS and Amazon Redshift cluster and instance maintenance, use Amazon Simple Notification Service (Amazon SNS).

To view the Amazon RDS DB instances that you scheduled for hardware maintenance during your maintenance window, choose the Affected resources tab. For more information, review the maintenance notification that Amazon SNS sends to your email.

When the maintenance is in progress, Single-AZ deployments are unavailable for approximately 60 seconds. If you use a Multi-AZ deployment and the primary DB instance is in an affected Availability Zone, then the database is available after failover completes. The failover occurs during your maintenance window. If the primary DB instance isn't in an affected Availability Zone, then the secondary DB instance is replaced without failover and your database remains available.

To identify the Availability Zone of your primary or secondary DB instance, run the describe-db-instances AWS Command Line Interface (AWS CLI) command.

Note: If you receive errors when you run AWS CLI commands, then see Troubleshooting errors for the AWS CLI. Also, make sure that you're using the most recent AWS CLI version.

Amazon RDS

To configure event notifications for Amazon RDS, complete the following steps:

Create an Amazon SNS topic, and then use your endpoints to subscribe to a topic, such as email accounts or mobile numbers.
Open the Amazon RDS console.
In the navigation pane, choose Event subscriptions.
Choose Create event subscription.
On the Create event subscription page, enter the following information:
For Name, enter a name for the subscription.
For Target, choose Amazon Resource Name (ARN), and then select the ARN for the SNS topic.
Under Source, choose Instances as the Source type.
Choose Select specific instances, and then select your instance.
Choose Select specific event categories, and then select Maintenance.
Choose Create.

After you create an event subscription, you receive notifications with the following event codes:

RDS-EVENT-0026 for maintenance that's in progress
RDS-EVENT-0027 for maintenance that's complete

Amazon Redshift

To configure event notifications for Amazon Redshift, complete the following steps:

Open the Amazon Redshift console.
In the navigation pane, choose Events.
Choose Event Subscriptions, and then choose Create event subscription.
On the Create event subscription page, enter the following information:
In the Subscription details section, under Event subscription name, enter a name for the event.
In the Subscription type section, under Source type, choose Cluster.
For Cluster, choose Select cluster, and then select your cluster IDs.
For Categories, choose your categories.
For Severity, choose Error or Info, Error.
In the Subscription actions section, create a topic or select an existing topic.
Choose Create event subscription.