This topic describes how to change the configuration of an RDS for MySQL instance, including changing the edition, specifications, storage capacity, storage class, and zone.

You can upgrade or downgrade the configuration of an RDS for MySQL instance at any time regardless of whether the instance uses the subscription or pay-as-you-go billing method. The new configuration takes effect immediately after you complete the configuration upgrade or downgrade.

Configuration items

If you want to horizontally scale the read capability of an RDS for MySQL instance, you can create read-only instances. For more information, see Introduction to MySQL read-only instances and Create an RDS for MySQL read-only instance.
Configuration item Description
Edition
  • MySQL 5.6: You can change the DB engine edition from High-availability Edition to Enterprise Edition or from Enterprise Edition to High-availability Edition.
    Note If you use the MySQL 5.6 DB engine, the network type of the RDS instance must be Classic.
  • MySQL 5.7: You can change the DB engine edition from Basic Edition to High-availability Edition.
Specifications (type)

You can change the specifications of any RDS instance.
Storage capacity

You can increase the storage capacity of any RDS instance.

You can only decrease the storage capacity of a subscription-based instance with local SSDs during instance renewal.

Note
  • For information about the capacity range, see Instance types.
  • You cannot decrease the storage capacity if the RDS instance uses cloud SSDs.
  • If the storage capacity range of the current specifications cannot meet your requirements, you can change the specifications.
Storage class When you change the MySQL 5.7 DB engine of an RDS instance from Basic Edition to High-availability Edition, the storage class changes from SSD to local SSD.
Zone When you switch the MySQL 5.6 DB engine of an RDS instance between High-availability Edition to Enterprise Edition, you must also change the zone of the RDS instance.
Note Changing the zone requires data migration. A larger data volume indicates a longer migration time.
Note Changing the preceding configuration does not change the endpoints of the RDS instance.

Billing

For more information, see Billing details about configuration change.

Prerequisites

Your Alibaba Cloud account does not have an unpaid renewal order.

Precautions

  • When the new configuration is taking effect, the RDS instance may be disconnected for about 30 seconds and most operations related to databases, accounts, and networks cannot be performed. Therefore, we recommend that you change the configuration during off-peak hours or make sure that your application can automatically reconnect to the RDS instance.
  • If the RDS instance is in the Basic Edition (which has no slave node as hot backup), it becomes unavailable for a long time during the configuration change. Therefore, if you have high requirements for database availability, we recommend that you select an edition higher than the Basic Edition. For example, you can select the High-availability Edition.

Procedure

  1. Log on to the RDS console.
  2. In the upper-left corner, select the region where the target RDS instance is located.选择地域
  3. Find the target RDS instance and click the instance ID.
  4. On the Basic information page, find the Configuration Information section and click Change Specifications.变成配置
  5. Optional. If the RDS instance uses the subscription billing method, click Next in the displayed dialog box.
  6. On the Change Specifications page, change the instance configuration. For more information, see Configuration items.
  7. Specify the time at which you want to change the configuration.
    • Switch Immediately After Data Migration: Change the configuration immediately after the data migration.
    • Switch Within Maintenance Window: Change the configuration during the maintenance window.
    Note To change the maintenance window, follow these steps:
    1. Click Modify.修改维护时间段
    2. In the Configuration Information section, select a maintenance window and click Save. 修改维护时间段
    3. Go back to the Change Specifications page, refresh the page, and change the configuration again.
  8. Select Terms of Service, Service Level Agreement, and Terms of Use and click Confirm.

FAQ

  1. How can I change the storage class (local SSD, SSD, or ESSD) of an RDS instance?

    See How do I change an SSD to a local SSD?

  2. Do I need to migrate data if I only want to expand the storage capacity of an RDS instance?

    Check whether the server where the RDS instance is located provides sufficient storage capacity for expansion. If yes, you do not need to migrate data and can directly expand the storage capacity. If no, you must migrate data to a server that provides sufficient storage capacity before you expand the storage capacity.