Este conteúdo foi traduzido por máquina para sua conveniência e a Huawei Cloud não pode garantir que o conteúdo foi traduzido com precisão. Para exibir o conteúdo original, use o link no canto superior direito para mudar para a página em inglês.

Central de ajuda/ Relational Database Service/ Primeiros passos/ Primeiros passos com RDS for SQL Server/ Passo 1: comprar uma instância de BD

Atualizado em 2023-08-29 GMT+08:00

Ver PDF

Passo 1: comprar uma instância de BD

Scenarios

This section describes how to create a DB instance on the RDS console.

Currently, RDS for SQL Server supports the yearly/monthly and pay-per-use billing modes. The DB instance class and storage space you need depend on your processing power and memory requirements.

Prerequisites

You have registered a Huawei ID and enabled Huawei Cloud services.

Procedure

Faça logon no console de gerenciamento.
Clique em no canto superior esquerdo e selecione uma região e um projeto.
Click in the upper left corner of the page and choose Databases > Relational Database Service.
On the Instances page, click Buy DB Instance.

On the displayed page, select a billing mode and configure information about your DB instance. Then, click Next.

RDS provides the following billing modes:
- Yearly/Monthly: If you select this mode, skip 6 and go to 7.
- Pay-per-use: If you select this mode, go to 6.

Basic information

**Tabela 1** Basic information
Parameter	Description
Region	Region where your resources are located. NOTA: Products in different regions cannot communicate with each other through a private network and you cannot change the region of a DB instance after creating the instance. Therefore, exercise caution when selecting a region.
DB Instance Name	Must start with a letter and consist of 4 to 64 characters. Only letters (case-sensitive), digits, hyphens (-), and underscores (_) are allowed. If you intend to create multiple DB instances and read replicas at a time, the allowed length for each instance name will change. If you buy multiple DB instances at a time, they will be named instance-0001, instance-0002, and so on. (instance indicates the DB instance name you specify.)
DB Engine	Set to Microsoft SQL Server.
DB Engine Version	For details, see DB Engines and Versions. Different DB engine versions are supported in different regions. You are advised to select the latest available version because it is more stable, reliable, and secure.
DB Instance Type	Primary/Standby: uses an HA architecture with a primary DB instance and a synchronous standby DB instance. It is suitable for production databases of large- and medium-sized enterprises in Internet, Internet of Things (IoT), retail e-commerce sales, logistics, gaming, and other sectors. The standby DB instance improves instance reliability and is invisible to you after being created. An AZ is a physical region where resources use independent power supply and networks. AZs are physically isolated but interconnected through an internal network. Some regions support both single AZs and multiple AZs and some only support single AZs. To achieve high reliability, RDS will automatically deploy your primary and standby instances in different physical servers even if you deploy them in the same AZ. If you attempt to create primary/standby DB instances in the same AZ in a Dedicated Computing Cluster (DCC) and there is only one physical server available, the creation will fail. You can deploy primary and standby DB instances in a single AZ or across AZs to achieve failover and high availability. Single: uses a single-node architecture, which is more cost-effective than primary/standby DB instances. It is suitable for development and testing of microsites, and small- and medium-sized enterprises, or for learning about RDS.
Storage Type	Determines the DB instance read/write speed. The higher the maximum throughput is, the higher the DB instance read/write speed can be. Cloud SSD: supports a maximum throughput of 350 MB/s. Extreme SSD: uses 25GE network and RDMA technologies to provide you with up to 1,000 MB/s throughput per disk and sub-millisecond latency. NOTA: If you have purchased the Dedicated Distributed Storage Service (DSS), only the storage type that you have selected when you buy the DSS service is displayed. The supported IOPS depends on the I/O performance of Elastic Volume Service (EVS) disks. For details, see the description about ultra-high I/O in Disk Types and Performance of Elastic Volume Service Service Overview.
Time Zone	Select your time zone when you are creating a DB instance. After the DB instance is created, the time zone cannot be modified. For details, see Tabela 2.
Server Collation	Defines a collation of a database or table column, or a collation cast operation when applied to character string expression. It acts as the default collation for the DB instance.

