Adjusting Instance Architecture

Last updated: 2024-09-06 18:00:25

This document describes how to adjust the instance architecture in the TencentDB for SQL Server console.

Architecture background

TencentDB for SQL Server supports the following architectures:
Type
Architecture
Single-node (formerly Basic Edition)
a. Computing and storage are separated, based on high-performance cloud disks, using single-node deployment.
b. Low price, very high cost-performance ratio.
Two-node (formerly High Availability/Cluster Edition)
2008 R2/2012/2014/2016 Enterprise Edition
a. It consists of one primary and one mirror (Mirror) SQL Server database, deployed across racks/AZs.
b. Each database corresponds to a monitoring agent, which monitors the database through heartbeat in real-time.
Two-node (formerly High Availability/Cluster Edition)
2017/2019 Enterprise Edition
a. It adopts the Always On architecture, with default cross-rack/AZ deployment of one primary and one replica in a cluster architecture.
b. Each database corresponds to a monitoring agent, which monitors the database through heartbeat in real-time.
For detailed descriptions, see Product Architecture.

Prerequisites

You can adjust the configuration of a TencentDB for SQL Server instance and its associated instances only when they are in running status and are not executing any tasks.

Notes

Currently, the architecture cannot be downgraded back after an upgrade.

Impact of configuration adjustment

Data migration will be involved during the instance configuration adjustment, and the larger the data volume, the longer the data migration time. Access to the instance will not be affected during this period.
A switch will be performed after migration is completed, which causes a momentary disconnection from the database for few seconds. Make sure that your business has a reconnection mechanism.
Most database, account, and network operations are unavailable during the momentary disconnection. Therefore, we recommend that you perform the switch during off-peak hours.

Operation step

1. Log in to SQL Server Console, select the region where your instance is located, find the specific instance that needs reconfiguration in the instance list, and in its Operation column, click Adjust Configuration.


2. In the pop-up configuration adjustment window, select the architecture version you need to change to, verify it is correct, and click Confirm.
Note:
If data migration is involved during the change, you need to select the effective time and click the orange note; otherwise, you don't need to select the effective time.
During maintenance time: You can modify the maintenance time on the instance details page.
Adjust now: The configuration adjustment will be performed immediately.

3. For yearly/monthly subscription instances, confirm the configuration and cost in the redirected payment window and click Submit Order. For pay-as-you-go instances, confirm the configuration and cost in the redirected window and click Adjust.
4. Return to the instance list. When the instance status changes from Switching Instance Configuration to Running, the architecture upgrade is completed. You can query and confirm the new architecture on the Instance List or Instance Details page.