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

Last updated: 2020-06-17

When does the maintenance window start and end, and how can I set up notifications for Amazon Relational Database Service (Amazon RDS) and Amazon Redshift maintenance windows? I want to be notified about maintenance windows, so I can minimize the impact to my resources.

Resolution

You can set up event notifications for Amazon RDS and Amazon Redshift clusters and instances so that you receive notifications regarding on-going or completed maintenance. You can receive these notifications by either email or SMS using Amazon Simple Notification Service (Amazon SNS).

To see which Amazon RDS DB instances are scheduled to receive hardware maintenance during your maintenance window, review the DB instances that are listed in the Affected resources tab. For more information, see the maintenance notification email sent to your account.

While the maintenance is in progress, Single-AZ deployments are unavailable for a few minutes during your maintenance window. If you use a Multi-AZ deployment and the primary DB instance is in an affected Availability Zone at the time of maintenance, the database is unavailable until failover is complete (usually about 60 seconds). This failover occurs in your maintenance window. If the primary DB instance is not in an affected Availability Zone at the time of maintenance, then the secondary is replaced during your maintenance window without failover, and without impacting availability. To identify the Availability Zone of your primary or secondary DB instance, see describe-db-instances.

Amazon RDS

To configure event notifications for Amazon RDS:

  1. Create an Amazon SNS topic and subscribe to a topic using your endpoints, such as email accounts or mobile numbers.
  2. Open the Amazon RDS console, and then from the navigate page choose Event subscriptions.
  3. Choose Create event subscription.
  4. Enter the Name, select the ARN for the SNS topic, and select Instances as the Source type.
  5. Choose Select specific instances, and select your instance.
  6. Choose Select specific event categories, and select Maintenance.
  7. Choose Create.

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

  • RDS-EVENT-0026 for maintenance in progress.
  • RDS-EVENT-0027 for maintenance that is complete.

Amazon Redshift

To configure event notifications for Amazon Redshift:

  1. Open the Amazon Redshift console, and then from the navigation pane choose Events.
  2. Choose Event Subscriptions, and then choose Create event subscription.
  3. In the Subscription details section, enter an Event subscription name for this event.
  4. In the Subscription type section, under Source type, choose Cluster.
  5. For Cluster, choose Select cluster, and then add your Cluster IDs.
  6. For Severity, choose error or info, error.
  7. In the Subscription actions section, select Create a new SNS topic or Choose an existing SNS topic.
  8. Choose Create event subscription.

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

  • REDSHIFT-EVENT-2003 for Amazon Redshift maintenance in progress.
  • REDSHIFT-EVENT-2004 for Amazon Redshift maintenance that is complete.

Note: Amazon Redshift scheduled maintenance doesn't trigger an event. To view changes to upcoming maintenance windows, see the Amazon Redshift forum.