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. 

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 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 will be 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 will be unavailable until failover is complete (usually about 60 seconds). This failover occurs in your maintenance window. If the primary instance is not in an affected Availability Zone at the time of maintenance, then the secondary will be 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 the Subscriptions tab, and then choose Create Event Subscription.
  3. Choose Management, and then for the severity select Any.
  4. Choose Cluster as the Source Type, select Choose Specific, and then add your Cluster IDs.
  5. Enter a Name for this event, select Yes to enable the subscription, and then choose Next.
  6. Choose an existing topic or choose the Create New Topic tab, enter the Name, and then specify the Recipients, such as email or SMS.
  7. Choose Create.

After you create an event subscription, you will 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 won't trigger an event. To view changes to upcoming maintenance windows, see the Amazon Redshift forum.

Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center

Published: 2017-11-13

Updated: 2019-02-07