**Tabela 2** Mapping between time zones and UTC offsets
Time Zone	Standard Time Offset	Remarks
Afghanistan Standard Time	UTC+04:30	Kabul
Alaskan Standard Time	UTC-09:00	Alaska
Arabian Standard Time	UTC+04:00	Abu Dhabi, Muscat
Atlantic Standard Time	UTC-04:00	Atlantic Time (Canada)
AUS Central Standard Time	UTC+09:30	Darwin
AUS Eastern Standard Time	UTC+10:00	Canberra, Melbourne, Sydney
Belarus Standard Time	UTC+03:00	Minsk
Canada Central Standard Time	UTC-06:00	Saskatchewan
Cape Verde Standard Time	UTC-01:00	Cape Verde Is.
Cen. Australia Standard Time	UTC+09:30	Adelaide
Central America Standard Time	UTC-06:00	Central America
Central Asia Standard Time	UTC+06:00	Astana
Central Brazilian Standard Time	UTC-04:00	Cuiaba
Central European Standard Time	UTC+01:00	Belgrade, Bratislava, Budapest, Ljubljana, Prague
Central European Standard Time	UTC+01:00	Sarajevo, Skopje, Warsaw, Zagreb
Central Pacific Standard Time	UTC+11:00	Solomon Islands, New Caledonia
Central Standard Time	UTC-06:00	Central Time (US and Canada)
China Standard Time	UTC+08:00	Beijing, Chongqing, Hong Kong, and Urumqi
E. Africa Standard Time	UTC+03:00	Nairobi
E. Australia Standard Time	UTC+10:00	Brisbane
E. Europe Standard Time	UTC+02:00	Chisinau
E. South America Standard Time	UTC-03:00	Brasilia
Eastern Standard Time	UTC-05:00	Eastern Time (US and Canada)
Georgian Standard Time	UTC+04:00	Tbilisi
GMT Standard Time	UTC	Dublin, Edinburgh, Lisbon, London
Greenland Standard Time	UTC-03:00	Greenland
Greenwich Standard Time	UTC	Monrovia, Reykjavik
GTB Standard Time	UTC+02:00	Athens, Bucharest
Hawaiian Standard Time	UTC-10:00	Hawaii
India Standard Time	UTC+05:30	Chennai, Kolkata, Mumbai, New Delhi
Jordan Standard Time	UTC+02:00	Amman
Korea Standard Time	UTC+09:00	Seoul
Middle East Standard Time	UTC+02:00	Beirut
Mountain Standard Time	UTC-07:00	Mountain Time (US and Canada)
US Mountain Standard Time	UTC-07:00	Arizona
New Zealand Standard Time	UTC+12:00	Auckland, Wellington
Newfoundland Standard Time	UTC-03:30	Newfoundland
Pacific SA Standard Time	UTC-03:00	Santiago
Pacific Standard Time	UTC-08:00	Pacific Time (US and Canada)
Russian Standard Time	UTC+03:00	Moscow/St. Petersburg
SA Pacific Standard Time	UTC-05:00	Bogota, Lima, Quito, Rio Branco
SE Asia Standard Time	UTC+07:00	Bangkok, Hanoi, Jakarta
China Standard Time	UTC+08:00	Kuala Lumpur, Singapore
Tokyo Standard Time	UTC+09:00	Osaka, Sapporo, Tokyo
US Eastern Standard Time	UTC-05:00	Indiana (East)
UTC	UTC	Coordinated Universal Time
UTC-02	UTC-02:00	Coordinated Universal Time–02
UTC-08	UTC-08:00	Coordinated Universal Time–08
UTC-09	UTC-09:00	Coordinated Universal Time–09
UTC-11	UTC-11:00	Coordinated Universal Time–11
UTC+12	UTC+12:00	Coordinated Universal Time+12
W. Australia Standard Time	UTC+08:00	Perth
W. Central Africa Standard Time	UTC+01:00	West Central Africa
W. Europe Standard Time	UTC+01:00	Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna

DB instance specifications

**Tabela 3** Instance specifications
Parameter	Description
Instance Class	Refers to the vCPU and memory of a DB instance. Different instance classes have different numbers of database connections and different maximum IOPS. After a DB instance is created, you can change its vCPU and memory. For details, see Changing a DB Instance Class. NOTA: DB instances in a DCC only support the general-enhanced instance class.
Resource Type	EVS DSS NOTA: This option is displayed only when you buy the DSS service.
Storage Pool	Displayed only when you select DSS for Resource Type. The storage pool is secure because it is physically isolated from other pools.
Storage Space (GB)	Contains the file system overhead required for inode, reserved block, and database operation. Storage space can range in size from 40 GB to 4,000 GB and can be scaled up only by a multiple of 10 GB. After a DB instance is created, you can scale up its storage space. For details, see Scaling up Storage Space.
Disk Encryption	Disable: indicates the encryption function is disabled. Enable: indicates the encryption function is enabled, improving data security but affecting system performance. Key Name: indicates the tenant key. You can create or select a key. NOTA: If you enable disk encryption during instance creation, the disk encryption status and the key cannot be changed later. Disk encryption will not encrypt backup data stored in OBS. If disk encryption is enabled, keep the key properly. Once the key is disabled, deleted, or frozen, the database will be unavailable. For details about how to create a key, see Creating a CMK in the Data Encryption Workshop User Guide.

Network and database configuration

