Upgrading a Minor Version

Scenarios

You can upgrade the minor kernel versions of your DB instances to improve performance, optimize functions, and fix bugs.

Precautions

• A minor version upgrade will cause a GaussDB(for MySQL) instance to reboot and briefly interrupt services. To minimize the impact of the upgrade, perform the upgrade during off-peak hours, or ensure that your applications support automatic reconnection.
• If an instance contains a large number of table partitions (more than 1 million), it may take more than 2 hours to reboot the instance.
• 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 latency between the primary node and read replicas is longer than 300 seconds, the minor version cannot be upgraded.
• To upgrade the kernel version to 2.0.54.240600 or later, ensure that rds_global_sql_log_bin is ON and binlog_expire_logs_seconds is greater than or equal to 86400. For details about how to set these parameters, see Modifying Parameters of a DB Instance.

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 Database > 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.

6. In the displayed dialog box, select a scheduled time and click OK.