tencent cloud


Common Concepts

Last updated: 2022-05-31 16:54:23

This document describes the common concepts of TencentDB for SQL Server to help you better understand and use it.

  • Tencent Cloud console: Web-based UIs.

  • Region: A physical IDC. In general, a TencentDB for SQL Server instance and a CVM instance should be in the same region to achieve the best access performance.

  • Availability zone (AZ): A physical location with independent power supply and network resources within a region. There are no substantial differences between different AZs in the same region.

  • Multi-AZ: A physical location created by combining multiple AZs in the same region.

  • Instance: A TencentDB for SQL Server resource in Tencent Cloud.

  • Read-only instance: An instance that can only be read from.

  • RO group: A group of read-only instances.

  • Billing mode: The billing mode of an instance resource, which is pay-as-you-go.

  • Pay-as-you-go: A postpaid billing mode, where you can apply for resources for on-demand use and will be charged based on the actual usage upon settlement.

  • Instance type: Instance types include Basic Edition, Cluster Edition, and Dual-Server High Availability Edition, which have different deployment architectures.

  • Basic Edition: A TencentDB for SQL Server Basic Edition instance is also called a standalone instance. It has only one database node, separates computing and storage, and is very cost-effective.

  • High Availability Edition: An High Availability Edition instance consists of a primary instance and a replica instance. When the former fails and cannot be accessed, the system will automatically switch to the latter.

  • Cluster Edition: Cluster Edition instances adopt the Always On architecture, including one primary instance and one replica instance deployed across racks/AZs, separate computing and storage, and allow purchasing read-only instances for read/write separation.

  • Engine versions: Compatible database versions. Currently, the following versions are supported: 2008 R2 Enterprise, 2012 Enterprise, 2016 Enterprise, 2017 Enterprise, and 2019 Enterprise.

  • Specification: Resource configuration of each node, such as 2-core 16 GB MEM.

  • Disk: The main storage device of a computer, i.e., data storage space.

  • High-performance local SSD: High-I/O local disk storage type.

SSD cloud disk: All-flash cloud disk storage type with NVMe SSD as the storage media. It adopts a three-copy distributed storage mechanism to provide low-latency and high-throughput I/O capabilities with a high random IOPS and 99.9999999% data security.

  • High-performance cloud disk: Hybrid storage type. It provides high-performance storage capabilities close to SSD through the cache mechanism and adopts a three-copy distributed mechanism to ensure the data reliability.

  • Project: Used to categorize and manage instance resources.

  • Tag: A cloud resource management tool that allows you to use different standards to categorize, search for, and aggregate cloud resources with the same attributes.

  • Maintenance time: To ensure the stability of your TencentDB instance, the backend system performs maintenance operations on the instance during the maintenance window from time to time. We highly recommend you set an acceptable maintenance time for your business instance, usually during off-peak hours, so as to minimize the potential impact on your business.

  • Security group: Security access control to instances by specifying IP, protocol, and port rules for instance access.

  • Network: A network made up of several nodes and linkages that connect them. It represents many objects and their interconnections. For performance and security considerations, only VPC network is supported currently.

  • Private network address: The IP and port assigned to a database for both read and write requests within your VPC network.

  • Port: A port in a computer, switch, or router.

  • Database: A set of organized, shared, and centrally managed data that is stored on a computer for a long period.

  • Database account: A username used to log in to and manage a database.

  • Character set: A mapping relationship or encoding rule, including a coded character set and character encoding. The code points corresponding to a character set are mapped into binary sequences, so that they can be stored and processed by a computer.

  • Cloud Virtual Machine (CVM): A scalable computing service provided by Tencent Cloud.

  • SSMS: SQL Server Management Studio (SSMS) is an integrated environment to manage any SQL basic structures.

  • Alarm policy: You can create alarms to stay informed of the status changes of certain metrics. The specific metrics will be monitored for a certain period of time, and alarm notifications will be sent by SMS, email, and phone at specified intervals based on the given threshold.

  • Pub/Sub: Business data replication and sync. You can create, change, and delete pub/sub servers in the TencentDB for SQL Server console.

  • Recycle bin: A place where terminated instances are stored before elimination. Such instances can be restored.

  • Backup: Data is stored separately or as a file copy to tackle possible unexpected situations such as file or data loss or corruption.

  • Automatic backup: You can set the backup time and cycle for the system to automatically and regularly save data.

  • Manual backup: You can manually create backup files at any time.

  • Data backup: You can back up one, multiple, or all databases in an instance.

  • Log backup: The system automatically generates a log backup (log file) every 30 minutes and uploads it to the cloud for storage. You can download log files.

  • Backup policy: You can select instance backup or multi-database backup. The former backs up all databases in an instance, while the latter backs up selected databases.

  • Backup task configuration: It is used to set the global variables of manual and scheduled backups. You can set Upload Backup File (archive file or unarchived files) and select the primary or replica instance for backup.

  • Upload backup file: It is used to set whether to use an archive file or unarchived files for instance backup.

Contact Us

Contact our sales team or business advisors to help your business.

Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

7x24 Phone Support