All Products
Search
Document Center

ApsaraDB RDS:Change instance specifications

Last Updated:Feb 02, 2024

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 the specific configuration items of an RDS instance, see Configuration items for an ApsaraDB RDS for MySQL instance.

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

Prerequisites

  • The RDS instance uses the subscription or pay-as-you-go billing method.

    Note

    If the RDS instance uses the serverless billing method, follow the instructions provided in Configure a serverless ApsaraDB RDS for MySQL instance.

  • Your Alibaba Cloud account does not have unpaid renewal orders.

  • The RDS instance is in the Running state.

Limits

  • After you submit a specification change order, you cannot cancel the order. Therefore, before you submit a specification change order, we recommend that you evaluate whether the new specifications meet your business requirements.

  • When you change the specifications of a read-only RDS instance, the primary RDS instance to which the read-only RDS instance is attached must be in the Running state.

  • The storage capacity of a read-only RDS instance must be greater than or equal to the storage capacity of its primary RDS instance. We recommend that you expand the storage capacity of the read-only RDS instance before you expand the storage capacity of the primary RDS instance.

  • Only the configuration items that are described in Configuration items for an ApsaraDB RDS for MySQL instance can be changed.

  • If you reduce the storage capacity of your RDS instance that uses local disks, the new storage capacity must be greater than or equal to 120% of storage that is used. For example, if the storage capacity of your RDS instance that uses local disks is 100 GB and 50 GB of storage is used, the new storage capacity must be greater than or equal to 60 GB (50 × 120%).

  • You can reduce the storage capacity of your RDS instance that runs RDS Basic Edition or RDS High-availability Edition without the need to change the RDS edition or the architecture of the RDS instance. The new storage capacity of your RDS instance must be greater than or equal to the minimum storage capacity supported by the instance type of the RDS instance. The minimum storage capacity to which you can reduce your RDS instance is calculated by using the following formula: min{Used storage × 1.3, Used storage + 400 GB}. You can reduce the storage capacity at a step size of 5 GB.

  • The zones supported by the economy RDS instances are different from those supported by the standard RDS instances. You can visit the ApsaraDB RDS buy page and check whether your RDS instance resides in the zone that supports the required product type. If your RDS instance is not in the zone that supports the required product type, you can migrate the RDS instance to the zone and then change the product type. For more information about how to migration an RDS instance across zones, see Migrate an ApsaraDB RDS for MySQL instance across zones in the same region.

  • If you want to change the product type of an RDS instance, make sure that the minor engine version of the RDS instance after the change is later than or the same as the current minor engine version. If the minor engine version after the change is earlier than the current minor engine version, the product type change fails.

Impacts

Storage type

Configuration item

Impact

Local disk

Instance type, RDS edition, and storage capacity

If the host on which your RDS instance is deployed cannot provide sufficient resources, the system migrates the data of your RDS instance to a new RDS instance. The incremental data that is generated in your RDS instance during the migration process is synchronized to the new RDS instance. After the migration process is complete, the system switches your workloads over to the new RDS instance during the switching time that you specify.

Important

A specification change causes an instance switchover. We recommend that you change specifications during off-peak hours. Make sure that your application is configured to automatically reconnect to the RDS instance. For more information, see How do I configure an application to automatically reconnect to an RDS instance? During an instance switchover, you cannot perform most of the operations that are related to databases, accounts, and network settings. For more information about the impacts of an instance switchover, see Impacts of an instance switchover.

Cloud disk

Instance type and RDS edition

The specification change is complete within minutes. The time that is required to change the specifications is not affected by the data volume of your RDS instance.

Important

A specification change causes an instance switchover. We recommend that you change specifications during off-peak hours. Make sure that your application is configured to automatically reconnect to the RDS instance. For more information, see How do I configure an application to automatically reconnect to an RDS instance? During an instance switchover, you cannot perform most of the operations that are related to databases, accounts, and network settings. For more information about the impacts of an instance switchover, see Impacts of an instance switchover.

Storage capacity

In most cases, when you change the storage capacity of your RDS instance, no transient connections occur.

If a snapshot backup task exists on your RDS instance that uses cloud disks, the storage capacity expansion is performed only after the snapshot backup task is complete.

Note
  • 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.

  • For more information about storage types, see Storage types.

Billing rules

For more information, see Specification change fees.

