- Release Notes and Announcements
- Release Notes
- Announcements
- Announcement on Changing External Network Links
- Interface Authentication Upgrade Announcement
- Maintenance Time Change from Local Time to Beijing Time
- Account Type and Permission Changes
- Product Architecture Name Change
- Disk Storage Space Composition Change
- Ending Support for Classic Network [2022.12.31]
- Backup Billing Start [2022.07.10]
- Ending Sale for Basic Edition 1-Core Specification [2022.03.07]
- User Guide
- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide
- Constraints and Limits
- Usage Specifications and Suggestions
- Maintaining Instance
- Renaming Instance
- Setting Instance Remarks
- Setting Instance Tag
- Setting Instance Project
- Modify Instance-level Character Set Collation
- Modify System Time Zone
- Setting Instance Maintenance Information
- Multi-AZ Disaster Recovery
- Restarting Instance
- Terminating Instance
- Migrating Across AZs
- Manual Primary-Secondary Switching
- Recycle Bin
- Adjusting Instance Configuration
- Read-Only Instance
- Network and Security
- Account Management
- Database Management
- Data Security
- Parameter Configuration
- Monitoring and Alarms
- Backup and Restoration
- Log Management
- Publish-Subscribe
- SSIS
- Data Migration (New)
- Data Migration (Legacy)
- Practical Tutorial
- API Documentation
- History
- Introduction
- API Category
- Sales and fee related APIs
- Network management related APIs
- Account management related APIs
- Instance Management APIs
- Data security encryption related APIs
- Parameter configuration related APIs
- Log management related APIs
- Extended Event APIs
- Read only instance management related APIs
- Backup APIs
- Rollback APIs
- Data migration (cold standby migration) related APIs
- CreateBackupMigration
- ModifyBackupMigration
- StartBackupMigration
- DescribeBackupMigration
- DeleteBackupMigration
- DescribeUploadBackupInfo
- CreateIncrementalMigration
- ModifyIncrementalMigration
- StartIncrementalMigration
- DescribeIncrementalMigration
- DescribeBackupCommand
- DescribeBackupUploadSize
- DeleteIncrementalMigration
- Data migration (DTS old version) related APIs
- Making API Requests
- Database APIs
- Other APIs
- Data Types
- Error Codes
- FAQs
- Overview
- Model Selection
- Pricing and Selection
- Connection and Network
- Account and Permission
- Backup and Rollback
- Data Migration
- Publish/Subscribe
- Read-Only Instance
- Version and Architecture Upgrade
- Disk Space and Specification Adjustment
- Monitoring and Alarms
- Log
- Parameter Modification
- Features
- Performance/Space/Memory
- Service Agreement
- Performance Evaluation
- Glossary
- Contact Us
- Release Notes and Announcements
- Release Notes
- Announcements
- Announcement on Changing External Network Links
- Interface Authentication Upgrade Announcement
- Maintenance Time Change from Local Time to Beijing Time
- Account Type and Permission Changes
- Product Architecture Name Change
- Disk Storage Space Composition Change
- Ending Support for Classic Network [2022.12.31]
- Backup Billing Start [2022.07.10]
- Ending Sale for Basic Edition 1-Core Specification [2022.03.07]
- User Guide
- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide
- Constraints and Limits
- Usage Specifications and Suggestions
- Maintaining Instance
- Renaming Instance
- Setting Instance Remarks
- Setting Instance Tag
- Setting Instance Project
- Modify Instance-level Character Set Collation
- Modify System Time Zone
- Setting Instance Maintenance Information
- Multi-AZ Disaster Recovery
- Restarting Instance
- Terminating Instance
- Migrating Across AZs
- Manual Primary-Secondary Switching
- Recycle Bin
- Adjusting Instance Configuration
- Read-Only Instance
- Network and Security
- Account Management
- Database Management
- Data Security
- Parameter Configuration
- Monitoring and Alarms
- Backup and Restoration
- Log Management
- Publish-Subscribe
- SSIS
- Data Migration (New)
- Data Migration (Legacy)
- Practical Tutorial
- API Documentation
- History
- Introduction
- API Category
- Sales and fee related APIs
- Network management related APIs
- Account management related APIs
- Instance Management APIs
- Data security encryption related APIs
- Parameter configuration related APIs
- Log management related APIs
- Extended Event APIs
- Read only instance management related APIs
- Backup APIs
- Rollback APIs
- Data migration (cold standby migration) related APIs
- CreateBackupMigration
- ModifyBackupMigration
- StartBackupMigration
- DescribeBackupMigration
- DeleteBackupMigration
- DescribeUploadBackupInfo
- CreateIncrementalMigration
- ModifyIncrementalMigration
- StartIncrementalMigration
- DescribeIncrementalMigration
- DescribeBackupCommand
- DescribeBackupUploadSize
- DeleteIncrementalMigration
- Data migration (DTS old version) related APIs
- Making API Requests
- Database APIs
- Other APIs
- Data Types
- Error Codes
- FAQs
- Overview
- Model Selection
- Pricing and Selection
- Connection and Network
- Account and Permission
- Backup and Rollback
- Data Migration
- Publish/Subscribe
- Read-Only Instance
- Version and Architecture Upgrade
- Disk Space and Specification Adjustment
- Monitoring and Alarms
- Log
- Parameter Modification
- Features
- Performance/Space/Memory
- Service Agreement
- Performance Evaluation
- Glossary
- Contact Us
You can create, view, and terminate read-only instances in the TencentDB for SQL Server console.
Note:
Single-node (cloud disk) instances do not support the addition of read-only instances.
Read-only instances cannot be purchased and used separately. They should be bound to a primary instance (Two-Node Edition, formerly High-Availability Edition/Cluster Edition) for use.
An RO group containing only 1 read-only instance has a risk of single point of failure, and this RO group will not be included in the overall availability calculation for the TencentDB for SQL Server. A single read-only instance does not provide availability SLA guarantees. It is recommended to purchase at least 2 read-only instances for an RO group to ensure its availability.
Feature Limits
Up to 5 read-only instances can be created for a primary instance.
Currently, read-only instances are not supported for Standard Edition.
Currently, instances in finance zones do not support scaling of read-only instances. If scaling is needed, see Publish-Subscribe.
Read-Only instances do not support backup and rollback.
Data cannot be migrated to read-only instances.
Read-Only instances do not support database creation/deletion. If needed, please operate on a primary instance.
Read-Only instances do not support account creation/deletion/authorization and account name/password change. If needed, please operate on a primary instance.
Differences Between Read-Only Instances of Different Versions
The read-only instances of different versions have differences. If the business requires using read-only instances, it is recommended to use database instances of the 2017 version or later.
For versions earlier than 2017, the publish-subscribe method is used to build read-only instances, with an object-level synchronization delay of 3 to 5 seconds. If you need to use the read-only instance feature, it is recommended to upgrade the primary instance to the 2017 version or later, to ensure efficient and stable data synchronization.
The 2017 version of Enterprise two-node (formerly High-Availability Edition/Cluster Edition) architecture and later versions use the Always-On method to build read-only instances, with a synchronization delay of 1 to 2 seconds, achieving more efficient and stable data synchronization.
Regions Supported by Read-Only Instances
Region | Availability Zone | Cloud Disk Edition RO | Local Disk RO |
Guangzhou ap-guangzhou | Guangzhou Zone 3 ap-guangzhou-3 | × | ✓ |
| Guangzhou Zone 6 ap-guangzhou-6 | ✓ | × |
| Guangzhou Zone 7 ap-guangzhou-7 | ✓ | × |
Shanghai ap-shanghai | Shanghai Zone 2 ap-shanghai-2 | ✓ | ✓ |
| Shanghai Zone 3 ap-shanghai-3 | × | ✓ |
| Shanghai Zone 4 ap-shanghai-4 | ✓ | ✓ |
| Shanghai Zone 5 ap-shanghai-4 | ✓ | × |
Nanjing ap-nanjing | Nanjing Zone 1 ap-nanjing-1 | ✓ | ✓ |
| Nanjing Zone 2 ap-nanjing-2 | ✓ | ✓ |
Beijing ap-beijing | Beijing Zone 1 ap-beijing-1 | × | ✓ |
| Beijing Zone 2 ap-beijing-2 | × | ✓ |
| Beijing Zone 3 ap-beijing-3 | ✓ | ✓ |
| Beijing Zone 4 ap-beijing-4 | × | × |
| Beijing Zone 5 ap-beijing-5 | × | ✓ |
| Beijing Zone 6 ap-beijing-6 | ✓ | × |
| Beijing Zone 7 ap-beijing-7 | ✓ | × |
Chengdu ap-chengdu | Chengdu Zone 1 ap-chengdu-1 | ✓ | × |
| Chengdu Zone 2 ap-chengdu-2 | ✓ | × |
Chongqing ap-chongqing | Chongqing Zone 1 ap-chongqing-1 | ✓ | × |
Hong Kong (China) ap-hongkong | Hong Kong (China) Zone 1 ap-hongkong-1 | × | ✓ |
| Hong Kong (China) Zone 2 ap-hongkong-2 | ✓ | ✓ |
| Hong Kong (China) Zone 3 ap-hongkong-3 | ✓ | × |
Region | Availability Zone | Cloud Disk Edition RO | Local Disk RO |
Singapore ap-singapore | Singapore Zone 1 ap-singapore-1 | × | × |
| Singapore Zone 2 ap-singapore-2 | × | × |
| Singapore Zone 3 ap-singapore-3 | ✓ | × |
| Singapore Zone 4 ap-singapore-4 | ✓ | × |
Jakarta ap-jakarta | Jakarta Zone 1 ap-jakarta-1 | ✓ | × |
| Jakarta Zone 2 ap-jakarta-2 | ✓ | × |
Bangkok ap-bangkok | Bangkok Zone 1 ap-bangkok-1 | ✓ | × |
| Bangkok Zone 2 ap-bangkok-2 | ✓ | × |
Seoul ap-seoul | Seoul Zone 1 ap-seoul-1 | ✓ | × |
| Seoul Zone 2 ap-seoul-2 | ✓ | × |
Tokyo ap-tokyo | Tokyo Zone 1 ap-tokyo-1 | ✓ | × |
| Tokyo Zone 2 ap-tokyo-2 | ✓ | × |
Region | Availability Zone | Cloud Disk Edition RO | Local Disk RO |
Virginia na-ashburn | Virginia Zone 1 na-ashburn-1 | ✓ | × |
| Virginia Zone 2 na-ashburn-2 | ✓ | × |
Frankfurt eu-frankfurt | Frankfurt Zone 1 eu-frankfurt-1 | ✓ | × |
| Frankfurt Zone 2 eu-frankfurt-2 | ✓ | × |
Silicon Valley na-siliconvalley | Silicon Valley Zone 1 na-siliconvalley-1 | ✓ | × |
| Silicon Valley Zone 2 na-siliconvalley-2 | ✓ | × |
Sao Paulo sa-saopaulo | São Paulo Zone 1 sa-saopaulo-1 | ✓ | × |
Read-Only Instance Details Page
The Instance Details page of read-only instances is shown below:
Feature Area | Illustration | Feature | Description |
Topology diagram (architecture diagram) |  | Read-only group address | You can hover the mouse over the read-only group address in the topology diagram to quickly view the read-only group address and configure the read-only group. For details, see Read-Only Group. |
|  | Read-only instance | You can hover the mouse over the read-only instance in the topology diagram to quickly view the private network address and public network address of the read-only instance. Click the + icon on the read-only instance in the topology diagram to create a read-only instance. |
|  | Read-only instance storage | You can hover the mouse over the read-only instance storage in the topology diagram to view the usage of the read-only instance storage space. Click Scale-out to enter the configuration adjustment page for setup. |
|  | Topology diagram view scale | You can adjust the display scale of the topology diagram. |
| - | Gray area in the topology diagram | The gray area in the topology diagram indicates the deployment architecture of the primary instance to which this read-only instance belongs. Click operations are not supported in the gray area. |
Instance information (on the right side) |  | Hiding/Showing instance information | You can hide or show the instance information section. |
|  | Current Read-Only Instance | Under the current read-only instance on the right side, you can view the read-only instance information such as private network address, public network address, network, instance status, availability zone, edition, architecture, configuration, and weight. Available operations include read-only group configuration, changing network, enabling public network address, and adjusting configuration. |
|  | View the details of the associated primary instance | After viewing the details of the associated primary instance on the right side, you can click the primary instance ID to enter the details page of the primary instance to which this read-only instance belongs. |
Creating Read-Only Instances
1. Log in to the TencentDB for SQL Server console. In the instance list, click the Instance ID or Manage in the Operation column to enter the details page.
2. On the Instance Details page, click the + icon in the read-only instance area of the topology diagram, or select the Read-Only Instance tab and click Create to enter the purchase page.
3. On the purchase page, select the corresponding configurations for the read-only instance. After confirming no errors, click Buy Now to purchase the read-only instance.
Note:
If you need to align the expiration date of the read-only instance with that of the primary instance, you can set a unified expiration date in the Renewal Management console. For detailed operation steps, see Unified Expiration Date.
Viewing Read-Only Instance
1. Log in to the TencentDB for SQL Server console. In the instance list, instances with an R flag are read-only instances. Click an instance ID or Manage in the Operation column to enter the read-only instance details page.
2. In the instance information on the right side of the Instance Details page, you can view the bound primary instance. Click the Instance ID to enter the details page of the primary instance. You can also enter the details page of the read-only instance from the topology diagram of the primary instance.
Note:
Some features on the Instance Details page of the read-only instance are consistent with the configurations of the primary instance and cannot be modified. If necessary, you can modify them on the Instance Details page of the primary instance.
Terminating Read-Only Instance
An read-only instance can be terminated in the same way as a primary instance as instructed in Terminating Instance.
Yes
No
Was this page helpful?