This topic describes how to change the specifications of an ApsaraDB RDS for MySQL instance. The specifications include the RDS edition, instance type, and storage capacity.

For more information about how to change the specifications of an RDS instance that runs another database engine, see the following topics:

Prerequisites

  • Your Alibaba Cloud account does not have overdue renewal orders.
  • Your RDS instance is in the Running state.

Precautions

  • When you change the specifications of your RDS instance, an automatic data migration may be triggered. After the migration is complete, ApsaraDB RDS switches your workloads over to a new RDS instance during the switching time that you specify. The switchover does not interrupt the synchronization of incremental data. However, the migration causes network interruptions or transient connection errors. This depends on the edition of your RDS instance. During the network interruptions or transient connection errors, you cannot perform most of the operations that are related to databases, accounts, and network settings.
    Warning
    • If you use the Basic Edition, your RDS instance is not provided with a secondary RDS instance as a hot standby. Therefore, your database service is unavailable during a specification change. The length of time during which your database service is unavailable may be 30 minutes or more. We recommend that you change the specifications of your RDS instance during off-peak hours. This prevents interruptions to your workloads. If you require high service availability, we recommend that you do not select the Basic Edition. For example, you can select the High-availability Edition.
    • If you do not use the Basic Edition, a specification change may cause transient connection errors that last about 30 seconds. This does not interrupt your workloads. However, we still recommend that you change the specifications of your RDS during off-peak hours. Otherwise, make sure that your application is configured to automatically reconnect to your RDS instance.
    Note In most cases, if your RDS instance uses standard or enhanced SSDs and does not run the Basic Edition, no transient connection errors occur when you increase the storage capacity.
  • If you want to increase the read capability of your database system, you can create read-only RDS instances. These read-only RDS instances are used to offload read requests from your primary RDS instance. For more information, see Create a read-only ApsaraDB RDS for MySQL instance.
  • After you change the specifications of your RDS instance, you do not need to manually restart the instance.
  • After you change the specifications of your RDS instance, the ID and endpoints of the instance remain unchanged.

Billing

For more information, see Specification change fees.

Procedure

  1. Go to the Basic Information page.
    1. Log on to the ApsaraDB for RDS console. In the left-side navigation pane, click Instances. In the top navigation bar, select the region where your RDS instance resides.
      选择地域
    2. Find your RDS instance and click its ID.
  2. In the Configuration Information section of the Basic Information page, click Change Specifications.
  3. In the dialog box that appears, select a change method and click Next step. This step is required only when your RDS instance uses the subscription billing method.
    Note
    • Upgrade or Downgrade

      Both subscription and pay-as-you-go RDS instances support the Upgrade or Downgrade change methods. The new specifications immediately take effect.

    • Renew and Scale Down/Renew and Scale Up

      If you select this configuration change method, ApsaraDB RDS changes the configuration of your RDS instance when you renew your RDS instance. This configuration change method is supported only for subscription RDS instances. The new configuration takes effect on the next subscription period. For example, your RDS instance expires on June 20, 2018, and you renew your RDS instance on May 10, 2018. In this case, ApsaraDB RDS changes the configuration of your RDS instance on May 10, 2018, and the new subscription period and new configuration take effect on June 20, 2018.

  4. Change the specifications of your RDS instance.
    Note
    • You can change the specifications and storage capacity of your RDS instance without considering the instance configuration.
    • If your RDS instance runs MySQL 5.6 on RDS Enterprise Edition, you can downgrade the instance to the High-availability Edition.
  5. Set the Switching Time parameter.
    • Switch Immediately After Data Migration: After the automatic data migration is complete, ApsaraDB RDS immediately switches your workloads over to a new RDS instance.
    • Switch Within Maintenance Window: ApsaraDB RDS switches your workloads over to a new RDS instance within the maintenance window that you specify. For more information, see Set the maintenance window of an ApsaraDB RDS for MySQL instance.
    Warning
    • If you use the Basic Edition, your RDS instance is not provided with a secondary RDS instance as a hot standby. Therefore, your database service is unavailable during a specification change. The length of time during which your database service is unavailable may be 30 minutes or more. We recommend that you change the specifications of your RDS instance during off-peak hours. This prevents interruptions to your workloads.
    • If you do not use the Basic Edition, a specification change may cause transient connection errors that last about 30 seconds. This does not interrupt your workloads. However, we still recommend that you change the specifications of your RDS during off-peak hours. Otherwise, make sure that your application is configured to automatically reconnect to your RDS instance.
  6. Read and select Terms of Service, click Pay Now, and then complete the payment.

FAQ

  • How do I switch my RDS instance among the local, standard, and enhanced SSD storage types?

    For more information, see How do I migrate an ApsaraDB RDS instance from standard or enhanced SSDs to local SSDs?.

  • When I expand the storage capacity of my RDS instance, an error that indicates insufficient storage resources is returned. What do I do?

    Migrate your RDS instance to another zone. Then, expand the storage capacity of your RDS instance again. For more information, see Migrate an ApsaraDB RDS for MySQL instance across zones in the same region. After you migrate your RDS instance to another zone, the endpoints of your RDS instance remain unchanged. However, the IP addresses that are bound to the endpoints change. Make sure that your application is configured to automatically reconnect to your RDS instance.

  • If I only expand the storage capacity of my RDS instance, do I need to migrate data to a new RDS instance?

    In most cases, if your RDS instance uses standard or enhanced SSDs and does not run the RDS Basic Edition, no transient connection errors occur when you expand the storage capacity. If your RDS instance uses local SSDs, you may encounter the following circumstances:

    • The host on which your RDS instance is deployed can provide sufficient storage resources. In this case, you can directly expand the storage capacity. The expansion process does not interrupt your workloads.
    • The host on which your RDS instance is deployed cannot provide sufficient storage resources. In this case, ApsaraDB RDS creates new primary and secondary RDS instances on another qualified host. Then, ApsaraDB RDS synchronizes the data of your original RDS instance to the new primary and secondary RDS instances. The synchronization does not interrupt the workloads on your original RDS instance. However, after the synchronization is complete, you experience transient connection errors that last about 30 seconds.
    Note You cannot query the remaining storage space of the host on which an RDS instance is deployed.
  • When I upgrade my primary RDS instance, does ApsaraDB RDS automatically upgrade the read-only RDS instances that are attached to my primary RDS instance?

    No, after you upgrade your primary RDS instance, you must manually upgrade the read-only RDS instances that are attached to your primary RDS instance.

  • When I change the specifications of my RDS instance, are my online workloads interrupted?

    When you change the specifications of your RDS instance, your online workloads may be interrupted. For more information, see the "Precautions" section of this topic.

  • After I change the specifications of my RDS instance, do the endpoints of the instance change?

    No, after you change the specifications of your RDS instance, the endpoints of the instance remain unchanged. An example endpoint is rm-bpxxxxx.mysql.rds.aliyuncs.com. However, the IP addresses that are bound to the endpoints may change. We recommend that you add the endpoints to your application. Do not add the IP addresses to your application.

Related operations

API Description
ModifyDBInstanceSpec Changes the specifications of an ApsaraDB RDS instance.