Procedure

  1. Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
  2. In the Configuration Information section of the page that appears, click Change Specifications.

  3. In the dialog box that appears, select a specification change method and click Next. This step is required only when the RDS instance uses the subscription billing method.

    You can select one of the following specification change methods:

    Upgrade or Downgrade: After you submit a specification change order, the new specifications immediately take effect. These specification change methods are supported for both subscription RDS instances and pay-as-you-go RDS instances.

    After you submit a specification change order, the system synchronizes the data of the RDS instance from the disk to a new RDS instance. Then, the system switches the information such as the ID and endpoints about the original RDS instance over to the new RDS instance based on the switching time that you specified for the specification change. You can use the same ID and endpoints to connect to your RDS instance.

  4. Change the specifications of the RDS instance.

    Note
    • You can change the instance type and storage capacity of the RDS instance regardless of the instance configuration. For more information about the usage notes for specification changes, see Instance types for standard primary ApsaraDB RDS for MySQL instances (original x86 architecture).

    • You can reduce the storage capacity of an RDS instance that runs RDS High-availability Edition with local disks or enhanced SSDs (ESSDs) or runs RDS Basic Edition with ESSDs.

    • If the RDS instance runs MySQL 5.6 on RDS Enterprise Edition, you can downgrade the RDS instance to RDS High-availability Edition.

    • If the RDS instance runs MySQL 5.7 on RDS Basic Edition, you can upgrade the RDS instance to RDS High-availability Edition with local disks.

    • If the RDS instance runs MySQL 5.7 or MySQL 8.0 on RDS High-availability Edition with ESSDs, you can upgrade the RDS instance to RDS Cluster Edition.

    • Make sure that the new specifications meet your business requirements.

  5. Configure the Switching Time parameter.

    • Execute Immediately: After the data of the RDS instance is migrated to a new RDS instance, the system immediately switches your workloads over to the new RDS instance.

    • Switch Within Maintenance Window: The system switches your workloads over to the new RDS instance within the maintenance window that you specify. For more information, see Configure a maintenance window.

    Important
    • If you use RDS Basic Edition, no secondary RDS instance is provided as a hot standby for your RDS instance. Therefore, your database service becomes unavailable for a long period of time when you change the specifications of the RDS instance. We recommend that you change the specifications of the RDS instance during off-peak hours to prevent interruptions to your workloads.

    • If you do not use RDS Basic Edition, one or two instance switchovers may occur when you change the specifications of the RDS instance. The switchovers do not interrupt your workloads. However, we still recommend that you change the specifications of the RDS instance during off-peak hours or make sure that your application is configured to automatically reconnect to the RDS instance. For more information about the impacts of an instance switchover, see Impacts of an instance switchover.

    • If you select Switch Within Maintenance Window, the RDS instance stays in the upgrading or downgrading state until the switchover is complete. During the switchover, you cannot perform specific operations on the RDS instance. For example, you cannot upgrade or downgrade the specifications of the RDS instance, upgrade the database engine version of the RDS instance, or migrate the RDS instance across zones.

    • In most cases, the storage capacity expansion or change in the ESSD storage type does not interrupt your workloads and can immediately take effect. In this case, you do not need to select Switch Within Maintenance Window.

  6. Read and select Terms of Service and click Pay Now. In the dialog box that appears, confirm the instance information before and after the specification change and click Continue to complete the payment.

    Warning
    • After you submit a specification change order, you cannot cancel the order. Therefore, before you submit a specification change order, we recommend that you evaluate whether the new specifications meet your business requirements.

    • After you submit a specification change order, do not perform DDL operations before the specification change is applied.

FAQ

  • How do I change the storage type of my RDS instance between local SSDs, standard SSDs, and ESSDs?

    For more information, see How do I change the storage type of an ApsaraDB RDS instance from cloud disks to local disks?

  • When I expand the storage capacity of my RDS instance, what do I do if an error that indicates insufficient storage resources occurs?

    You can migrate your RDS instance to a different zone and 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 a different zone, the endpoints of your RDS instance remain unchanged. However, the IP addresses that are associated with the endpoints change. Make sure that your application is configured to automatically reconnect to your RDS instance.

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

    In most cases, if your RDS instance uses cloud disks and does not run RDS Basic Edition, no transient connections occur when you expand the storage capacity. If your RDS instance uses local disks, the system migrates the data of your RDS instance based on the storage resources on the host on which your RDS instance is deployed:

    • The host on which your RDS instance is deployed can provide sufficient storage. 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. In this case, the system creates a primary RDS instance and a secondary RDS instance on a different host that can provide sufficient storage. Then, the system 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, a switchover of your workloads causes a transient connection that lasts approximately 30 seconds.

    Note

    You cannot obtain the amount of available storage in the host on which an RDS instance is deployed.

  • When I upgrade my primary RDS instance, does the system automatically upgrade the read-only RDS instances that are attached to my primary RDS instance?

    No, when you upgrade your primary RDS instance, the system does not automatically upgrade the read-only RDS instances that are attached to your primary RDS instance. You must manually upgrade the read-only RDS instances.

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

    For more information, see Impacts.

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

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

  • What factors affect the period of time that is required to change the specifications of my RDS instance?

    For more information, see Which factors affect the time that is required to change the specifications of my ApsaraDB RDS for MySQL instance?

  • If I upgrade the CPU cores, memory, and storage capacity of my RDS instance at the same time, how long is the service downtime?

    The service downtime lasts the same as the downtime when you upgrade the CPU cores, memory, or storage capacity of your RDS instance. In most cases, the service downtime lasts minutes. During the changes of instance specifications, an instance switchover may occur, or your RDS instance may be restarted. In addition, you cannot perform most of the operations that are related to databases, accounts, and network settings. We recommend that you change the specifications of your RDS instance within the specified maintenance window. For more information about the impacts of different configuration items, see Impacts.

  • When I expand the storage capacity of my RDS instance, why does a transient connection occur?

    When you expand the storage capacity of your RDS instance, an instance switchover occurs. For more information about the impacts of an instance switchover, see Impacts of an instance switchover.

  • When I expand the storage capacity of my primary RDS instance, is data replication from the primary RDS instance to its read-only RDS instances affected?

    No, specification changes do not affect data replication from the primary RDS instance to its read-only RDS instances.

  • Automatic storage expansion is not supported for RDS instances that use local disks. What do I do if I want to enable the automatic storage expansion feature for an RDS instance that uses local disks?

    You must create an RDS instance that uses cloud disks and then migrate your data from the original RDS instance to the new RDS instance. For more information, see Migrate data between ApsaraDB RDS for MySQL instances.

  • How do I expand the storage capacity of my RDS instance after the upper limit is reached?

    If your RDS instance runs MySQL 8.0 or MySQL 5.7 on RDS High-availability Edition and uses local disks, you can upgrade the storage type of the RDS instance to cloud disks to increase the upper limit of the storage capacity. This applies when your RDS instance resides in one of the following regions: China (Hangzhou), China (Shanghai), China (Zhangjiakou), and Singapore.

  • If I delete a database from an RDS instance, is the disk space released?

    If you execute the DROP statement to delete a database, the disk space is released. If you execute the DELETE statement to delete a database, the disk space is not released and disk fragments are generated.

  • Can I convert a regular ApsaraDB RDS for MySQL instance into a serverless ApsaraDB RDS for MySQL instance?

    No, you cannot convert a regular RDS instance into a serverless RDS instance. If you want to use a serverless RDS instance, you must create a serverless RDS instance. For more information, see Create a serverless ApsaraDB RDS for MySQL instance.

  • How am I charged for automatic storage expansion?

    By default, the automatic storage expansion feature is disabled. In this case, you are not charged for the feature. If you enable the feature, you are charged for the feature based on the billing method that is used for manual storage expansion. For more information, see Specification changes.

  • What are the rules for automatic storage expansion?

    For more information about the rules for automatic storage expansion, see Configure automatic storage expansion.

  • How do I change single-zone deployment to multi-zone deployment?

    If you want to change single-zone deployment to multi-zone deployment, you must migrate your RDS instance across zones in the same region. For more information, see Migrate an ApsaraDB RDS for MySQL instance across zones in the same region.

  • How do I configure an application to automatically reconnect to an RDS instance?

    If the client uses a Java application, we recommend that you set the time to live (TTL) in the Java application to no more than 60 seconds. This way, when the virtual IP address (VIP) of the endpoint changes, the application queries the DNS records to receive and use the new VIP of the resource. For more information about how to configure the TTL, see official JDK documentation.

Related operations

Operation

Description

ModifyDBInstanceSpec

Changes instance specifications.