This topic describes how to upgrade the major engine version of an ApsaraDB RDS for MySQL instance. The ApsaraDB RDS console supports only the upgrade from MySQL 5.5 to MySQL 5.6. If you want to upgrade your RDS instance between other major engine versions, for example, from MySQL 5.6 to MySQL 8.0, you need to migrate data.

Upgrade the major engine version from MySQL 5.5 to MySQL 5.6

Notice
  • You cannot downgrade the major engine version of your RDS instance.
  • Before you upgrade the major engine version of your RDS instance, we recommend that you purchase an RDS instance that runs the destination major engine version. Then, you can use the new RDS instance to test the compatibility between the destination major engine version and your workloads.
  • When you upgrade the major engine version of your RDS instance, transient connection errors may occur. These errors may last about 30 seconds. We recommend that you perform the upgrade during off-peak hours. Otherwise, make sure that your application is configured to automatically reconnect to your RDS instance.
  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 Upgrade Database.
  3. In the dialog box that appears, select MySQL 5.6 and confirm the upgrade.

Upgrade the major engine version from MySQL 5.6 or MySQL 5.7

If you want to upgrade the major engine version of your RDS instance from MySQL 5.6 or MySQL 5.7, perform the following steps:

  1. Create an RDS instance that runs the destination major engine version. For more information, see Create an ApsaraDB RDS for MySQL instance.
  2. Migrate the data of your original RDS instance to the new RDS instance. For more information, see Migrate data between ApsaraDB RDS for MySQL instances.
  3. Release your original RDS instance. For more information, see Release or unsubscribe from an ApsaraDB RDS for MySQL instance.

For example, your RDS instance runs MySQL 5.6, and you want to upgrade the major engine version of the instance to MySQL 8.0. In this case, you must first create an RDS instance that runs MySQL 8.0. Then, you must migrate the data of your original RDS instance to the new RDS instance. After the migration is complete, you can release your original RDS instance.

Notice You must verify the compatibility between the destination major engine version and your workloads. You must also keep monitoring the new RDS instance for a specified period of time. You can release your original RDS instance only after you confirm that the new RDS instance runs your workloads as normal.

Related operations

Operation Description
Upgrade database engine version Upgrades the major engine version of an ApsaraDB RDS instance.