ApsaraDB RDS for MySQL supports both automatic updates and manual updates to the minor engine version of your RDS instance. These updates increase performance, unveil new features, and fix known issues.

For more information about the minor engine versions of ApsaraDB RDS for MySQL, see Release notes for minor AliSQL versions.

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

Overview

  • Auto: When a new minor engine version is released, Alibaba Cloud pushes a notification to you. In addition, ApsaraDB RDS automatically updates the minor engine version of your RDS instance to the new minor engine version during the maintenance window that you specify. You can log on to the ApsaraDB RDS console and go to the Basic Information page to view the Minor Version Upgrade Mode. For more information, see Set the maintenance window of an ApsaraDB RDS for MySQL instance.
  • Manual: When the lifecycle of the minor engine version that is run on your RDS instance ends, Alibaba Cloud pushes a notification to you. The notification states that you must update the minor engine version of your RDS instance to the latest stable minor engine version within one month. In most cases, the lifecycle of a minor engine version spans one year. You can manually update the minor engine version on the Basic Information page in the ApsaraDB RDS console. For more information, see the "Configure the manual minor version upgrade mode" section of this topic.
    Note After the lifecycle of a minor engine version ends, the minor engine version is no longer available.

Precautions

  • If the minor engine version is outdated, the workloads of your RDS instance may be interrupted. We recommend that you update the minor engine version of your RDS instance on a regular basis or after you receive an O&M notification from Alibaba Cloud.
  • If a read-only RDS instance is attached to your RDS instance and the minor engine version of the read-only RDS instance is earlier than the new minor engine version, ApsaraDB RDS updates the minor engine version of the read-only RDS instance and then updates the minor engine version of your RDS instance.
  • When you upgrade or change the specifications of your RDS instance or Alibaba Cloud upgrades the hardware of your RDS database service, ApsaraDB RDS automatically updates the minor engine version of your RDS instance to the latest version. This applies if the minor engine version of your RDS instance expires or is no longer maintained.
  • An update to the minor engine version triggers a restart of your RDS instance. During the restart process, a transient connection that lasts approximately 30 seconds may occur. The time when your RDS instance restarts varies based on the value of the Upgrade Time parameter. You can set this parameter to Upgrade Immediately or Switch Within Maintenance Window. We recommend that you update the minor engine version of your RDS instance during off-peak hours. Otherwise, make sure that your application is configured to automatically reconnect to your RDS instance.
  • After you update the minor engine version of your RDS instance, you cannot roll the minor engine version of the instance back to the previous version.
  • After you update the minor engine version of your RDS instance, the Backup Size on the Basic Information page in the ApsaraDB RDS console may be displayed as 0. After the next scheduled backup is complete, this error is automatically fixed.

Configure the minor version upgrade mode

  1. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
  2. In the Configuration Information section of the Basic Information page, click Configure to the right of Minor Version Upgrade Mode.
  3. Select the Auto or Manual update mode and click OK.

Configure the manual minor version upgrade mode

  1. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
  2. In the Configuration Information section, click Upgrade Minor Version.
    Note If you cannot find the option, the minor engine version that you are using is the latest version.
  3. In the dialog box that appears, select Upgrade to Version, select Upgrade Time, and then click OK.

FAQ

  • After I update the minor engine version of my RDS instance, why does the SELECT @@version statement still return the minor engine version that I used before the update?

    The SELECT @@version statement returns the minor engine version of Alibaba Cloud. To view the minor engine version of your RDS instance, you must run the show variables like '%rds_release_date%' command.

  • When an update takes effect, is my RDS instance updated only to the next minor engine version?

    You can update the minor engine version of your RDS instance to any new minor engine version that is available in the ApsaraDB RDS console.

  • Why does a transient connection occur during the update process? Does the update process interrupt the workloads on my RDS instance?

    Before ApsaraDB RDS updates the minor engine version of your RDS instance, ApsaraDB RDS updates the minor engine version of the secondary RDS instance of your RDS instance. After the minor engine version of the secondary RDS instance is updated, ApsaraDB RDS switches your workloads over to the secondary RDS instance. During the switchover, a transient connection that lasts approximately 30 seconds occurs. The update does not interrupt the workload on your RDS instance.

Related operations

Operation Description
Update minor engine version Updates the minor engine version of an ApsaraDB RDS instance.