Note: Please go to docs.rightscale.com to access the current RightScale documentation set. Also, feel free to Chat with us!
Home > Guides > Dashboard Users Guide > Clouds > AWS Regions > RDS Instances > Actions > Modify an RDS Instance

Modify an RDS Instance

Important! The concepts and actions within this RDS section will be deprecated soon in favor of our new RDS browser (currently in Beta). For more details on the new browser, see the RDS (Beta) page and it's sub-pages.

Objective

To modify an RDS Instance's configuration.

Prerequisites

  • AWS Account with RDS support.  You must Sign Up for Amazon RDS before you can launch RDS instances.
  • 'actor' user role privileges
  • An 'available' RDS instance (Source or Read Replica)

Overview

Currently, there is no way to modify an RDS instance's configuration settings without rebooting it.  When a Read Replica instance is launched for the first time it will inherit the remainder of its configuration settings from its source DB instance (e.g. RDS Security Groups, RDS Parameter Groups, etc.).  

Steps

Select a running RDS instance.  If there's a link under the Source instance column, that means it's a Read Replica of the source instance.

screen_RDSReadReplica.png

Click the Modify action button.  The following fields are editable:

The following configurations of an RDS instance can be modified:

  • Deployments - Specify a Deployment to associate with your RDS Instance, where it will be viewable at the bottom of the Deployment's Servers tab.
  • Allocated storage in GB - Specify a new storage size for the instance that will be allocated for storing data.
  • Master user password - For security purposes, in order to make changes to a Read Replica, you must provide the user password for the Master (Source) RDS instance.
  • Instance Class - If you select a different instance type, the existing instance will be terminated and new RDS instance will be launched.
  • Backup retention period - The number of days for which system snapshots and point in time restore are available. Specified in days. (e.g. 0-3) (Configuration only applies to Source, not Read Replica instances)
  • IOPS - You can specify a minimum of 1,000 IOPS with 100GB up to a maximum of 10,000 IOPS with 1TB of storage for MySQL and Oracle databases at a rate of 1,000 IOPS per 100GB (for example, 1,000 IOPS per 100GB, 2,000 IOPS per 200GB, 3,000 IOPS per 300GB, etc.). If you are using SQL Servers, then the maximum IOPS you can provision is 7,000 IOPS. Note: only specify this value if you are going to use IOPS. Otherwise, leave this blank.
  • Preferred backup window - A two hour window when complete backups of the database will be taken.
  • Preferred maintenance window - AWS will periodically perform maintenance on your RDS Instance. Specify a 4-hour window (GMT timezone) during non peak time that's ideal for maintenance purposes. (Day:HH:MM-Day:HH:MM) If this field is left blank, the default window will be used (sun:05:00-sun:09:00).
  • RDS Security Group(s) - The security group(s) that will be used by the instance.
  • RDS Parameter Group - The parameter group that will be used by the instance.
  • Multi-AZ - If checked, the instance will have a redundant instance in a different availability zone as the source instance. You can only use the multi-availability zone option for sources instances. (Configuration only applies to Source, not Read Replica instances)
  • Engine - The version of MySQL that will be installed on the instance. Note: Read Replicas can only be launched with version 'mysql 5.1.50' and above.
  • Allow major version upgrade - If checked, Amazon will automatically upgrade the instance's major MySQL version. For example, if the instance is using MySQL v5.1.50 and Amazon later supports v5.2.01 for RDS instances, your instance's MySQL engine will automatically be upgraded during one of the maintenance windows. Keep this box unchecked unless you've already tested and verified that your database is compatible with the latest supported version of MySQL.
  • Auto minor version upgrade - If checked, Amazon will automatically upgrade the instance's MySQL version. For example, if the instance is using MySQL v5.1.50 and Amazon later supports v5.1.51 for RDS instances, your instance's MySQL engine will automatically be upgraded during one of the maintenance windows.
  • Apply immediately - Select 'Yes' if you want the changes to take effect immediately. Select 'No' if you want to apply the changes at a later time.
Clouds > AWS Region > RDS Instances > Show > Edit

Note: with Backup retention period and Multi-AZ, configuration only applies to Source (not Read Replica) instances. 

When you are satisfied with your changes, click Modify.  If the changes were set to be applied immediately, the RDS instance will enter a 'modifying' state while the specified changes are applied.  If you specified a different instance class, a new RDS instance will be launched.  Once all changes have been applied, the instance's state will change to 'available'.

See also

You must to post a comment.
Last modified
12:47, 2 Oct 2013

Tags

This page has no custom tags.

Classifications

This page has no classifications.

Announcements

None


© 2006-2014 RightScale, Inc. All rights reserved.
RightScale is a registered trademark of RightScale, Inc. All other products and services may be trademarks or servicemarks of their respective owners.