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
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 the Minor Version of a DB Instance

Scenarios

RDS for RDS for SQL Server 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, as shown in Figure 1. You can click Upgrade to go to the Scheduled Task page and authorize the minor version upgrade task.

Figure 1 Version upgrade

Precautions

  • To upgrade a minor version of a RDS for SQL Server DB instance, you need to switch to the Scheduled Task page of the task center and authorize the upgrade task, so that the minor version will be automatically upgraded in the maintenance window.
  • You can view minor version upgrade information on the Scheduled Task page of the task center.
  • Upgrading the minor version will reboot the RDS for SQL Server DB instance. During the upgrade, the network will be intermittently disconnected for multiple times. Therefore, you are advised to set the maintenance time window to off-peak hours.
  • A minor version upgrade cannot be rolled back after the upgrade is complete.
  • When you upgrade a minor version of a primary DB instance, minor versions of read replicas (if any) will also be upgraded automatically. Perform the upgrade during off-peak hours because the DB instance will be rebooted after the upgrade is complete. (Minor versions of read replicas cannot be upgraded separately.)

Constraints

A minor version cannot be upgraded for DB instances with abnormal nodes.

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 target DB instance.
  5. In the DB Information area on the Basic Information page, click Upgrade in the DB Engine Version field.

    Figure 2 Upgrading the minor version

  6. In the displayed dialog box, click OK to go to the Scheduled Tasks page.
  7. Locate the target minor version upgrade task and click Authorize in the Operation column. In the displayed dialog box, select a maintenance window, select the check box, and click Yes.
  8. After the task is authorized successfully, it will be executed as scheduled within the maintenance window.

    • The DB instance will be rebooted during the task execution, which causes service interruptions. To prevent service interruptions, you are advised to set the maintenance window to off-peak hours. For details about how to change the maintenance window, see Changing the Maintenance Window.
    • Changing the maintenance window does not affect the execution time of the scheduled tasks in the original maintenance period.

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