Upgrading a Minor Version

Scenarios

GaussDB(for MySQL) supports manual minor version upgrades, which can improve performance, add new functions, and fix bugs.

When a new minor version is released on Huawei Cloud, you will see Upgrade in the DB Engine column on the Instances page.

Figure 1 Upgrading a minor version

Precautions

• When any new minor version is released for addressing issues and vulnerabilities from the open source community, upgrade the minor version of your instance immediately or during the maintenance window.
• The upgrade will cause the instance to reboot and briefly interrupt services. To limit the impact of the upgrade, perform the upgrade during off-peak hours, or ensure that your applications support automatic reconnection.
• If a DB instance contains a large number of table partitions (more than 1 million), it may take more than 2 hours to reboot the instance.
• If you want to upgrade the minor version of your DB instance from 8.0.18 to 8.0.22 and there are more than 1,000 partitions, the upgrade may fail. Contact Huawei Cloud engineers to check the version compatibility before the upgrade.
• If the primary node and read replicas of a DB instance are deployed in the same AZ, a minor version upgrade will trigger a failover. If they are in different AZs, a minor version upgrade will trigger two failovers. A failover means that the system fails over to a read replica in case the primary node is unavailable.
• When you upgrade a minor version of a DB instance, minor versions of read replicas (if any) will also be upgraded automatically. Minor versions of read replicas cannot be upgraded separately. A minor version upgrade cannot be rolled back after the upgrade is complete.
• DDL operations, such as creating events, dropping events, and altering events, are not allowed during a minor version upgrade.
• If the replication delay between primary node and read replicas is longer than 300 seconds, the minor version cannot be upgraded.

Procedure

1. Log in to the management console.
2. Click in the upper left corner and select a region and a project.
3. Click in the upper left corner of the page, choose Databases > GaussDB(for MySQL).
4. On the Instances page, click the instance name to go to the Basic Information page.
5. In the DB Instance Information area, click Upgrade next to the DB Engine Version field.

   Alternatively, go to the Instances page, click Upgrade next to the DB Engine Version column.

   Figure 2 Upgrading a minor version
   
   Figure 3 Upgrading a minor version
   

6. In the displayed dialog box, select a scheduled time and click OK.
   • Upon submission: The system upgrades the minor version immediately after your submission of the upgrade request. After the operation is complete, in the Task Center page, click Instant Tasks and view the information about the upgrade task.
   • In maintenance window: The system will upgrade the minor version during a maintenance window you specify. After the operation is complete, in the Task Center page, click Scheduled Tasks and view the information about the upgrade task.
     Figure 4 Selecting a scheduled time
     

APIs

Upgrading the Kernel Version of a DB Instance