         | Did this page help you? Yes No Tell us about it... |
Adjusting the Preferred Maintenance Window
Every DB Instance has a weekly maintenance window during which any system changes are applied. If you don't specify a preferred maintenance window when you create the DB Instance, Amazon RDS assigns a 30-minute maintenance window on a randomly selected day of the week. The 30-minute maintenance window is selected at random from an 8-hour block of time per region. The following table lists the default maintenance windows for each Region.
| Region | Time Block |
|---|---|
| US East (Northern Virginia) Region | 03:00-11:00 UTC |
| US West (Northern California) Region | 06:00-14:00 UTC |
| US West (Oregon) Region | 06:00-14:00 UTC |
| EU (Ireland) Region | 22:00-06:00 UTC |
| Asia Pacific (Singapore) Region | 14:00-22:00 UTC |
| Asia Pacific (Tokyo) Region | 17:00-03:00 UTC |
The maintenance window should fall at the time of lowest usage and thus might need modification from time to time. Your DB Instance will only be unavailable during this time if the system changes that are being applied require an outage, and only for the minimum amount of time required to make the necessary changes.
In the following example, you adjust the preferred maintenance window for a DB Instance.
For the purpose of this example, we assume that the DB Instance named mydbinstance exists and has a preferred maintenance window of "Sun:05:00-Sun:06:00" UTC.
AWS Management Console
To adjust the preferred maintenance window
Launch the AWS Management Console.
Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.
Click on the DB Instances link in the Navigation panel on the left side of the console display.
The My Instances list appears.
Right-click on the DB Instance in the My DB Instances list and select Modify from the drop-down menu.
The Modify DB Instance window appears.
Type the maintenance window into the Maintenance Window text box using the format "day:hour:minute-day:hour:minute".
![[Note]](http://docs.amazonwebservices.com/docs-common/images/note.png)
Note The maintenance window and the backup window for the DB Instance cannot overlap. If you enter a value for the maintenance window that overlaps the backup window, an error message appears.
Click the OK button.
Changes to the maintenance window take effect immediately.
CLI
To adjust the preferred maintenance window
Use the
rds-modify-db-instancecommand with the following parameters:PROMPT>rds-modify-db-instance mydbinstance --preferred-maintenance-window Tue:04:00-Tue:04:30
This command produces output similar to the following.
DBINSTANCE mydbinstance 2009-10-22T18:10:15.274Z db.m1.large mysql 60 master available mydbinstance.clouwupjnvmq.us-east-1.rds.amazonaws.com 3306 us-east-1a 1 n 5.1.57 general-public-license SECGROUP default active PARAMGRP default.mysql5.1 in-sync
API
To adjust the preferred maintenance window
Call
ModifyDBInstancewith the following parameters:DBInstanceIdentifier=mydbinstancePreferredMaintenanceWindow=Tue:04:00-Tue:04:30
Example
https://rds.amazonaws.com/ ?Action=ModifyDBInstance &DBInstanceIdentifier=mydbinstance &PreferredMaintenanceWindow=Tue:04:00-Tue:04:30 &SignatureVersion=2 &SignatureMethod=HmacSHA256 &Timestamp=2009-10-14T17%3A48%3A21.746Z &AWSAccessKeyId=<AWS Access Key ID> &Signature=<Signature>