**Tabela 4** Network
Parameter	Description
VPC	A dedicated virtual network in which your RDS DB instances are located. A VPC can isolate networks for different services. You can select an existing VPC or create a VPC. For details on how to create a VPC, see the "Creating a VPC" section in the Virtual Private Cloud User Guide. If no VPC is available, RDS allocates a VPC to you by default. AVISO: After the DB instance is created, the VPC cannot be changed.
Subnet	Improves network security by providing dedicated network resources that are logically isolated from other networks. Subnets take effect only within an AZ. The Dynamic Host Configuration Protocol (DHCP) function is enabled by default for subnets in which you plan to create RDS DB instances and cannot be disabled. A floating IP address is automatically assigned when you create a DB instance. You can also enter an unused floating IP address in the subnet CIDR block. After the DB instance is created, you can change the floating IP address.
Security Group	Enhances security by controlling access to RDS from other services. In addition, a network access control list (ACL) can help control inbound and outbound traffic of subnets in your VPC. Ensure that the security group you select allows the client to access the DB instance. When creating a DB instance, you can select multiple security groups. For better network performance, you are advised to select no more than five security groups. In such a case, the access rules of all the selected security groups apply on the instance. If no security group is available, RDS allocates a security group to you by default. NOTA: To configure the Active Directory (AD) domain for the DB instance, ensure that the DB instance and domain controller must be in the same security group.

**Tabela 5** Database configuration
Parameter	Description
Password	Configure (default setting): Configure a password for your DB instance during the creation process. Skip: Configure a password later after the DB instance is created. AVISO: If you select Skip for Password, you need to reset the password before you can log in to the instance. After a DB instance is created, you can reset the password. For details, see Resetting the Administrator Password.
Administrator	The default login name for the database is rdsuser.
Administrator Password	Must consist of 8 to 32 characters and contain at least three types of the following characters: uppercase letters, lowercase letters, digits, and special characters (~!@#$%^*-_+?,). Enter a strong password and periodically change it for security reasons. If the password you provide is regarded as a weak password by the system, you will be prompted to enter a stronger password. Keep this password secure. The system cannot retrieve it. After a DB instance is created, you can reset this password. For details, see Resetting the Administrator Password.
Confirm Password	Must be the same as Administrator Password.
Parameter Template	Contains engine configuration values that can be applied to one or more DB instances. If you intend to create a primary/standby DB pair, they use the same parameter template. AVISO: If you use a custom parameter template when creating a DB instance, the specification-related parameter max server memory (MB) in the custom template is not delivered. Instead, the default value is used. You can modify the instance parameters as required after the DB instance is created. For details, see section Modifying Parameters in a Parameter Template.
Enterprise Project	If your account has been associated with an enterprise project, select the target project from the Enterprise Project drop-down list. For more information about enterprise projects, see Enterprise Management User Guide.

AD domain

**Tabela 6** AD domain
Parameter	Description
AD Domain	Allows an Active Directory user to authenticate with RDS for SQL Server DB instances. Active Directory (AD) is a directory service on Windows Standard Server, Windows Enterprise Server, and Windows Datacenter Server. Active Directory stores information about objects on the network and makes this information easy for administrators and users to find and use. Active Directory uses a structured data store as the basis for a logical, hierarchical organization of directory information. AVISO: To use AD domain, contact customer service to apply for the required permissions. When you configure AD domain information during the DB instance creation, do not configure or disable Group Policy Object (GPO) for your domain controller server. Otherwise, the DB instance creation will fail. If GPO is required, you need to comprar an ECS and set up a new domain controller server with GPO disabled. Then, establish trust between your domain controller server and the new domain controller server. For details, contact customer service. The domain controller server time must be synchronized to an NTP server. Non-standard time or too large time difference may cause DB instance creation failures. Skip: This option is selected by default. Configure: To configure the AD domain, you must first prepare a domain controller on an ECS or on-premises database. Then, configure the directory address, domain name, directory administrator, and directory administrator password as required. NOTA: If a single RDS for SQL Server instance is configured with the AD domain, it cannot be changed to primary/standby DB instances.
Directory Address	Enter the private IP address of the ECS that supports the AD domain. After the DB instance is created, you can view the directory address in the DB Information area on the Basic Information page. Example value: 192.168.x.x.
Domain Name	A fully qualified domain name, such as DBStest.com, must: Be the same as the ECS domain name. Be no more than 48 characters long. Only include letters, digits, dots (.), and hyphens (-). Include a valid top-level domain name which contains at least 2 characters long and contains only dots (.) and letters, for example, .com After the DB instance is created, you can view the directory address in the DB Information area on the Basic Information page.
Directory Administrator	You are advised to set this parameter to the domain administrator which belongs to the Domain Admins group (because high permissions are required for a client to add a domain).
Directory Administrator Password	Indicates the password of the directory administrator. Keep this password secure. The system cannot retrieve it.

**Tabela 7** Tags
Parameter	Description
Tag	Tags an RDS DB instance. This parameter is optional. Adding tags to RDS DB instances helps you better identify and manage the DB instances. A maximum of 20 tags can be added for each DB instance. After a DB instance is created, you can view its tag details on the Tags page. For details, see Managing Tags.

**Tabela 8** Purchase period
Parameter	Description
Required Duration	This option is available only for yearly/monthly DB instances. The system will automatically calculate the configuration fee based on the selected required duration. The longer the required duration is, the larger discount you will enjoy.
Auto-renew	This option is available only for yearly/monthly DB instances and is not selected by default. If you select this option, the auto-renew cycle is determined by the selected required duration.
Quantity	RDS supports batch creation of DB instances. If you intend to create primary/standby DB instances and set Quantity to 1, a primary DB instance and a synchronous standby DB instance will be created.