Relational Database ServiceRelational Database Service

Compute
Elastic Cloud Server
Bare Metal Server
Auto Scaling
Image Management Service
Dedicated Host
FunctionGraph
Networking
Virtual Private Cloud
Elastic IP
Elastic Load Balance
NAT Gateway
Direct Connect
Virtual Private Network
Domain Name Service
VPC Endpoint
Cloud Connect
Enterprise Switch
Security & Compliance
Anti-DDoS
Web Application Firewall
Host Security Service
Data Encryption Workshop
Database Security Service
Advanced Anti-DDoS
Data Security Center
Container Guard Service
Situation Awareness
Managed Threat Detection
Compass
Cloud Certificate Manager
Anti-DDoS Service
Databases
Relational Database Service
Document Database Service
Data Admin Service
Data Replication Service
GaussDB NoSQL
GaussDB(for MySQL)
Distributed Database Middleware
GaussDB(for openGauss)
Developer Services
ServiceStage
Distributed Cache Service
Simple Message Notification
Application Performance Management
Application Operations Management
Blockchain Service
API Gateway
Cloud Performance Test Service
Distributed Message Service for Kafka
Distributed Message Service for RabbitMQ
Distributed Message Service for RocketMQ
Cloud Service Engine
DevCloud
ProjectMan
CodeHub
CloudRelease
CloudPipeline
CloudBuild
CloudDeploy
Cloud Communications
Message & SMS
Cloud Ecosystem
Marketplace
Partner Center
User Support
My Account
Billing Center
Cost Center
Resource Center
Enterprise Management
Service Tickets
HUAWEI CLOUD (International) FAQs
ICP License Service
Support Plans
Customer Operation Capabilities
Partner Support Plans
Professional Services
enterprise-collaboration
Meeting
IoT
IoT
Intelligent EdgeFabric
DeveloperTools
SDK Developer Guide
API Request Signing Guide
Terraform
Koo Command Line Interface
Updated at: Apr 02, 2022 GMT+08:00

Upgrading a Minor Version

Scenarios

RDS for MySQL supports minor version upgrades to improve performance, add new functions, and fix bugs.

When a new minor version is released on HUAWEI CLOUD, the Upgrade link is displayed in the DB Engine Version column on the Instance Management page. You can click Upgrade to go to the minor version upgrade page.

Figure 1 Version upgrade

A minor version can be upgraded in either of the following ways:

  • Upon submission: The system upgrades the minor version upon your manual submission of the upgrade request.
  • In maintenance window: The minor version will be upgraded during the maintenance window after you manually submit the upgrade request. For details on how to change the maintenance window, see Changing the Maintenance Window.

Precautions

  • When any new minor version is released for periodically synchronizing with open source community issues or bug fixes, manually upgrade the version immediately or during the maintenance window.
  • The upgrade will cause the DB instance to reboot and interrupt services intermittently. To limit the impact of the upgrade, perform the upgrade during off-peak hours, or ensure that your applications support automatic reconnection.
  • If primary and standby DB instances are deployed in the same AZ, a minor version upgrade will trigger a failover. If primary and standby DB instances are deployed in different AZs, a minor version upgrade will trigger two failovers.
  • When you upgrade a minor version of a primary DB instance, minor versions of read replicas (if any) will also be upgraded automatically (they cannot be upgraded separately). Perform the upgrade during off-peak hours because the DB instance will be rebooted after the upgrade is complete.
  • A minor version upgrade cannot be rolled back after the upgrade is complete. If the upgrade fails, the DB instance will be automatically rolled back to the source version.
  • DDL operations, such as create event, drop event, and alter event, are not allowed during a minor version upgrade.

Constraints

  • If the replication delay between primary and standby DB instances is longer than 300 seconds, the minor version cannot be upgraded.
  • For primary/standby DB instances, the standby DB instance is upgraded first and then the primary DB instance is upgraded afterwards.
  • Minor versions cannot be upgraded for DB instances with abnormal nodes.
  • MySQL DB instances with the event scheduler function enabled do not support minor version upgrades. If you want to perform a minor version upgrade, disable event scheduler first. For operation details, see Enabling or Disabling Event Scheduler.

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 and choose Database > Relational Database Service. The RDS console is displayed.
  4. On the Instance Management page, click the primary DB instance to be upgraded.
  5. In the DB Information area on the Basic Information page, click Upgrade Minor Version next to the DB Engine Version field.

    Figure 2 Upgrading the 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 you have submitted your upgrade request.
    • In maintenance window: The system will upgrade the minor version during the maintenance window that you have configured.
    Figure 3 Selecting a scheduled time

Did you find this page helpful?

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel